Snowflake ADA-C01 SnowPro Advanced Administrator Online Training
Snowflake ADA-C01 Online Training
The questions for ADA-C01 were last updated at Jan 02,2025.
- Exam Code: ADA-C01
- Exam Name: SnowPro Advanced Administrator
- Certification Provider: Snowflake
- Latest update: Jan 02,2025
Which tasks can be performed by the ORGADMIN role? (Select THREE).
- A . Create one or more accounts in the organization.
- B . View a list of all regions enabled for the organization.
- C . Create secure views on application tables within the organization.
- D . View usage information for all accounts in the organization.
- E . Perform zero-copy cloning on account data.
- F . Create a reader account to share data with another organization.
What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?
- A . Any role with GRANT USAGE on SECURITY INTEGRATION
- B . ACCOUNTADMIN and SYSADMIN
- C . ACCOUNTADMIN and SECURITYADMIN
- D . ACCOUNTADMIN only
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 to role SYSADMIN;
Use role ACCOUNTADMIN;
Create table PROD.WORKING.XYZ (value number);
Which role(s) can alter or drop table XYZ?
- A . Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.
- B . SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
- C . PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
- D . Only the PROD_WORKING_OWNER role can alter or drop table XYZ.
When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?
- A . CURRENT_ROLE
- B . CURRENT ACCOUNT
- C . CURRENT_USER
- D . CURRENT_CLIENT
In which scenario will use of an external table simplify a data pipeline?
- A . When accessing a Snowflake table from a relational database
- B . When accessing a Snowflake table from an external database within the same region
- C . When continuously writing data from a Snowflake table to external storage
- D . When accessing a Snowflake table that references data files located in cloud storage
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 another query that uses the same data set.
Which action would provide optimal performance for the second SQL query?
- A . Assign additional clusters to the virtual warehouse.
- B . Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session.
- C . Prevent the virtual warehouse from suspending between the running of the first and second queries.
- D . Use the RESULT_SCAN function to post-process the output of the first query.
For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?
- A . The account_level policy will override the user_level policy.
- B . The user_level policy will override the account_level policy.
- C . The user_level network policies will not be supported.
- D . A network policy error will be generated with no definitions provided.
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).
- A . SELECT * FROM my table WITH TIME_TRAVEL (OFFSET => -60*30);
- B . SELECT * FROM my_table AT (TIMESTAMP => ‘2021-01-01 07:00:00’ :: timestamp);
- C . SELECT * FROM TIME_TRAVEL (‘MY_TABLE’, 2021-01-01 07:00:00);
- D . SELECT * FROM my table PRIOR TO STATEMENT ‘8e5d0ca9-005e-44e6-b858-a8f5b37c5726’;
- E . SELECT * FROM my_table AT (OFFSET => -60*30);
- F . SELECT * FROM my_table BEFORE (STATEMENT => ‘8e5d0ca9-005e-44e6-b858-a8f5b37c5726’);
What are characteristics of Dynamic Data Masking? (Select TWO).
- A . A masking policy that is currently set on a table can be dropped.
- B . A single masking policy can be applied to columns in different tables.
- C . A masking policy can be applied to the VALUE column of an external table.
- D . The role that creates the masking policy will always see unmasked data in query results.
- E . A single masking policy can be applied to columns with different data types.
A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous loT data. Time Travel is being used as a component of the company’s data quality process in which the ingestion pipeline should revert to a known quality data state if any anomalies are detected in the latest load. Data from the past 30 days may have to be retrieved because of latencies in the data acquisition process.
According to best practices, how should these requirements be met? (Select TWO).
- A . Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas.
- B . The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_ DAYS.
- C . The DATA_RETENTION_TIME_IN_DAYS should be kept at the account level and never used for lower level containers (databases and schemas).
- D . Only TRANSIENT tables should be used to ensure referential integrity between the fact and dimension tables.
- E . The fact and dimension tables should be cloned together using the same Time Travel options to reduce potential referential integrity issues with the restored data.
Latest ADA-C01 Dumps Valid Version with 72 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
