Weekend Special Sale 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sale75best

Free Snowflake ADA-C02 Practice Exam with Questions & Answers

Questions 1

When adding secure views to a share in Snowflake, which function is required to authorize users from another account to access rows in a base table?

Options:
A.

CURRENT_ROLE

B.

CURRENT_ACCOUNT

C.

CURRENT_USER

D.

CURRENT_CLIENT

Snowflake ADA-C02 Premium Access
Questions 2

Which actions are considered breaking changes to data shared with consumers through the Snowflake Marketplace?

Choose two

Options:
A.

Dropping a column from a table

B.

Deleting data from a table

C.

Unpublishing the data listing

D.

Renaming a table

E.

Adding region availability to the listing

Questions 3

C. ompany A uses Snowflake to manage audio files containing call recordings. Company A hired Company B, which also uses Snowflake, to transcribe the audio files for additional analysis.

C. ompany A’s Administrator created a share. What object should be added to the share to give Company B access to the files?

Options:
A.

A secure view with a column for file URLs.

B.

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

C.

A secure view with a column for METADATA$FILENAME.

D.

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

Questions 4

An Administrator must create a sample from the LINEITEM table. The sample must not be repeatable, and the sampling function must select data in blocks of rows.

Which SELECT command generates a sample of 20% of the table?

Options:
A.

select * from LINEITEM sample bernoulli (20);

B.

select * from LINEITEM sample system (20);

C.

select * from LINEITEM tablesample block (20 rows);

D.

select * from LINEITEM tablesample system (20) seed (1);

Questions 5

MY_TABLE is a table that has not been updated or changed for several days. On 01 January 2021 at 07:01, a user ran a query that updated this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.

Which queries allow the user to view the historical data that was in the table before this query ran?

Choose three

Options:
A.

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

B.

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

C.

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

D.

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

E.

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

F.

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

Questions 6

What are the minimum grants needed on the database, schema, and table to correctly create and manage a stream?

Options:
A.

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

B.

Database: Usage -Schema: Usage -Table: Select

C.

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

D.

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

Questions 7

Which of the following are characteristics of Dynamic Data Masking?

Choose two

Options:
A.

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

B.

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

C.

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

D.

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

E.

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

Questions 8

DatabaseA contains one schema, Schema1, which has many tables and views. The ANALYST role has privileges to select from every object in DatabaseA.Schema1. The SYSADMIN role clones DatabaseA as DatabaseA_clone.

Which privileges does the ANALYST role have on tables and views in DatabaseA_clone?

Choose two

Options:
A.

USAGE on the schema DatabaseA_clone

B.

USAGE on the database DatabaseA_clone.Schema1

C.

SELECT on all tables, and only non-secure views in DatabaseA_clone.Schema1

D.

SELECT on all tables, and only secure views in DatabaseA_clone.Schema1

E.

SELECT on all tables and views in DatabaseA_clone.Schema1

Questions 9

A company has configured Snowflake replication between two Snowflake accounts, both running Snowflake Enterprise Edition. Replication applies to database APP_DB, which contains only one schema, APP_SCHEMA. The company’s Time Travel retention policy is currently 30 days in both accounts. An Administrator must extend the Time Travel retention policy to 60 days on the secondary database only.

How can this requirement be fulfilled?

Options:
A.

Set the data retention policy on the secondary database to 60 days.

B.

Set the data retention policy on the schemas in the secondary database to 60 days.

C.

Set the data retention policy on the primary database to 30 days and the schemas to 60 days.

D.

Set the data retention policy on the primary database to 60 days.

Questions 10

A Snowflake Administrator must configure Time Travel for a presentation area containing fact and dimension tables that receives substantial meaningless and erroneous IoT data. Time Travel is part of the company’s data-quality process, where the ingestion pipeline must revert to a known, high-quality data state if anomalies are found in the most recent load. Because of latencies in the data-acquisition process, data from the prior 30 days might need to be retrieved.

Options:
A.

ccording to best practices, how should these requirements be satisfied?

Choose two

B.

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

C.

The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_DAYS.

D.

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

E.

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

F.

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.