Free SnowPro Advanced: Architect Certification Exam ARA-C01 Exam Practice Test

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

• The MERGE command
• The UPSERT command
• The CHANGES clause
• A STREAM object
• Thee CHANGE_DATA_CAPTURE command

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

• What is required to allow data sharing between these two companies?
• Create a pipeline to write shared data to a cloud storage location in the target cloud provider.
• Ensure that all views are persisted, as views cannot be shared across cloud platforms.
• Setup data replication to the region and cloud platform where the consumer resides.
• 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.

An Architect needs to grant a group of ORDER_ADMIN users the ability to clean old data in an ORDERS table (deleting all records older than 5 years), without granting any privileges on the table. The group’s manager (ORDER_MANAGER) has full DELETE privileges on the table.How can the ORDER_ADMIN role be enabled to perform this data cleanup, without needing the DELETE privilege held by the ORDER_MANAGER role?

• Create a stored procedure that runs with caller’s rights, including the appropriate "> 5 years"business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
• Create a stored procedure that can be run using both caller’s and owner’s rights (allowing the user to specify which rights are used during execution), and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
• Create a stored procedure that runs with owner’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
• This scenario would actually not be possible in Snowflake – any user performing a DELETE on a table requires the DELETE privilege to be granted to the role they are using.

Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)

• They can include ORDER BY clauses.
• They cannot include nested subqueries.
• They can include context functions, such as CURRENT_TIME().
• They can support MIN and MAX aggregates.
• They can support inner joins, but not outer joins.

A user can change object parameters using which of the following roles?

• ACCOUNTADMIN, SECURITYADMIN
• SYSADMIN, SECURITYADMIN
• ACCOUNTADMIN, USER with PRIVILEGE
• SECURITYADMIN, USER with PRIVILEGE

What integration object should be used to place restrictions on where data may be exported?

• Stage integration
• Security integration
• Storage integration
• API integration

Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)

• SYSTEM$CLUSTERING_INFORMATION
• SYSTEM$CLUSTERING_USAGE
• SYSTEM$CLUSTERING_DEPTH
• SYSTEM$CLUSTERING_KEYS
• SYSTEM$CLUSTERING_PERCENT

An Architect would like to save quarter-end financial results for the previous six years. Which Snowflake feature can the Architect use to accomplish this?

• Search optimization service
• Materialized view
• Time Travel
• Zero-copy cloning
• Secure views

An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect’s highest priority is to configure the connector to stream data in the MOST cost-effective manner.Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?

• Utilize a higher Buffer.flush.time in the connector configuration.
• Utilize a higher Buffer.size.bytes in the connector configuration.
• Utilize a lower Buffer.size.bytes in the connector configuration.
• Utilize a lower Buffer.count.records in the connector configuration.

A company’s client application supports multiple authentication methods, and is using Okta.What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?

• OAuth (either Snowflake OAuth or External OAuth)
• External browser
• Okta native authentication
• Key Pair Authentication, mostly used for service account users
• Password B.
• External browser, SSO
• Key Pair Authentication, mostly used for development environment users
• Okta native authentication
• OAuth (ether Snowflake OAuth or External OAuth)
• Password C.
• Okta native authentication
• Key Pair Authentication, mostly used for production environment users
• Password
• OAuth (either Snowflake OAuth or External OAuth)
• External browser, SSO D.
• Password
• Key Pair Authentication, mostly used for production environment users
• Okta native authentication
• OAuth (either Snowflake OAuth or External OAuth)
• External browser, SSO