ADA-C01 Exam Questions

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

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 t...

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

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 d...

What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Choose two.)

An Administrator wants to delegate the administration of a company's data exchange to users who do not have access to the ACCOUNTADMIN role. How can this requirement be met?

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...

When does auto-suspend occur for a multi-cluster virtual warehouse?

A company has set up a new Snowflake account. An Identity Provider (IdP) has been configured for both Single Sign-On (SSO) and SCIM provisioning. What maintenance is required to en...

What are benefits of creating and maintaining resource monitors in Snowflake? (Choose three.)

DatabaseA has a single schema called Schema1. This schema contains many tables and views. The ANALYST role has privileges to select from all objects in DatabaseA. Schema1. The SYSA...

An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that will perfor...

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

A requirement has been identified to allow members of a corporate Data Product team to bring in data sets from the Snowflake Marketplace. The members of this team use the role DP_T...

The following commands were executed: Grant usage on database PROD to role PROD_ANALYST; Grant usage on database PROD to role PROD_SUPERVISOR; Grant ALL PRIVILEGES on schema PROD....

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...

What are characteristics of data replication in Snowflake? (Choose three.)

An Administrator has a user who needs to be able to suspend and resume a task based on the current virtual warehouse load, but this user should not be able to modify the task or st...

A Snowflake organization MYORG consists of two Snowflake accounts: The ACCOUNT1 has a database PROD_DB and the ORGADMIN role enabled. Management wants to have the PROD_DB database...

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

A Snowflake Administrator created a role ROLE_MANAGED_ACCESS and a schema SCHEMA_MANAGED_ACCESS as follows: USE ROLE SECURITYADMIN; CREATE ROLE ROLE_MANAGED_ACCESS; GRANT ROLE ROLE...

Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Choose two.)

Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?

A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database. For this warehouse, why should the Adm...

What SCIM integration types are supported in Snowflake? (Choose three.)

A team of developers created a new schema for a new project. The developers are assigned the role DEV_TEAM which was set up using the following statements: USE ROLE SECURITYADMIN;...

A large international company with many operating regions requires data to be shared bi- directionally among all offices (head office to regional offices and regional offices among...

What are benefits of using Snowflake organizations? (Choose two.)

A Snowflake account is configured with SCIM provisioning for user accounts and has bi- directional synchronization for user identities. An Administrator with access to SECURITYADMI...

Which type of listing in the Snowflake Marketplace can be added and queried immediately?

A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant. An application with the accountant role should...

What is required for stages, without credentials, to limit data exfiltration after a storage integration and associated stages are created?

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 num...

A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters bu...

A user with the proper role issues the following commands when setting up and activating network policies: CREATE OR REPLACE NETWORK POLICY foo_policy ALLOWED_IP_LIST = ( '1.1.1.0/...

An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it into different pro...

What access control policy will be put into place when future grants are assigned to both database and schema objects?

An Administrator is evaluating a complex query using the EXPLAIN command. The Globalstats operation indicates 500 partitionsAssigned. The Administrator then runs the query to compl...

If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?

Which Snowflake objects can be managed using SCIM integration? (Choose two.)

Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?

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

A user has enrolled in Multi-factor Authentication (MFA) for connecting to Snowflake. The user informs the Snowflake Administrator that they lost their mobile phone the previous ev...

A company enabled replication between accounts and is ready to replicate data across regions in the same cloud service provider. The primary database object is : PROD_AWS_EAST. Loc...

What roles can be used to create network policies within Snowflake accounts? (Choose three.)

In general, the monthly billing for database replication is proportional to which variables? (Choose two.)

Which statement allows this user to access this Snowflake account from a specific IP address (192.168.1.100) while blocking their access from anywhere else?

Review the output of the SHOW statement below which displays the current grants on the table DB1. S1. T1: This statement is executed: USE ROLE ACCOUNTADMIN; DROP ROLE A; What will...

A company's Snowflake account has multiple roles. Each role should have access only to data that resides in the given role's specific region. When creating a row access policy, whi...

An Administrator needs to create a sample of the table LINEITEM. The sample should not be repeatable and the sampling function should take the data by blocks of rows. What select c...