ADA-C02 practice questions 1–5

1. Question 1 · 5 in bank

   Select 2

   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 SYSADMIN role clones DatabaseA to DatabaseA_clone. What privileges does the ANALYST role have on tables and views in DatabaseA_clone? (Choose two.)

   • AUSAGE on the schema DatabaseA_clone
   • BUSAGE on the database DatabaseA_clone.Schema1
   • CSELECT on all tables, and only non-secure views in DatabaseA_clone.Schema1
   • DSELECT on all tables, and only secure views in DatabaseA_clone.Schema1
   • ESELECT on all tables and views in DatabaseA_clone.Schema1

   Show answer

   Answer: AE

   Next question

2. Question 2 · 5 in bank

   Which statement allows a Snowflake Administrator to retrieve the network policy applied to their Snowflake account?

   • ASHOW NETWORK POLICIES IN ACCOUNT;
   • BSHOW PARAMETERS LIKE ‘NETWORK POLICY’ IN ACCOUNT;
   • CSHOW NETWORK POLICIES;
   • DDESC NETWORK POLICY <policy_name>;

   Show answer

   Answer: B

   Next question

3. Question 3 · 5 in bank

   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 replicated to ACCOUNT2. Are there any necessary configuration steps in ACCOUNT1 before the database replication can be configured and initiated in ACCOUNT2?

   • A//IMG//
   • B//IMG//
   • CNo configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.
   • DIt is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.

   Show answer

   Answer: B

   Next question

4. Question 4 · 5 in bank

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

   • A//IMG//
   • B//IMG//
   • C//IMG//
   • D//IMG//

   Show answer

   Answer: D

   Next question

5. Question 5 · 5 in bank

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

   • AAny role with GRANT USAGE on SECURITY INTEGRATION
   • BACCOUNTADMIN and SYSADMIN
   • CACCOUNTADMIN and SECURITYADMIN
   • DACCOUNTADMIN only

   Show answer

   Answer: C

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

ADA-C02 practice, question 1. 5 questions available.