Snowflake SnowPro Advanced Administrator - ADA-C01 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?

A. Database: Usage, Create Stream
Schema: Usage
Table: Select B. Database: Usage
Schema: Usage, Create Stream
Table: Select C. Database: Usage
Schema: Usage
Table: Select D. Database: Usage
Schema: Usage
Table: Select, Create Stream

Discussion 0

Correct Answer: D Vote an answer

Question 2

A Snowflake Administrator needs to persist all virtual warehouse configurations for auditing and backups. Given a table already exists with the following schema:
Table Name : VWH_META
Column 1 : SNAPSHOT_TIME TIMESTAMP_NTZ
Column 2 : CONFIG VARIANT
Which commands should be executed to persist the warehouse data at the time of execution in JSON format in the table VWH META?

A. 1. SHOW WAREHOUSES;
2. INSERT INTO VWH META
SELECT CURRENT TIMESTAMP (), *
FROM TABLE (RESULT_SCAN (SELECT
LAST QUERY ID(-1))); B. 1. SHOW WAREHOUSES;
2. INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP (),
OBJECT CONSTRUCT (*)
FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ())); C. 1. SHOW WAREHOUSES;
2. INSERT INTO VWH META
SELECT CURRENT TIMESTAMP (),
FROM TABLE (RESULT_SCAN (LAST_QUERY_ID(1) ) ) ; D. 1. SHOW WAREHOUSES;
2. INSERT INTO VWH META
SELECT CURRENT TIMESTAMP (), *
FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ())) ;

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 3

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?

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

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 4

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_DB containing only one schema, APP_SCHEMA. The company's Time Travel retention policy is currently set for 30 days for both accounts. An Administrator has been asked to extend the Time Travel retention policy to 60 days on the secondary database only.
How can this requirement be met?

A. Set the data retention policy on the primary database to 30 days and the schemas to 60 days. B. Set the data retention policy on the primary database to 60 days. C. Set the data retention policy on the schemas in the secondary database to 60 days. D. Set the data retention policy on the secondary database to 60 days.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 5

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 perform the following tasks:
1. At 80% usage notify the account Administrators.
2. At 100% usage suspend the warehouse and notify the account Administrators.
3. At 120% stop all running executions, suspend the warehouse, and notify the account Administrators.
Which SQL command will meet these requirements?

A. create or replace resource monitor RM1 with credit_quota=3000
start_timestamp = '2022-01-01 00:00 CET'
triggers on 80 percent do notify
on 100 percent do suspend
on 120 percent do suspend_immediate;
alter warehouse WH1 set resource_monitor = RM1; B. create or replace resource monitor RM1 with credit_quota=3000
frequency = yearly
triggers on 80 percent do notify
on 100 percent do suspend
on 120 percent do suspend_immediate;
alter warehouse WH1 set resource_monitor = RM1; C. create or replace resource monitor RM1 with credit_quota=3000
frequency = yearly
start_timestamp = '2022-01-01 00:00 CET'
triggers on 80 percent do notify
on 100 percent do suspend
on 120 percent do suspend_immediate;
alter warehouse WH1 set resource monitor = RM1; D. create or replace resource monitor RM1 with credit_quota=3000
start_timestamp = '2022-01-01 00:00 CET'
triggers on 80 percent do notify
on 100 percent do notify and suspend
on 120 percent do notify and suspend_immediate;
alter warehouse WH1 set resource monitor = RM1;

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

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

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

Discussion 0

Correct Answer: B,D,F Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 7

A Snowflake account is configured with SCIM provisioning for user accounts and has bi-directional synchronization for user identities. An Administrator with access to SECURITYADMIN uses the Snowflake UI to create a user by issuing the following commands:
use role USERADMIN;
create or replace role DEVELOPER_ROLE;
create user PTORRES PASSWORD = 'hello world!' MUST_CHANGE_PASSWORD = FALSE default_role = DEVELOPER_ROLE; The new user named PTORRES successfully logs in, but sees a default role of PUBLIC in the web UI. When attempted, the following command fails:
use DEVELOPER_ROLE;
Why does this command fail?

A. The new role can only take effect after USERADMIN has logged out. B. The DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able to use the role. C. The new role will only take effect once the identity provider has synchronized by way of SCIM with the Snowflake account. D. USERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 8

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

A. SHOW USERS; B. SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER ( C. GRANT ROLE ORGADMIN TO USER <username>; D. SHOW REGIONS; E. SHOW ORGANIZATION ACCOUNTS;

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).