Black Friday Flash Blitz - 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 75special

Practice Free ADA-C02 SnowPro Advanced: Administrator Exam Questions Answers With Explanation

We at Crack4sure are committed to giving students who are preparing for the Snowflake ADA-C02 Exam the most current and reliable questions . To help people study, we've made some of our SnowPro Advanced: Administrator exam materials available for free to everyone. You can take the Free ADA-C02 Practice Test as many times as you want. The answers to the practice questions are given, and each answer is explained.

Question # 6

Which Snowflake capabilities are typically used for rollback scenarios?

Choose two

A.

SELECT SYSTEM$CANCEL_QUERY(‘problematic_query_id’);

B.

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

C.

CREATE TABLE prd_table_bkp as SELECT * from table(result_scan(‘problematic_query_id’()));

D.

ALTER TABLE prd_table SWAP WITH prd_table_bkp;

E.

Contact Snowflake Support to retrieve Fail-safe data.

Question # 7

What are the advantages of using Snowflake organizations?

Choose two

A.

Administrators can change Snowflake account editions on-demand based on need.

B.

Administrators can monitor and understand usage across all accounts in the organization.

C.

Administrators can simplify data movement across all accounts within the organization.

D.

User administration is simplified across all accounts within the organization.

E.

Administrators have the ability to create accounts in any available cloud provider or region.

Question # 8

Which benefits result from creating and maintaining resource monitors in Snowflake?

Choose three

A.

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

B.

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

C.

Resource monitors add no additional load to virtual warehouse compute.

D.

Multiple triggers can be configured across various virtual warehouse thresholds.

E.

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

F.

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

Question # 9

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?

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

Question # 10

C. reating a stream on a standard table requires the CREATE STREAM privilege on the target schema and SELECT on the source table. The role also needs USAGE on the parent database and schema to access objects in that location.

An Administrator loads data into a staging table each day. After it is loaded, users from several different departments transform 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?

A.

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

B.

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

C.

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

D.

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

Question # 11

A company has enabled replication between accounts and is ready to replicate data across Regions within the same cloud service provider.

The primary database object is: PROD_AWS_EAST. Location: AWS_EAST.

The secondary database object is: PROD_AWS_WEST. Location: AWS_WEST.

What command and account location are required to refresh the data?

A.

Location : AWS_WEST -Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;

B.

Location : AWS_WEST -Command : ALTER DATABASE PROD_AWS_WEST REFRESH;

C.

Location : AWS_EAST -Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;

D.

Location : AWS_EAST -Command : ALTER DATABASE PROD_AWS_WEST REFRESH;

Question # 12

Which type of Snowflake Marketplace listing can be added and queried right away?

A.

Monetized listing

B.

Standard listing

C.

Regional listing

D.

Personalized listing

Question # 13

A Snowflake organization, MYORG, contains two Snowflake accounts:

ADA-C02 question answer

ACCOUNT1 has a database named PROD_DB and has the ORGADMIN role enabled. Management wants PROD_DB replicated to ACCOUNT2.

A.

re any configuration steps required in ACCOUNT1 before database replication can be configured and started in ACCOUNT2?

B.

USE ROLE ORGADMIN;

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER(

'MYORG.ACCOUNT1',

'ENABLE_ACCOUNT_DATABASE_REPLICATION',

'TRUE'

);

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER(

'MYORG.ACCOUNT2',

'ENABLE_ACCOUNT_DATABASE_REPLICATION',

'TRUE'

);

USE ROLE ACCOUNTADMIN;

ALTER DATABASE PROD_DB

ENABLE REPLICATION TO ACCOUNTS MYORG.ACCOUNT2;

C.

USE ROLE ORGADMIN;

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER(

'MYORG.ACCOUNT1',

'ENABLE_ACCOUNT_DATABASE_REPLICATION',

'TRUE'

);

USE ROLE ACCOUNTADMIN;

ALTER DATABASE PROD_DB

ENABLE REPLICATION TO ACCOUNTS MYORG.ACCOUNT2

IGNORE EDITION CHECK;

D.

No configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.

E.

It is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.

Question # 14

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

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

Question # 15

A user has enrolled in multi-factor authentication (MFA) to connect to Snowflake. The user tells the Snowflake Administrator that they lost their mobile phone the prior evening.

Which action should the Administrator take to enable the user to sign in to the system without revoking the user’s MFA enrollment?

A.

Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.

B.

Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.

C.

Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.

D.

Instruct the user to append the normal URL with /?mode=mfa_bypass & code= to log on.

Question # 16

A development team has created a new schema for a new project. The developers hold the DEV_TEAM role, which was configured with these statements:

USE ROLE SECURITYADMIN;

C. REATE ROLE DEV_TEAM;

GRANT USAGE, CREATE SCHEMA ON DATABASE DEV_DB01 TO ROLE DEV_TEAM;

GRANT USAGE ON WAREHOUSE DEV_WH TO ROLE DEV_TEAM;

E. ach team member's access is configured with the following statements:

USE ROLE SECURITYADMIN;

C. REATE ROLE JDOE_PROFILE;

C. REATE USER JDOE LOGIN_NAME = ’JDOE’ DEFAULT_ROLE=’JDOE PROFILE’;

GRANT ROLE JDOE_PROFILE TO USER JDOE;

GRANT ROLE DEV_TEAM TO ROLE JDOE_PROFILE;

New tables created by any developer cannot be accessed by the team as a whole. How can an Administrator resolve this issue?

A.

Assign ownership privilege to DEV_TEAM on the newly-created schema.

B.

Assign usage privilege on the virtual warehouse DEV_WH to the role JDOE_PROFILE.

C.

Set up future grants on the newly-created schemas.

D.

Set up the new schema as a managed-access schema.

Question # 17

What is one characteristic of Snowflake’s transaction locking and concurrency model?

A.

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

B.

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

C.

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

D.

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

Question # 18

In which scenario does using an external table simplify a data pipeline?

A.

When accessing a Snowflake table from a relational database

B.

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

C.

When continuously writing data from a Snowflake table to external storage

D.

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

ADA-C02 PDF

$27.5

$109.99

3 Months Free Update

  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions

ADA-C02 PDF + Testing Engine

$44

$175.99

3 Months Free Update

  • Exam Name: SnowPro Advanced: Administrator
  • Last Update: Nov 22, 2026
  • Questions and Answers: 60
  • Free Real Questions Demo
  • Recommended by Industry Experts
  • Best Economical Package
  • Immediate Access

ADA-C02 Engine

$33

$131.99

3 Months Free Update

  • Best Testing Engine
  • One Click installation
  • Recommended by Teachers
  • Easy to use
  • 3 Modes of Learning
  • State of Art Technology
  • 100% Real Questions included