Question 1

After running the function SYSTEM$CLUSTERING_INFORMATION in a table, it returns the following information:What parameters indicate that the table is not well-clustered? (Choose three.)

Options :

A : Most micro-partitions are grouped at the lower end of the histogram, with most micro-partitions having an overlap depth between 64 and 128.

B : High average of overlapping micro-partitions.

C : Zero (0) constant micro-partitions out of 1156 total micro-partitions.

D : Low average of overlap depth across micro-partitions.

Answer: A,B,C

Question 2

A Data Architect has set up continuous data ingestion using Snowpipe. After a few days of successful data ingestion, the Architect must modify the pipe definition of the referenced external stage.What are the recommended steps the Architect should take?

Options :

A : • Pause the pipe using an ALTER_PIPE statement, confirm the pending file count is 0• Recreate the pipe to change the COPY statement and pause the pipe• Review the configuration steps for the cloud message service to ensure settings are accurate• Resume the pipe and verify the pipe execution status is running

B : • Pause the pipe using an ALTER_PIPE statement, confirm the pending file count is 0• Recreate the pipe to change the COPY statement• Review the configuration steps for the cloud message service to ensure settings are accurate• Resume the pipe and verify pipe execution status is running

C : • Create the pipe using the CREATE_PIPE statement, confirm the pending file count is 1• Recreate the pipe to change the COPY statement and pause the pipe• Review configuration steps for the cloud message service to ensure settings are accurate• Resume the pipe using the SET_PIPE statement and verty pipe execution status is running

D : • Pause the pipe using the SET_PIPE statement and make sure the pending file count is 1• Recreate the pipe to change the COPY statement• Review the configuration steps for the cloud message service to ensure settings are accurate• Resume the pipe using the START_PIPE statement and verify pipe execution status is running

Answer: A

Question 3

After creating a database and a schema using the following commands:CREATE OR REPLACE DATABASE MY_DB DATA_RETENTION_TIME_IN_DAYS=30;CREATE OR REPLACE SCHEMA S1 DATA_RETENTION_TIME_IN_DAYS=50;How long will we be able to access the data from the schema using the Time Travel functionality if we drop the database?

Options :

A : 90 days.

B : 50 days.

C : The default time of the account.

D : 30 days.

Answer: D

Question 4

While using joins, non-equality join predicates might result in significantly slower processing speeds and should be avoided if possible.

Options :

A : TRUE

B : FALSE

Answer: A

Question 5

A company has a table with that has corrupted data, named Data. The company wants to recover the data as it was 5 minutes ago using cloning and Time Travel. What command will accomplish this?

Options :

A : CREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);

B : CREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);

C : CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);

D : CREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);

Answer: C

Free ARA-C01 Mock Exam – Practice Online Confidently

Buying Options: