support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  1. Home
  2. Exams
  3. Snowflake
  4. SnowPro Advanced Administrator

Snowflake SnowPro Advanced Administrator Exam Prep
SnowPro Advanced Administrator ADA-C01 (Page 7 )

Updated On: 28-Aug-2026
Page 3 of 17
PDF with 65 Questions

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

  1. Use the following SQL command:
    create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;
  2. Use the following SQL command:
    create transient table TRANSIENT SALES DATA as select * from SALES_DATA copy grants;
  3. Use the following SQL commands:
    create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants; insert into TRANSIENT_SALES_DATA select * from SALES_DATA;
  4. Transient tables will persist until explicitly dropped and contribute to overall storage costs.
  5. Transient tables will be purged at the end of the user session and do not have any Fail-safe period.

Answer(s): B,D

Explanation:

According to the Snowflake documentation1, the COPY GRANTS option can be used to copy all privileges, except OWNERSHIP, from the existing table to the new transient table. This option also preserves any future grants defined for the object type in the schema. Option A is incorrect because it does not copy any grants from the original table. Option C is incorrect because it does not copy the data from the original table, only the structure and grants. Option E is incorrect because transient tables are not session-based and do not have a Fail-safe period, but they do have a Time Travel retention period2.
1: CREATE TABLE | Snowflake Documentation 2: Working with Temporary and Transient Tables | Snowflake Documentation



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

  1. Dropping a column from a table
  2. Deleting data from a table
  3. Unpublishing the data listing
  4. Renaming a table
  5. Adding region availability to the listing

Answer(s): A,D

Explanation:

According to the Snowflake documentation1, breaking changes are changes that affect the schema or structure of the shared data, such as dropping or renaming a column or a table. These changes may cause errors or unexpected results for the consumers who query the shared data. Deleting data from a table, unpublishing the data listing, or adding region availability to the listing are not breaking changes, as they do not alter the schema or structure of the shared data.
1: Managing Data Listings in Snowflake Data Marketplace | Snowflake Documentation



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

  1. Database: Usage
    Schema: Usage
    Table: Select, Create Stream
  2. Database: Usage
    Schema: Usage
    Table: Select
  3. Database: Usage, Create Stream
    Schema: Usage
    Table: Select
  4. Database: Usage
    Schema: Usage, Create Stream
    Table: Select

Answer(s): A



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?

  1. Create a view on the customer_data table to eliminate the email column by omitting it from the SELECT clause. Grant the role DEVELOPER access to the view.
  2. Create a separate table for all the non-Pll columns and grant the role DEVELOPER access to the new table.
  3. Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data.
  4. Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that contain sensitive data.

Answer(s): D



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?

  1. Wrap the query in a User-Defined Function (UDF) to match syntax execution.
  2. Assign everyone on the sales team to the same virtual warehouse.
  3. Assign everyone on the sales team to the same security role.
  4. Leverage the CURRENT_DATE function for date calculations.

Answer(s): D

Explanation:

According to the web search results from my predefined tool search_web, one of the factors that affects the reuse of persisted query results is the exact match of the query syntax1. If the query contains functions that return different values for successive runs, such as CURRENT_TIMESTAMP, then the query will not match the previous query and will not benefit from the cache. To avoid this, the query should use functions that return consistent values for the same day, such as CURRENT_DATE, which returns the current date without the time component2. Option A is incorrect because wrapping the query in a UDF does not guarantee the syntax match, as the UDF may also contain dynamic functions. Option B is incorrect because the virtual warehouse does not affect the persisted query results, which are stored at the account level1. Option C is incorrect because the security role does not affect the persisted query results, as long as the role has the necessary privileges to access the tables and views used in the query1.
1: Using Persisted Query Results | Snowflake Documentation 2: Date and Time Functions | Snowflake

Documentation



  PDF
Viewing page 7 of 17
Viewing questions 31 - 35 out of 65 questions


Post your Comments and Discuss Snowflake SnowPro Advanced Administrator exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!