Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

SNOWPRO-ADVANCED-ADMINISTRATOR by Snowflake - Page 1 | ExamCademy

Mode Selection

Sort:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 3 • Questions 1-25 of 65

1 2 3

→

Know a question that should be here? Contribute to this exam

Which authentication methods are available when connecting to Snowflake using the SQL API? (Choose two.)

A OAuth
B Key pair
C Username and password
D External browser
E Single Sign-On (SSO) with an external Identity Provider (IdP)

What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?

A Any role with GRANT USAGE on SECURITY INTEGRATION
B ACCOUNTADMIN and SYSADMIN
C ACCOUNTADMIN and SECURITYADMIN
D ACCOUNTADMIN only

What is a characteristic of Snowflake's transaction locking and concurrency modeling?

A A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.
B If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.
C Transaction locking in Snowflake is enforced exclusively at the row and table levels.
D Queries executed within a given transaction see that transaction's uncommitted changes.

A Snowflake Administrator created a role ROLE_MANAGED_ACCESS and a schema SCHEMA_MANAGED_ACCESS as follows:

Question Image

The Administrator now wants to disable the managed access on the schema.
How can this be accomplished?

A ALTER SCHEMA SCHEMA_MANAGED_ACCESS DISABLE MANAGED ACCESS;
B USE ROLE ROLE_MANAGED_ACCESS;DROP SCHEMA WORK.SCHEMA_MANAGED_ACCESS;CREATE SCHEMA SCHEMA_MANAGED_ACCESS;Then recreate all needed objects.
C REVOKE SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA_MANAGED_ACCESS FROMROLE MANAGED ACCESS;ALTER SCHEMA SCHEMA_MANAGED_ACCESS DISABLE MANAGED ACCESS;
D USE ROLE ROLE_MANAGED_ACCESS;DROP SCHEMA WORK.SCHEMA_MANAGED_ACCESS;CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITHOUT MANAGED ACCESS;Then recreate all needed objects.

When a role is dropped, which role inherits ownership of objects owned by the dropped role?

A The SYSADMIN role
B The role above the dropped role in the RBAC hierarchy
C The role executing the command
D The SECURITYADMIN rote

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

A The account requires at least one ORGADMIN rote within one of the organization's accounts.
B The account name is immutable and cannot be changed.
C The account name must be specified when the account is created.
D The account name must be unique among all Snowflake customers.
E The account name must be unique within the organization.

For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?

A The account_level policy will override the user_level policy.
B The user_level policy will override the account_level policy.
C The user_level network policies will not be supported.
D A network policy error will be generated with no definitions provided.

An Administrator receives data from a Snowflake partner. The partner is sharing a dataset that contains multiple secure views. The Administrator would like to configure the data so that only certain roles can see certain secure views.
How can this be accomplished?

A Apply RBAC directly onto the partner's shared secure views.
B Individually grant imported privileges onto the schema in the share.
C Clone the data and insert it into a company-owned share and apply the desired RBAC on the new tables.
D Create views over the incoming shared database and apply the desired RBAC onto these views.

A Snowflake organization MYORG consists of two Snowflake accounts:

Question Image

The ACCOUNT1 has a database PROD_DB and the ORGADMIN role enabled.
Management wants to have the PROD_DB database replicated to ACCOUNT2.
Are there any necessary configuration steps in ACCOUNT1 before the database replication can be configured and initiated in ACCOUNT2?

A
B
C No configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.
D It is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.

The following SQL command was executed:

Question Image

Which role(s) can alter or drop table XYZ?

A Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.
B SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
C PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
D Only the PROD_WORKING_OWNER role can alter or drop table XYZ.

What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?

A MIMIC_CONSUMER_ACCOUNT
B TEST_ACCOUNT_ID
C PRODUCER_TEST_ACCT
D SIMULATED_DATA_SHARING_CONSUMER

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? (Choose two.)

A 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.
B Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.
C Increase the multi-cluster maximum to 20 or more clusters.
D Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.
E Increase the minimum number of clusters started in the multi-cluster configuration to 5.

A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTS rather than bulk loading of large extracts. That single warehouse has been configured as a single cluster, 2XL because there are many parallel INSERTs that are scheduled during nightly loads.
How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?

A There should be another 2XL warehouse deployed to handle a portion of the load queries.
B The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.
C The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.
D The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.

SNOWPRO-ADVANCED-ADMINISTRATORPreview

Mode Selection

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

That's the end of the Preview