Snowflake ARA-C01 SnowPro Advanced Architect Certification Online Training

Question #1

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

A . The MERGE command
B . The UPSERT command
C . The CHANGES clause
D . A STREAM object
E . The CHANGE_DATA_CAPTURE command

Reveal Solution Hide Solution

Question #2

When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)

A . CSV
B . XML
C . Avro
D . JSON
E . Parquet

Reveal Solution Hide Solution

Question #3

At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?

A . Global
B . Database
C . Schema
D . Table

Reveal Solution Hide Solution

Question #4

An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously.

Which commands should the Architect use to load only file5.csv file from the stage? (Choose two.)

A . COPY INTO tablea FROM @%tablea RETURN_FAILED_ONLY = TRUE;
B . COPY INTO tablea FROM @%tablea;
C . COPY INTO tablea FROM @%tablea FILES = (‘file5.csv’);
D . COPY INTO tablea FROM @%tablea FORCE = TRUE;
E . COPY INTO tablea FROM @%tablea NEW_FILES_ONLY = TRUE;
F . COPY INTO tablea FROM @%tablea MERGE = TRUE;

Reveal Solution Hide Solution

Question #5

A large manufacturing company runs a dozen individual Snowflake accounts across its business divisions. The company wants to increase the level of data sharing to support supply chain optimizations and increase its purchasing leverage with multiple vendors.

The company’s Snowflake Architects need to design a solution that would allow the business divisions to decide what to share, while minimizing the level of effort spent on configuration and management. Most of the company divisions use Snowflake accounts in the same cloud deployments with a few exceptions for European-based divisions.

According to Snowflake recommended best practice, how should these requirements be met?

A . Migrate the European accounts in the global region and manage shares in a connected graph architecture. Deploy a Data Exchange.
B . Deploy a Private Data Exchange in combination with data shares for the European accounts.
C . Deploy to the Snowflake Marketplace making sure that invoker_share() is used in all secure views.
D . Deploy a Private Data Exchange and use replication to allow European data shares in the Exchange.

Reveal Solution Hide Solution

Correct Answer: B
B

Explanation:

According to Snowflake recommended best practice, the requirements of the large manufacturing company should be met by deploying a Private Data Exchange in combination with data shares for the European accounts. A Private Data Exchange is a feature of the Snowflake Data Cloud platform that enables secure and governed sharing of data between organizations. It allows Snowflake customers to create their own data hub and invite other parts of their organization or external partners to access and contribute data sets. A Private Data Exchange provides centralized management, granular access control, and data usage metrics for the data shared in the exchange1. A data share is a secure and direct way of sharing data between Snowflake accounts without having to copy or move the data. A data share allows the data provider to grant privileges on selected objects in their account to one or more data consumers in other accounts2. By using a Private Data Exchange in combination with data shares, the company can achieve the following benefits:

The business divisions can decide what data to share and publish it to the Private Data Exchange, where it can be discovered and accessed by other members of the exchange. This reduces the effort and complexity of managing multiple data sharing relationships and configurations.

The company can leverage the existing Snowflake accounts in the same cloud deployments to create the Private Data Exchange and invite the members to join. This minimizes the migration and setup costs and leverages the existing Snowflake features and security.

The company can use data shares to share data with the European accounts that are in different regions or cloud platforms. This allows the company to comply with the regional and regulatory requirements for data sovereignty and privacy, while still enabling data collaboration across the organization.

The company can use the Snowflake Data Cloud platform to perform data analysis and transformation on the shared data, as well as integrate with other data sources and applications. This enables the company to optimize its supply chain and increase its purchasing leverage with multiple vendors.

The other options are incorrect because they do not meet the requirements or follow the best practices. Option A is incorrect because migrating the European accounts to the global region may violate the data sovereignty and privacy regulations, and deploying a Data Exchange may not provide the level of control and management that the company needs. Option C is incorrect because deploying to the Snowflake Marketplace may expose the company’s data to unwanted consumers, and using invoker_share() in secure views may not provide the desired level of security and governance. Option D is incorrect because using replication to allow European data shares in the Exchange may incur additional costs and complexity, and may not be necessary if data shares can be used instead.

Reference: Private Data Exchange | Snowflake Documentation, Introduction to Secure Data Sharing | Snowflake Documentation

Question #6

A user has the appropriate privilege to see unmasked data in a column.

If the user loads this column data into another column that does not have a masking policy, what will occur?

A . Unmasked data will be loaded in the new column.
B . Masked data will be loaded into the new column.
C . Unmasked data will be loaded into the new column but only users with the appropriate privileges will be able to see the unmasked data.
D . Unmasked data will be loaded into the new column and no users will be able to see the unmasked data.

Reveal Solution Hide Solution

Question #7

How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?

