Snowflake ADA-C01 valid exam dumps : SnowPro Advanced Administrator

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. SHOW SCHEMAS IN DATABASE DB1;
• B. SELECT * FROM DB1.INFORMATION_SCHEMA.SCHEMATA;
• C. SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.DATABASES;
• D. SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.SCHEMATA;

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_EAST
  Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;
• C. Location : AWS_WEST
  Command : ALTER DATABASE PROD AWS WEST REFRESH;
• D. Location : AWS_WEST
  Command : REFRESH DATABASE PROD_AWS WEST REFRESH;

An Administrator needs to implement an access control mechanism across an organization. The organization users access sensitive customer data that comes from different regions and needs to be accessible for Analysts who work in these regions. Some Analysts need very specific access control depending on their functional roles in the organization. Following Snowflake recommended practice, how should these requirements be met? (Select TWO).

• A. Use zero-copy cloning to replicate the database schema and provide access as needed.
• B. Implement views on top of base tables that exclude or mask sensitive data.
• C. Implement row access policies and Dynamic Data Masking policies.
• D. Include masking rules as part of data ingestion and transformation pipelines.
• E. Use a third-party tool to share the data.

A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database.
For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?

• A. To keep the data cache warm to support good performance of similar queries
• B. To save costs by running the warehouse as little as possible
• C. To save costs on warehouse shutdowns and startups for different queries
• D. To keep the query result cache warm for good performance on repeated queries

Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

• A. Create new users
• B. Create new roles
• C. Manage system grants
• D. Reset a Snowflake user's password