Power Up Your Study Prep: Black Friday 75% Discount! Use coupon code below to save! - Ends in 0d 00h 00m 00s - Coupon code: big75certs

SnowPro Advanced: Administrator ADA-C02 Dumps PDF

Page: 2 / 5
Total 60 questions

SnowPro Advanced: Administrator Questions and Answers

Question 5

MY_TABLE is a table that has not been updated or changed for several days. On 01 January 2021 at 07:01, a user ran a query that updated this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.

Which queries allow the user to view the historical data that was in the table before this query ran?

Choose three

Options:

A.

SELECT * FROM my_table WITH TIME_TRAVEL(OFFSET = > -60*30);

B.

SELECT * FROM my_table AT(TIMESTAMP = > '2021-01-01 07:00:00'::timestamp);

C.

SELECT * FROM TIME_TRAVEL('MY_TABLE', 2021-01-01 07:00:00);

D.

SELECT * FROM my_table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';

E.

SELECT * FROM my_table AT(OFFSET = > -60*30);

F.

SELECT * FROM my_table BEFORE(STATEMENT = > '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

Question 6

Which Snowflake objects can be managed through SCIM integration?

Choose two

Options:

A.

Stages

B.

Users

C.

Warehouses

D.

Roles

E.

Shares

Question 7

An Administrator must configure a Snowflake virtual warehouse for a new use case with these details:

B. etween 50 and 100 concurrent users will run reports.

C. osts must be minimized according to the number of users active at a particular time.

The virtual warehouse must automatically suspend and resume based on user activity.

Which configuration meets these requirements?

Options:

A.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = MEDIUM

AUTO_SUSPEND = 600

AUTO_RESUME = TRUE;

B.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = XXXLARGE

MAX_CLUSTER_COUNT = 10

SCALING_POLICY = STANDARD

AUTO_SUSPEND = 600

AUTO_RESUME = FALSE;

C.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = XXXLARGE

AUTO_SUSPEND = 60

AUTO_RESUME = TRUE;

D.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = MEDIUM

MAX_CLUSTER_COUNT = 10

SCALING_POLICY = STANDARD

AUTO_SUSPEND = 600

AUTO_RESUME = TRUE;

Question 8

A large multinational company with numerous operating regions needs data to be shared bidirectionally among all offices: from the head office to regional offices and among regional offices themselves. The company holds a Snowflake account, with its European operations deployed in Microsoft Azure in a single region, while North American regional offices use AWS in a single region as their deployment cloud. This configuration is required to comply with Personal Identifiable Information (PII) regulations in certain European countries. The corporate head office is located in Europe.

How can the data be shared bidirectionally while MINIMIZING costs?

Options:

A.

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

B.

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.

C.

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

D.

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

Page: 2 / 5
Total 60 questions