A . Create multiple clustering keys for a table.
B . Create multiple materialized views with different cluster keys.
C . Create super projections that will automatically create clustering.
D . Create a clustering key that contains all columns used in the access paths.

Reveal Solution Hide Solution

Question #8

Company A would like to share data in Snowflake with Company B. Company B is not on the same

cloud platform as Company A.

What is required to allow data sharing between these two companies?

A . Create a pipeline to write shared data to a cloud storage location in the target cloud provider.
B . Ensure that all views are persisted, as views cannot be shared across cloud platforms.
C . Setup data replication to the region and cloud platform where the consumer resides.
D . Company A and Company B must agree to use a single cloud platform: Data sharing is only possible if the companies share the same cloud provider.

Reveal Solution Hide Solution

Correct Answer: C
C

Explanation:

According to the SnowPro Advanced: Architect documents and learning resources, the requirement to allow data sharing between two companies that are not on the same cloud platform is to set up data replication to the region and cloud platform where the consumer resides. Data replication is a feature of Snowflake that enables copying databases across accounts in different regions and cloud platforms. Data replication allows data providers to securely share data with data consumers across different regions and cloud platforms by creating a replica database in the consumer’s account. The replica database is read-only and automatically synchronized with the primary database in the provider’s account. Data replication is useful for scenarios where data sharing is not possible or desirable due to latency, compliance, or security reasons1. The other options are incorrect because they are not required or feasible to allow data sharing between two companies that are not on the same cloud platform. Option A is incorrect because creating a pipeline to write shared data to a cloud storage location in the target cloud provider is not a secure or efficient way of sharing data. It would require additional steps to load the data from the cloud storage to the consumer’s account, and it would not leverage the benefits of Snowflake’s data sharing features. Option B is incorrect because ensuring that all views are persisted is not relevant for data sharing across cloud platforms. Views can be shared across cloud platforms as long as they reference objects in the same database. Persisting views is an option to improve the performance of querying views, but it is not required for data sharing2. Option D is incorrect because Company A and Company B do not need to agree to use a single cloud platform. Data sharing is possible across different cloud platforms using data replication or other methods, such as listings or auto-fulfillment3.

Reference: Replicating Databases Across Multiple Accounts | Snowflake Documentation, Persisting Views | Snowflake

Documentation, Sharing Data Across Regions and Cloud Platforms | Snowflake Documentation

Question #9

What are some of the characteristics of result set caches? (Choose three.)

A . Time Travel queries can be executed against the result set cache.
B . Snowflake persists the data results for 24 hours.
C . Each time persisted results for a query are used, a 24-hour retention period is reset.
D . The data stored in the result cache will contribute to storage costs.
E . The retention period can be reset for a maximum of 31 days.
F . The result set cache is not shared between warehouses.

Reveal Solution Hide Solution

Question #10

Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)

A . Changing the name of the organization
B . Creating an account
C . Viewing a list of organization accounts
D . Changing the name of an account
E . Deleting an account
F . Enabling the replication of a database

Reveal Solution Hide Solution

Correct Answer: B, C, F
B, C, F

Explanation:

According to the SnowPro Advanced: Architect documents and learning resources, the organization-related tasks that can be performed by the ORGADMIN role are:

Creating an account in the organization. A user with the ORGADMIN role can use the CREATE ACCOUNT command to create a new account that belongs to the same organization as the current account1.

Viewing a list of organization accounts. A user with the ORGADMIN role can use the SHOW ORGANIZATION ACCOUNTS command to view the names and properties of all accounts in the organization2. Alternatively, the user can use the Admin » Accounts page in the web interface to view the organization name and account names3.

Enabling the replication of a database. A user with the ORGADMIN role can use the

SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function to enable database replication for an account in the organization. This allows the user to replicate databases across accounts in different regions and cloud platforms for data availability and durability4.

The other options are incorrect because they are not organization-related tasks that can be performed by the ORGADMIN role. Option A is incorrect because changing the name of the organization is not a task that can be performed by the ORGADMIN role. To change the name of an organization, the user must contact Snowflake Support3. Option D is incorrect because changing the name of an account is not a task that can be performed by the ORGADMIN role. To change the name of an account, the user must contact Snowflake Support5. Option E is incorrect because deleting an account is not a task that can be performed by the ORGADMIN role. To delete an account, the user must contact Snowflake Support.

Reference: CREATE ACCOUNT | Snowflake Documentation, SHOW ORGANIZATION ACCOUNTS | Snowflake Documentation, Getting Started with Organizations | Snowflake Documentation, SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER | Snowflake Documentation, ALTER ACCOUNT | Snowflake Documentation, [DROP ACCOUNT | Snowflake Documentation]

Snowflake ARA-C01 SnowPro Advanced Architect Certification Online Training