SnowPro Advanced Administrator ADA-C02 - ADA-C02 Exam Practice Test

Question 1

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. A secure view with a column for pre-signed URLs.

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

C. A secure view with a column for file URLs.

D. A secure view with a column for METADATA$FILENAME.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?

A. Yes, because materialized views are always faster.

B. No, because the optimizer might decide against it.

C. No, because joins are not supported by materialized views.

D. No, because the materialized view may not be up-to-date.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

What are characteristics of Dynamic Data Masking? (Choose two.)

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

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. A masking policy that is currently set on a table can be dropped.

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

Correct Answer: B,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

What is a characteristic of Snowflake's transaction locking and concurrency modeling?

A. Queries executed within a given transaction see that transaction's uncommitted changes.

B. Transaction locking in Snowflake is enforced exclusively at the row and table levels.

C. A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.

D. If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 5

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

A. ACCOUNTADMIN only

B. Any role with GRANT USAGE on SECURITY INTEGRATION

C. ACCOUNTADMIN and SECURITYADMIN

D. ACCOUNTADMIN and SYSADMIN

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 6

What are benefits of creating and maintaining resource monitors in Snowflake? (Choose three.)

A. Resource monitors add no additional load to virtual warehouse compute.

B. Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.

C. Multiple resource monitors can be applied to a single virtual warehouse.

D. Multiple triggers can be configured across various virtual warehouse thresholds.

E. Resource monitors can be applied to more than one virtual warehouse.

F. The cost of running a resource monitor is only 10% of a credit, per day of operation.

Correct Answer: C,D,E

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 7

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?

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

B. Sequences, views, and secure views

C. Sequences, views, secure views, and materialized views

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

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Snowflake SnowPro Advanced Administrator ADA-C02 - ADA-C02 Exam Practice Test

Latest Update

Useful Links

Contact Us