Ticking Clock Black Friday Special: 75% Off! Apply coupon code below to save on all exam bundles! - Ends in 0d 00h 00m 00s - Coupon code: 75epass

Exact2Pass Menu

SnowPro Advanced: Administrator

Last Update 1 hour ago Total Questions : 60

The SnowPro Advanced: Administrator content is now fully updated, with all current exam questions added 1 hour ago. Deciding to include ADA-C02 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our ADA-C02 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these ADA-C02 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any SnowPro Advanced: Administrator practice test comfortably within the allotted time.

Question # 11

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

Question # 12

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 # 13

What is needed for credential-free stages to restrict data exfiltration after a storage integration and its associated stages have been created?

A.

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;

B.

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;

C.

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 = false;

D.

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 # 14

Which session parameter can be used to test the integrity of secure views based on the account that accesses the view?

A.

MIMIC_CONSUMER_ACCOUNT

B.

TEST_ACCOUNT_ID

C.

PRODUCER_TEST_ACCT

D.

SIMULATED_DATA_SHARING_CONSUMER

Question # 15

Which SCIM integration types does Snowflake support?

Choose three

A.

Amazon Web Services (AWS)

B.

Google Cloud Platform (GCP)

C.

Okta

D.

Custom

E.

Azure Active Directory (Azure AD)

F.

Duo Security Provisioning Connector

Question # 16

A Snowflake Administrator uses a multi-cluster virtual warehouse in the Snowflake Business-Critical edition. The minimum cluster count is set to 2, and the maximum cluster count is set to 10. This configuration performs well for the normal workload, which seldom exceeds 5 running clusters. However, once each month, several complex long-running queries increase queue time and cause the warehouse to reach its maximum of 10 clusters.

Which solutions will resolve the issues that occur once a month?

Choose two

A.

Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.

B.

Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.

C.

Increase the multi-cluster maximum to 20 or more clusters.

D.

Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.

E.

Increase the minimum number of clusters started in the multi-cluster configuration to 5.

Question # 17

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 # 18

Which roles may be used to create network policies in Snowflake accounts?

Choose three

A.

SYSADMIN

B.

SECURITYADMIN

C.

ACCOUNTADMIN

D.

ORGADMIN

E.

Any role with the global permission of CREATE NETWORK POLICY

F.

Any rote that owns the database where the network policy is created

Go to page: