[2025] ADA-C01.pdf – Questions Answers PDF Sample Questions Reliable [Q33-Q55]

Rate this post

[2025] ADA-C01.pdf – Questions Answers PDF Sample Questions Reliable

Snowflake ADA-C01 Dumps PDF Are going to be The Best Score

Snowflake ADA-C01 Exam Syllabus Topics:

Topic	Details
Topic 1	Interpret and make recommendations for data clustering Manage DML locking and concurrency in Snowflake
Topic 2	Given a scenario, create and manage access control Given a scenario, implement resource monitors
Topic 3	Given a scenario, configure access controls Set up and manage security administration and authorization
Topic 4	Given a scenario, manage databases, tables, and views Manage organizations and access control
Topic 5	Implement and manage data governance in Snowflake Data Sharing, Data Exchange, and Snowflake Marketplace
Topic 6	Set up and manage network and private connectivity Given a scenario, manage Snowflake Time Travel and Fail-safe

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

Database privileges will take precedence over schema privileges.

Schema privileges will take precedence over database privileges.

An access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.

An access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.

QUESTION 34
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

QUESTION 35
A large international company with many operating regions requires data to be shared bi-directionally among all offices (head office to regional offices and regional offices among themselves). This company is a Snowflake account holder with European operations deployed in Microsoft Azure (single region) while North American regional offices are using AWS (single region) as their deployment cloud. This setup is required to comply with Personal Identifiable Information (PII) regulations in some of the European countries. The corporate head office is in Europe.
How can this data be shared bi-directionally, while MINIMIZING costs?

Use data replication everywhere to reduce costs associated with same-region sharing.

Use the PUT command to move files to an Amazon S3 bucket and Azure Blobs, and use an external file management application to move files within the corporate VPC.

Move all the Snowflake accounts to a single region, and implement data sharing.

Use bi-directional data sharing among offices in the same region and replication among offices across the continents.

QUESTION 36
Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?

alter user userl set MINS_TO_BYPASS_MFA=1440;

alter user userl set DISABLE_MFA=1440;

alter user userl set TEMPORARY_MFA_BYPASS=1440;

alter user userl set HOURS_TO_BYPASS_MFA=24;

QUESTION 37
What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Select TWO).

SYSADMIN

SECURITYADMIN

ACCOUNTADMIN

IMPORT SHARE and CREATE DATABASE

IMPORT PRIVILEGES and SHARED DATABASE

QUESTION 38
What is required for stages, without credentials, to limit data exfiltration after a storage integration and associated stages are created?

ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = true;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = false;

ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = true;

ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION FOR STAGE_OPERATION = true;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = true;

QUESTION 39
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’);

According to the AT | BEFORE documentation, the AT or BEFORE clause is used for Snowflake Time Travel, which allows you to query historical data from a table based on a specific point in the past. The clause can use one of the following parameters to pinpoint the exact historical data you wish to access:
* TIMESTAMP: Specifies an exact date and time to use for Time Travel.
* OFFSET: Specifies the difference in seconds from the current time to use for Time Travel.
* STATEMENT: Specifies the query ID of a statement to use as the reference point for Time Travel.
Therefore, the queries that will allow the user to view the historical data that was in the table before the query was executed are:
* B. SELECT * FROM my_table AT (TIMESTAMP => ‘2021-01-01 07:00:00’ :: timestamp); This query uses the TIMESTAMP parameter to specify a point in time that is before the query execution time of 07:01.
* D. SELECT * FROM my table PRIOR TO STATEMENT ‘8e5d0ca9-005e-44e6-b858-a8f5b37c5726’; This query uses the PRIOR TO STATEMENT keyword and the STATEMENT parameter to specify a point in time that is immediately preceding the query execution time of 07:01.
* F. SELECT * FROM my_table BEFORE (STATEMENT => ‘8e5d0ca9-005e-44e6-b858-a8f5b37c5726’); This query uses the BEFORE keyword and the STATEMENT parameter to specify a point in time that is immediately preceding the query execution time of 07:01.
The other queries are incorrect because:
* A. SELECT * FROM my table WITH TIME_TRAVEL (OFFSET => -60*30); This query uses the OFFSET parameter to specify a point in time that is 30 minutes before the current time, which is 07:30. This is after the query execution time of 07:01, so it will not show the historical data before the query was executed.
* C. SELECT * FROM TIME_TRAVEL (‘MY_TABLE’, 2021-01-01 07:00:00); This query is not valid syntax for Time Travel. The TIME_TRAVEL function does not exist in Snowflake. The correct syntax is to use the AT or BEFORE clause after the table name in the FROM clause.
* E. SELECT * FROM my_table AT (OFFSET => -60*30); This query uses the AT keyword and the OFFSET parameter to specify a point in time that is 30 minutes before the current time, which is 07:30. This is equal to the query execution time of 07:01, so it will not show the historical data before the query was executed. The AT keyword specifies that the request is inclusive of any changes made by a statement or transaction with timestamp equal to the specified parameter. To exclude the changes made by the query, the BEFORE keyword should be used instead.

QUESTION 40
A data provider wants to share data from multiple databases with a data consumer account.
How can this be accomplished?

The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege on each database referenced by the secure view.

The data provider needs to create a secure view and must grant the REFERENCE_USAGE privilege on the database where the secure view is created.

The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege to a database role to include objects from multiple databases in a share

The data provider needs to create a secure view and grant the USAGE privilege on each database referenced by the secure view.

QUESTION 41
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?

Create it as an external table, which will not incur Time Travel costs.

Create it as a transient table with a retention time of 0 days.

Create it as a temporary table with a retention time of 0 days.

Create it as a permanent table with a retention time of 0 days.

QUESTION 42
Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Select TWO).

SHOW REGIONS;

SHOW USERS;

SHOW ORGANIZATION ACCOUNTS;

GRANT ROLE ORGADMIN TO USER <username>;

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER (
‘ACCOUNT LOCATOR’,
‘ENABLE ACCOUNT DATABASE_REPLICATION’,
‘true’
);

QUESTION 43
Review the output of the SHOW statement below which displays the current grants on the table DB1. S1. T1:

This statement is executed:
USE ROLE ACCOUNTADMIN;
DROP ROLE A;
What will occur?

The table object DB1. S1. T1 will be dropped.

The OWNERSHIP privilege on table DB1. S1. T1 will be transferred to the ACCOUNTADMIN role.

The SELECT privilege on table DB1. S1. T1 to role B will be shown as GRANTED_BY the role ACCOUNTADMIN.

The SELECT privileges for roles B and C will remain.

QUESTION 44
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

QUESTION 45
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

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

MIMIC_CONSUMER_ACCOUNT

TEST_ACCOUNT_ID

PRODUCER_TEST_ACCT

SIMULATED_DATA_SHARING_CONSUMER

QUESTION 47
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.

QUESTION 48
Review the output of the SHOW statement below which displays the current grants on the table DB1. S1. T1:

This statement is executed:
USE ROLE ACCOUNTADMIN;
DROP ROLE A;
What will occur?

The table object DB1. S1. T1 will be dropped.

The OWNERSHIP privilege on table DB1. S1. T1 will be transferred to the ACCOUNTADMIN role.

The SELECT privilege on table DB1. S1. T1 to role B will be shown as GRANTED_BY the role ACCOUNTADMIN.

The SELECT privileges for roles B and C will remain.

QUESTION 49
An Administrator needs to implement an access control mechanism across an organization. The organization users access sensitive customer data that comes from different regions and needs to be accessible for Analysts who work in these regions. Some Analysts need very specific access control depending on their functional roles in the organization. Following Snowflake recommended practice, how should these requirements be met? (Select TWO).

Implement views on top of base tables that exclude or mask sensitive data.

Implement row access policies and Dynamic Data Masking policies.

Include masking rules as part of data ingestion and transformation pipelines.

Use a third-party tool to share the data.

Use zero-copy cloning to replicate the database schema and provide access as needed.

QUESTION 50
.
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$FILENAME.

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

QUESTION 51
An Administrator needs to create a sample of the table LINEITEM. The sample should not be repeatable and the sampling function should take the data by blocks of rows.
What select command will generate a sample of 20% of the table?

select * from LINEITEM sample bernoulli (20);

select * from LINEITEM sample system (20);

select * from LINEITEM tablesample block (20 rows);

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

QUESTION 52
A company has set up a new Snowflake account. An Identity Provider (IdP) has been configured for both Single Sign-On (SSO) and SCIM provisioning.
What maintenance is required to ensure that the SCIM provisioning process continues to operate without errors?

The IdP service account requires a new RSA key pair to be generated every six months.

The Administrator must issue a POST RENEW call to the REST API at least once every six months.

The OAuth Bearer Tokens have a lifespan of six months and must be regenerated prior to expiration.

The IdP Administrator must issue a REFRESH transaction at least once every six months to synchronize all users and roles.

QUESTION 53
What Snowflake capabilities are commonly used in rollback scenarios? (Select TWO).

SELECT SYSTEM$CANCEL_QUERY(‘problematic_query_id’);

CREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT => ‘problematic_query_id’);

CREATE TABLE prd_table_bkp AS SELECT * FROM TABLE(RESULT_SCAN(‘problematic_query_id’));

ALTER TABLE prd_table SWAP WITH prd_table_bkp;

Contact Snowflake Support to retrieve Fail-safe data.

QUESTION 54
A company has implemented Snowflake replication between two Snowflake accounts, both of which are running on a Snowflake Enterprise edition. The replication is for the database APP_DB containing only one schema, APP_SCHEMA.
The company’s Time Travel retention policy is currently set for 30 days for both accounts. An Administrator has been asked to extend the Time Travel retention policy to 60 days on the secondary database only.
How can this requirement be met?

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

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

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

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

QUESTION 55
An Administrator has a user who needs to be able to suspend and resume a task based on the current virtual warehouse load, but this user should not be able to modify the task or start a new run.
What privileges should be granted to the user to meet these requirements? (Select TWO).

OWNERSHIP on the task

OWNERSHIP on the database and schema containing the task

USAGE on the database and schema containing the task

OPERATE on the task

EXECUTE TASK on the task