Online Access Free ADA-C01 Exam Questions

A Snowflake Administrator needs to retrieve the list of the schemas deleted within the last two days from the DB1 database.
Which of the following will achieve this?

• A.SELECT * FROM DB1.INFORMATION_SCHEMA.SCHEMATA;
• B.SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.DATABASES;
• C.SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.SCHEMATA;
• D.SHOW SCHEMAS IN DATABASE DB1;

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. Location : AWS_EAST
The secondary database object is : PROD_AWS_WEST. Location : AWS_WEST
What command and account location is needed to refresh the data?

• A.Location : AWS EAST
  Command: ALTER DATABASE PROD_AWS_WEST REFRESH;
• B.Location : AWS_WEST
  Command : REFRESH DATABASE PROD_AWS WEST REFRESH;
• C.Location : AWS_EAST
  Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;
• D.Location : AWS_WEST
  Command : ALTER DATABASE PROD AWS WEST REFRESH;

What SCIM integration types are supported in Snowflake? (Select THREE).

• A.Google Cloud Platform (GCP)
• B.Azure Active Directory (Azure AD)
• C.Okta
• D.Custom
• E.Duo Security Provisioning Connector
• F.Amazon Web Services (AWS)

A user accidentally truncated the data from a frequently-modified table. The Administrator has reviewed the query history and found the truncate statement which was run on 2021-12-12 15:00 with query ID 8e5d0ca9-005e-44e6-b858-a8f5b37c5726. Which of the following statements would allow the Administrator to create a copy of the table as it was exactly before the truncated statement was executed, so it can be checked for integrity before being inserted into the main table?

• A.CREATE TABLE RESTORE_TABLE CLONE CURRENT_TABLE before (statement => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');
• B.CREATE TABLE RESTORE_TABLE CLONE CURRENT_TABLE BEFORE (timestamp => '2021-12-12 00:00');
• C.SELECT * FROM CURRENT_TABLE before (statement => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');
• D.INSERT INTO CURRENT_TABLE SELECT * FROM CURRENT_TABLE before (statement => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

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

• A.An access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.
• B.Schema privileges will take precedence over database privileges.
• C.Database privileges will take precedence over schema privileges.
• D.An access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.