SnowPro Advanced Administrator ADA-C01 Exam Free Dumps

dumps2024-01-19T13:57:32+08:00

SnowPro Advanced Administrator ADA-C01 exam contains 65 multiple-select and multiple-choice questions, and you have 115 minutes to answer all the questions. The required passing score for the Snowflake ADA-C01 exam is 750. The available language is English. We provide the latest SnowPro Advanced Administrator ADA-C01 exam dumps, which can help you study all the related topics. Free SnowPro Advanced Administrator ADA-C01 exam dumps are available below.

Page 1 of 3

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

The SYSADMIN role

The role above the dropped role in the RBAC hierarchy

The role executing the command

The SECURITYADMIN 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?

A secure view with a column for file URLs.

A secure view with a column for pre-signed URLs.

A secure view with a column for METADATA$FILENAM

A secure view with a column for the stage name and a column for the file path.

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?

The STORE_ID should be numeric.

The table is not big enough to take advantage of the clustering key.

Sales across stores are not uniformly distributed.

The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.

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?

Sequences, views, and secure views

Sequences, views, secure views, and materialized views

Sequences, storage integrations, views, secure views, and materialized views

There are no object references that need to be re-pointed

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

Reset a Snowflake user's password

Manage system grants

Create new users

Create new roles

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

Use the following SQL command: create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;

Use the following SQL command: create transient table TRANSIENT SALES DATA as select * from SALES_DATA copy grants;

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;

Transient tables will persist until explicitly dropped and contribute to overall storage costs.

Transient tables will be purged at the end of the user session and do not have any Fail-safe period.

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

Dropping a column from a table

Deleting data from a table

Unpublishing the data listing

Renaming a table

Adding region availability to the listing

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

Database: Usage Schema: Usage Table: Select, Create Stream

Database: Usage Schema: Usage Table: Select

Database: Usage, Create Stream Schema: Usage Table: Select

Database: Usage Schema: Usage, Create Stream Table: Select

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?

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.

Create a separate table for all the non-Pll columns and grant the role DEVELOPER access to the new table.

Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data.

Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that contain sensitive 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?

Wrap the query in a User-Defined Function (UDF) to match syntax execution.

Assign everyone on the sales team to the same virtual warehouse.

Assign everyone on the sales team to the same security role.

Leverage the CURRENT_DATE function for date calculations.

Page 2 of 3

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

Create one or more accounts in the organization.

View a list of all regions enabled for the organization.

Create secure views on application tables within the organization.

View usage information for all accounts in the organization.

Perform zero-copy cloning on account data.

Create a reader account to share data with another organization.

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

Any role with GRANT USAGE on SECURITY INTEGRATION

ACCOUNTADMIN and SYSADMIN

ACCOUNTADMIN and SECURITYADMIN

ACCOUNTADMIN only

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?

Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XY

SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XY

PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XY

Only the PROD_WORKING_OWNER role can alter or drop table XY

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?

CURRENT_ROLE

CURRENT ACCOUNT

CURRENT_USER

CURRENT_CLIENT

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

When accessing a Snowflake table from a relational database

When accessing a Snowflake table from an external database within the same region

When continuously writing data from a Snowflake table to external storage

When accessing a Snowflake table that references data files located in cloud storage

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?

Assign additional clusters to the virtual warehouse.

Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session.

Prevent the virtual warehouse from suspending between the running of the first and second queries.

Use the RESULT_SCAN function to post-process the output of the first query.

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

The account_level policy will override the user_level policy.

The user_level policy will override the account_level policy.

The user_level network policies will not be supported.

A network policy error will be generated with no definitions provided.

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

SELECT * FROM my table WITH TIME_TRAVEL (OFFSET => -60*30);

SELECT * FROM my_table AT (TIMESTAMP => '2021-01-01 07:00:00' :: timestamp);

SELECT * FROM TIME_TRAVEL ('MY_TABLE', 2021-01-01 07:00:00);

SELECT * FROM my table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';

SELECT * FROM my_table AT (OFFSET => -60*30);

SELECT * FROM my_table BEFORE (STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

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

A masking policy that is currently set on a table can be dropped.

A single masking policy can be applied to columns in different tables.

A masking policy can be applied to the VALUE column of an external table.

The role that creates the masking policy will always see unmasked data in query results.

A single masking policy can be applied to columns with different data types.

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

Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas.

The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_ DAY

The DATA_RETENTION_TIME_IN_DAYS should be kept at the account level and never used for lower level containers (databases and schemas).

Only TRANSIENT tables should be used to ensure referential integrity between the fact and dimension tables.

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.

Page 3 of 3

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

SnowPro Advanced Administrator ADA-C01 Exam Free Dumps

SnowPro Advanced Administrator ADA-C01 Exam Free Dumps

Share this post

Leave a Reply Cancel reply

Related Posts