Snowflake ADA-C01 Practice Test - Questions Answers, Page 4

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

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

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?

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?

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

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

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?

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?

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