Practice Free SnowPro Core Exam Online Questions
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
- A . UPDATE TABLE FROM STREAM
- B . SELECT FROM STREAM
- C . INSERT INTO TABLE SELECT FROM STREAM
- D . ALTER TABLE AS SELECT FROM STREAM
- E . BEGIN COMMIT
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
- A . SCIM
- B . Federated authentication
- C . TLS 1.2
- D . Key-pair authentication
- E . OAuth
- F . OCSP authentication
Which copy INTO command outputs the data into one file?
- A . SINGLE=TRUE
- B . MAX_FILE_NUMBER=1
- C . FILE_NUMBER=1
- D . MULTIPLE=FAISE
What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)
- A . The clone always stays in sync with the original table.
- B . The clone has better query performance.
- C . The clone is created almost instantly.
- D . The clone will have time travel history from the original table.
- E . The clone saves space by not duplicating storage.
What transformations are supported in a CREATE PIPE … AS COPY … FROM (….) statement? (Select
TWO.)
- A . Data can be filtered by an optional where clause
- B . Incoming data can be joined with other tables
- C . Columns can be reordered
- D . Columns can be omitted
- E . Row level access can be defined
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
- A . 30 days
- B . 7 days
- C . 48 hours
- D . 24 hours
What is the MAXIMUM Time Travel retention period for a transient table?
- A . O days
- B . 1 day
- C . 7 days
- D . 90 days
What actions will prevent leveraging of the ResultSet cache? (Choose two.)
- A . Removing a column from the query SELECT list
- B . Stopping the virtual warehouse that the query is running against
- C . Clustering of the data used by the query
- D . Executing the RESULTS_SCAN() table function
- E . Changing a column that is not in the cached query
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
- A . In the metadata of the target table for 14 days
- B . In the metadata of the pipe for 14 days
- C . In the metadata of the target table for 64 days
- D . In the metadata of the pipe for 64 days
Which statement describes how Snowflake supports reader accounts?
- A . A reader account can consume data from the provider account that created it and combine it with its own data.
- B . A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
- C . The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
- D . The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.