SnowPro Advanced Administrator (ADA-C01) Free Practice Test

Question 1

A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business Critical edition. The minimum number of clusters is set to 2 and the maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.
Which solutions will address the issues happening once a month? (Select TWO).

A. Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.

B. Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.

C. Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.

D. Increase the minimum number of clusters started in the multi-cluster configuration to 5.

E. Increase the multi-cluster maximum to 20 or more clusters.

Correct Answer: B,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

An Administrator needs to implement an access control mechanism across an organization. The organization users access sensitive customer data that comes from different regions and needs to be accessible for Analysts who work in these regions. Some Analysts need very specific access control depending on their functional roles in the organization. Following Snowflake recommended practice, how should these requirements be met? (Select TWO).

A. Implement row access policies and Dynamic Data Masking policies.

B. Use a third-party tool to share the data.

C. Include masking rules as part of data ingestion and transformation pipelines.

D. Use zero-copy cloning to replicate the database schema and provide access as needed.

E. Implement views on top of base tables that exclude or mask sensitive data.

Correct Answer: A,E

Question 3

A data provider wants to share data from multiple databases with a data consumer account.
How can this be accomplished?

A. The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege on each database referenced by the secure view.

B. The data provider needs to create a secure view and grant the USAGE privilege on each database referenced by the secure view.

C. The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege to a database role to include objects from multiple databases in a share

D. The data provider needs to create a secure view and must grant the REFERENCE_USAGE privilege on the database where the secure view is created.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

The following SQL command was executed:
Use role SECURITYADMIN;
Grant ownership
On future tables
In schema PROD. WORKING
To role PROD_WORKING_OWNER;
Grant role PROD_WORKING_OWNER to role SYSADMIN;
Use role ACCOUNTADMIN;
Create table PROD.WORKING.XYZ (value number) ;
Which role(s) can alter or drop table XYZ?

A. SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.

B. PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.

C. Only the PROD_WORKING_OWNER role can alter or drop table XYZ.

D. Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

A company has implemented Snowflake replication between two Snowflake accounts, both of which are running on a Snowflake Enterprise edition. The replication is for the database APP_DB containing only one schema, APP_SCHEMA. The company's Time Travel retention policy is currently set for 30 days for both accounts. An Administrator has been asked to extend the Time Travel retention policy to 60 days on the secondary database only.
How can this requirement be met?

A. Set the data retention policy on the schemas in the secondary database to 60 days.

B. Set the data retention policy on the primary database to 60 days.

C. Set the data retention policy on the primary database to 30 days and the schemas to 60 days.

D. Set the data retention policy on the secondary database to 60 days.

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

What information is required from the Identity Provider (IdP) to enable federated authentication in Snowflake? (Select TWO).

A. IdP encryption key

B. IdP account details

C. URL endpoint for SAML requests

D. Authentication certificate

E. SAML response format

Correct Answer: C,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

What are characteristics of data replication in Snowflake? (Select THREE).

A. Users can have unlimited primary databases and they can be replicated to an unlimited number of accounts if all accounts are within the same organization.

B. To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.

C. The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.

D. Users must be granted REPLICATIONADMIN privileges in order to enable replication.

E. Databases created from shares can be replicated.

F. Replication can only occur within the same cloud provider.

Correct Answer: A,C,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

What are the requirements when creating a new account within an organization in Snowflake? (Select TWO).

A. The account name must be unique among all Snowflake customers.

B. The account name must be specified when the account is created.

C. The account requires at least one ORGADMIN role within one of the organization's accounts.

D. The account name is immutable and cannot be changed.

E. The account name must be unique within the organization.

Correct Answer: B,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Snowflake SnowPro Advanced Administrator (ADA-C01) Free Practice Test