Snowflake
COF-C02
Q1:
What virtual warehouse configuration should be used when processing a large number of complex queries?
○
A
Use the auto-resume feature.○
B
Run the warehouse in auto-scale mode.○
C
Increase the size of the warehouse.○
D
Increase the number of warehouse clusters.
Snowflake
COF-C02
Q2:
Which data protection feature should only be used when all other data recovery options have been attempted?
○
A
Time Travel○
B
Cloning○
C
Replication○
D
Fail-safe
Snowflake
COF-C02
Q3:
Which command should be used to load data incrementally based on column values that are specified in the source table or subquery?
○
A
MERGE○
B
COPY INTO○
C
GET○
D
INSERT INTO
Snowflake
COF-C02
Q4:
How can the outer array structure of a semi-structured file be removed?
○
A
Use the parameter strip_outer_array = true in a COPY INTO <table> command.○
B
Set the file format to eliminate any outer array structure before initiating the COPY INTO <table> command.○
C
Filter the outer array structure using a PUT command with the include_outer_array = false parameter.○
D
Use the FLATTEN command with the outer_array = false parameter.
Snowflake
COF-C02
Q5:
Which table function will identify data that was loaded using COPY INTO statements and also identify data loaded using Snowpipe?
○
A
DATA_TRANSFER_HISTORY○
B
PIPE_USAGE_HISTORY○
C
VALIDATE_PIPE_LOAD○
D
COPY_HISTORY