Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
A. STRIP_NULL_VALUES
B. SKIP_BYTE_ORDER_MARK
C. REPLACE_INVALID_CHARACTERS
D. VALIDATION_MODE
Answer:
D
User Votes:
A
50%
B
50%
C
50%
D
50%
Explanation: https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:
Discussions
0/ 1000
Question 3
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
A. The shared objects are transferred.
B. The shared objects are copied.
C. The shared objects become accessible.
D. The shared objects can be re-shared.
Answer:
B
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 4
Using variables in Snowflake is denoted by using which SQL character?
A. @
B. &
C. $
D. #
Answer:
C
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 5
Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)
A. grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
B. grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
C. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
D. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
E. grant SELECT on all tables in database DB1 to role MYROLE;
F. grant SELECT on future tables in database DB1 to role MYROLE;
Answer:
C, D
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
Discussions
0/ 1000
Question 6
How can a user change which columns are referenced in a view?
A. Modify the columns in the underlying table
B. Use the ALTER VIEW command to update the view
C. Recreate the view with the required changes
D. Materialize the view to perform the changes
Answer:
B
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 7
Which statement describes pruning?
A. The filtering or disregarding of micro-partitions that are not needed to return a query.
B. The return of micro-partitions values that overlap with each other to reduce a query's runtime.
C. A service that is handled by the Snowflake Cloud Services layer to optimize caching.
D. The ability to allow the result of a query to be accessed as if it were a table.
Answer:
A
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 8
Which SQL command can be used to see the CREATE definition of a masking policy?
A. SHOW MASKING POLICIES
B. DESCRIBE MASKING POLICY
C. GET_DDL
D. LIST MASKING POLICIES
Answer:
C
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 9
Which of the following is the Snowflake Account_Usage.Metering_History view used for?
A. Gathering the hourly credit usage for an account
B. Compiling an account's average cloud services cost over the previous month
C. Summarizing the throughput of Snowpipe costs for an account
D. Calculating the funds left on an account's contract
Answer:
A
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 10
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
A. Files
B. External tables
C. Secure User-Defined Functions (UDFs)
D. Sequences
E. Streams
Answer:
B, C
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
0/ 1000
Question 12
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
A. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
B. A Data Exchange allows groups of accounts to share data privately among the accounts.
C. A Data Exchange allows accounts to share data with third, non-Snowflake parties.
D. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.
E. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.
Answer:
B
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
0/ 1000
Question 13
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed. What will occur?
A. No virtual warehouse will be used, data will be read from the result cache.
B. No virtual warehouse will be used, data will be read from the local disk cache.
C. The default virtual warehouse will be used to read all data.
D. The virtual warehouse that is defined at the session level will be used to read all data.
Answer:
A
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 14
Which feature allows a user the ability to control the organization of data in a micro-partition?
A. Range Partitioning
B. Search Optimization Service
C. Automatic Clustering
D. Horizontal Partitioning
Answer:
D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 15
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?