Snowflake SnowPro Advanced Administrator Exam Updated: ADA-C01 Dumps (V9.03) for Your Quick Exam Preparation

1. When a role is dropped, which role inherits ownership of objects owned by the dropped role?

2. Company A uses Snowflake to manage audio files of call recordings. Company A hired Company B, who also uses Snowflake, to transcribe the audio files for further analysis.

Company A's Administrator created a share.

What object should be added to the share to allow Company B access to the files?

3. A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar (50)). The vast majority of analyses on this table are grouped by STORE_ID to look at store performance.

There are 1000 stores operated by the retailer but most sales come from only 20 stores. The Administrator notes that most queries are currently experiencing poor pruning, with large amounts of bytes processed by even simple queries.

Why is this occurring?

4. A team is provisioning new lower environments from the production database using cloning. All production objects and references reside in the database, and do not have external references.

What set of object references needs to be re-pointed before granting access for usage?

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

6. An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not want to change the main table data. The Administrator decides to make a transient copy of this table and wants the transient table to have all the same permissions as the original table.

How can the Administrator create the transient table so it inherits the same permissions as the original table, and what considerations need to be made concerning the requirements? (Select TWO).

7. Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Select TWO).

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

9. An Administrator has been asked to support the company's application team need to build a loyalty program for its customers. The customer table contains Personal Identifiable Information (PII), and the application team's role is DEVELOPER.

CREATE TABLE customer_data (

customer_first_name string,

customer_last_name string,

customer_address string,

customer_email string,

... some other columns,

);

The application team would like to access the customer data, but the email field must be obfuscated.

How can the Administrator protect the sensitive information, while maintaining the usability of the data?

10. An organization's sales team leverages this Snowflake query a few times a day:

SELECT CUSTOMER ID, CUSTOMER_NAME, ADDRESS, PHONE NO FROM CUSTOMERS WHERE LAST UPDATED BETWEEN TO_DATE (CURRENT_TIMESTAMP) AND (TO_DATE (CURRENT_TIMESTAMP) -7);

What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?

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

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

13. 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?

14. 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?

15. In which scenario will use of an external table simplify a data pipeline?

16. 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?

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

18. 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).

19. What are characteristics of Dynamic Data Masking? (Select TWO).

20. 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).

21. INSERT INTO VWH META SELECT CURRENT TIMESTAMP (), * FROM TABLE (RESULT_SCAN (SELECT LAST QUERY ID(-1)));

22. What are the requirements when creating a new account within an organization in Snowflake? (Select TWO).

23. A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTs rather than bulk loading of large extracts. That single warehouse has been configured as a single cluster, 2XL because there are many parallel INSERTs that are scheduled during nightly loads.

How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?

24. What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Select TWO).

25. An Administrator wants to delegate the administration of a company's data exchange to users who do not have access to the ACCOUNTADMIN role.

How can this requirement be met?