Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake ADA-C01 Exam

Exam Name: SnowPro Advanced: Administrator Certification
Exam Code: ADA-C01
Related Certification(s):
  • Snowflake SnowPro Certification Certifications
  • Snowflake SnowPro Advanced Certification Certifications
Certification Provider: Snowflake
Actual Exam Duration: 115 Minutes
Number of ADA-C01 practice questions in our database: 72 (updated: Jun. 04, 2024)
Expected ADA-C01 Exam Topics, as suggested by Snowflake :
  • Topic 1: Given a scenario, configure access controls/ Set up and manage security administration and authorization
  • Topic 2: Given a scenario, manage databases, tables, and views/ Manage organizations and access control
  • Topic 3: Interpret and make recommendations for data clustering/ Manage DML locking and concurrency in Snowflake
  • Topic 4: Set up and manage network and private connectivity/ Given a scenario, manage Snowflake Time Travel and Fail-safe
  • Topic 5: Snowflake Security, Role-Based Access Control (RBAC), and User Administration/ Disaster Recovery, Backup, and Data Replication
  • Topic 6: Given a scenario, create and manage access control/ Given a scenario, implement resource monitors
  • Topic 7: Manage and implement data sharing/ Given a set of business requirements, establish access control architecture
  • Topic 8: Implement and manage data governance in Snowflake/ Data Sharing, Data Exchange, and Snowflake Marketplace
Disscuss Snowflake ADA-C01 Topics, Questions or Ask Anything Related

Currently there are no comments in this discussion, be the first to comment!

Free Snowflake ADA-C01 Exam Actual Questions

Note: Premium Questions for ADA-C01 were last updated On Jun. 04, 2024 (see below)

Question #1

What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?

Reveal Solution Hide Solution
Correct Answer: D

The SIMULATED_DATA_SHARING_CONSUMER session parameter allows a data provider to test the integrity of secure views based on the account that is accessing that view2. By setting this parameter to the name of the consumer account, the data provider can query the secure view and see the results that a user in the consumer account will see2. This helps to ensure that sensitive data in a shared database is not exposed to unauthorized users1. The other options are not valid session parameters in Snowflake3


Question #2

Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?

Reveal Solution Hide Solution
Correct Answer: A

A masking policy is a SQL expression that transforms the data in a column based on the role that queries the column1. The is_role_in_session function returns true if the specified role is in the current session2. Therefore, the masking policy in option A will mask the column data with asterisks whenever it is queried through a view owned by the MASKED_VIEW_ROLE3. The other options use different functions that do not check the ownership of the view, but rather the current role, the invoker role, or the available roles in the session45. These functions may not return the desired result if the role that owns the view is different from the role that queries the view.


Question #3

What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?

Reveal Solution Hide Solution
Correct Answer: D

The SIMULATED_DATA_SHARING_CONSUMER session parameter allows a data provider to test the integrity of secure views based on the account that is accessing that view2. By setting this parameter to the name of the consumer account, the data provider can query the secure view and see the results that a user in the consumer account will see2. This helps to ensure that sensitive data in a shared database is not exposed to unauthorized users1. The other options are not valid session parameters in Snowflake3


Question #4

What access control policy will be put into place when future grants are assigned to both database and schema objects?

Reveal Solution Hide Solution
Correct Answer: B

When future grants are defined on the same object type for a database and a schema in the same database, the schema-level grants take precedence over the database level grants, and the database level grants are ignored4. This behavior applies to privileges on future objects granted to one role or different roles4. Future grants allow defining an initial set of privileges to grant on new (i.e. future) objects of a certain type in a database or a schema3. As soon as the new objects are created inside the database or schema, the predefined set of privileges are assigned to the object automatically without any manual intervention3.


Question #5

An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it into

different production tables.

How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?

Reveal Solution Hide Solution
Correct Answer: B

According to the Snowflake documentation1, a transient table is a type of table that does not support Time Travel or Fail-safe, which means that it does not incur any storage costs for maintaining historical versions of the data or backups for disaster recovery. A transient table can be dropped at any time, and the data is not recoverable. A transient table can also have a retention time of 0 days, which means that the data is deleted immediately after the table is dropped or truncated. Therefore, creating the staging table as a transient table with a retention time of 0 days can minimize the storage costs and maximize the performance, as the data is only loaded and transformed once, and then deleted after the production tables are populated. Option A is incorrect because creating the staging table as an external table, which references data files stored in a cloud storage location, can incur additional costs and complexity for data transfer and synchronization, and may not provide the best performance for data loading and transformation. Option C is incorrect because creating the staging table as a temporary table, which is automatically dropped when the session ends or the user logs out, can cause data loss or inconsistency if the session is interrupted or terminated before the production tables are populated. Option D is incorrect because creating the staging table as a permanent table, which supports Time Travel and Fail-safe, can incur additional storage costs for maintaining historical versions of the data and backups for disaster recovery, and may not provide the best performance for data loading and transformation.



Unlock Premium ADA-C01 Exam Questions with Advanced Practice Test Features:
  • Select Question Types you want
  • Set your Desired Pass Percentage
  • Allocate Time (Hours : Minutes)
  • Create Multiple Practice tests with Limited Questions
  • Customer Support
Get Full Access Now

Save Cancel