Question 1

Choose the different ways that you have to optimize query performance

Options :

A : Clustering a table

B : Creating one or more materialized views

C : Search Optimization

D : Vacuuming

Answer: A,B,C

Question 2

An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously. Which commands should the Architect use to load only file5.csv file from the stage? (Choose two.)

Options :

A : COPY INTO tablea FROM @%tablea RETURN_FAILED_ONLY = TRUE;

B : COPY INTO tablea FROM @%tablea;

C : COPY INTO tablea FROM @%tablea FILES = ('file5.csv');

D : COPY INTO tablea FROM @%tablea FORCE = TRUE;

E : COPY INTO tablea FROM @%tablea NEW_FILES_ONLY = TRUE;

F : COPY INTO tablea FROM @%tablea MERGE = TRUE;

Answer: B,C

Question 3

A Snowflake Architect Is working with Data Modelers and Table Designers to draft an ELT framework specifically for data loading using Snowpipe. The Table Designers will add a timestamp column that Inserts the current tlmestamp as the default value as records are loaded into a table. The Intent is to capture the time when each record gets loaded into the table; however, when tested the timestamps are earlier than the loae_take column values returned by the copy_history function or the Copy_HISTORY view (Account Usage). Why Is this occurring?

Options :

A : The timestamps are different because there are parameter setup mismatches. The parameters need to be realigned

B : The Snowflake timezone parameter Is different from the cloud provider-s parameters causing the mismatch.

C : The Table Designer team has not used the localtimestamp or systimestamp functions in the Snowflake copy statement.

D : The CURRENT_TIMEis evaluated when the load operation is compiled in cloud services rather than when the record is inserted into the table.

Answer: D

Question 4

What is the function of Resource Monitors regarding data pipelines?

Options :

A : Make data not being replicated twice in the same pipeline

B : It performs backups for your pipelines every 5 minutes

C : It helps you monitor and control the costs of your pipelines

Answer: C

Question 5

A table for IOT devices that measures water usage is created. The table quickly becomes large and contains more than 2 billion rows. The general query patterns for the table are: 1. DeviceId, lOT_timestamp and Customerld are frequently used in the filter predicate for the select statement 2. The columns City and DeviceManuf acturer are often retrieved 3. There is often a count on Uniqueld Which field(s) should be used for the clustering key?

Options :

A : lOT_timestamp

B : City and DeviceManuf acturer

C : Deviceld and Customerld

D : Uniqueld

Answer: C

Free SnowPro-Advanced-Architect Mock Exam – Practice Online Confidently

Buying Options: