Free SnowPro Advanced: Administrator Certification ADA-C01 Exam Practice Test

MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is'8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.Which queries will allow the user to view the historical data that was in the table before this query was executed? (Select THREE).SELECT * FROM my table WITH TIME_TRAVEL (OFFSET => -60*30);SELECT * FROM my_table AT (TIMESTAMP => '2021-01-01 07:00:00' :: timestamp);SELECT * FROM TIME_TRAVEL ('MY_TABLE', 2021-01-01 07:00:00);SELECT * FROM my table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';SELECT * FROM my_table AT (OFFSET => -60*30);SELECT * FROM my_table BEFORE (STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

• SELECT * FROM my table WITH TIME_TRAVEL (OFFSET => -60*30); This query uses the OFFSET parameter to specify a point in time that is 30 minutes before the current time, which is 07:30. This is after the query execution time of 07:01, so it will not show the historical data before the query was executed.
• SELECT * FROM TIME_TRAVEL (‘MY_TABLE’, 2021-01-01 07:00:00); This query is not valid
• syntax for Time Travel. The TIME_TRAVEL function does not exist in Snowflake. The correct syntax is to use the AT or BEFORE clause after the table name in the FROM clause.
• SELECT * FROM my_table AT (OFFSET => -60*30); This query uses the AT keyword and the OFFSET parameter to specify a point in time that is 30 minutes before the current time, which is 07:30. This is equal to the query execution time of 07:01, so it will not show the historical data before the query was executed. The AT keyword specifies that the request is inclusive of any changes made by a statement or transaction with timestamp equal to the specified parameter. To exclude the changes made by the query, the BEFORE keyword should be used instead.

A Snowflake Administrator is investigating why a query is not re-using the persisted result cache.The Administrator found the two relevant queries from the SNOWFLAKE. ACCOUNT_USAGE. QUERY_HISTORY view:Why is the second query re-scanning micro-partitions instead of using the first query's persisted result cache?

• The second query includes a CURRENT_TIMESTAMP () function.
• The second query includes a CURRENT_DATE () function.
• The queries are executed with two different virtual warehouses.
• The queries are executed with two different roles.

What are benefits of creating and maintaining resource monitors in Snowflake? (Select THREE).

• The cost of running a resource monitor is only 10% of a credit, per day of operation.
• Multiple resource monitors can be applied to a single virtual warehouse.
• Resource monitors add no additional load to virtual warehouse compute.
• Multiple triggers can be configured across various virtual warehouse thresholds.
• Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.
• Resource monitors can be applied to more than one virtual warehouse.

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

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

A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount of data from micro-partitions. The same user wants to run anotherquery that uses the same data set.Which action would provide optimal performance for the second SQL query?

• Assign additional clusters to the virtual warehouse.
• Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session.
• Prevent the virtual warehouse from suspending between the running of the first and second queries.
• Use the RESULT_SCAN function to post-process the output of the first query.

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

• Any role with GRANT USAGE on SECURITY INTEGRATION
• ACCOUNTADMIN and SYSADMIN
• ACCOUNTADMIN and SECURITYADMIN
• ACCOUNTADMIN only

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/24', '2.2.2.0/24' , '3.3. 3. 0/24' ) BLOCKED IP LIST = ( '1.1.1.1')COMMENT = 'Account level policy';ALTER ACCOUNT SET NETWORK_POLICY=FOO_POLICY;CREATE OR REPLACE NETWORK POLICY bar_policy ALLOWED_IP_LIST = ('3.3.3.0/24')BLOCKED IP LIST = ('3.3.3.10')COMMENT = 'user level policy';ALTER USER userl SET NETWORK_POLICY=BAR_POLICY;Afterwards, user1 attempts to log in to Snowflake from IP address 3.3.3.10. Will the login be successful?

• Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.
• No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.
• Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.
• No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.

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

• Monetized listing
• Standard listing
• Regional listing
• Personalized listing

Which tasks can be performed by the ORGADMIN role? (Select THREE).

• Create one or more accounts in the organization.
• View a list of all regions enabled for the organization.
• Create secure views on application tables within the organization.
• View usage information for all accounts in the organization.
• Perform zero-copy cloning on account data.
• Create a reader account to share data with another organization.

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

• The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.
• Users must be granted REPLICATIONADMIN privileges in order to enable replication.
• To start replication run the ALTER DATABASE ... REFRESH command on the account where thesecondary database resides.
• Replication can only occur within the same cloud provider.
• Databases created from shares can be replicated.
• 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.