Practice Free SnowPro Core Exam Online Questions
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.
What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
- A . A VARIANT column
- B . A column with very low cardinality
- C . A column with very high cardinality
- D . A column that is most actively used in selective filters
- E . A column that is most actively used in join predicates
How long is Snowpipe data load history retained?
- A . As configured in the create pipe settings
- B . Until the pipe is dropped
- C . 64 days
- D . 14 days
What are common issues found by using the Query Profile? (Choose two.)
- A . Identifying queries that will likely run very slowly before executing them
- B . Locating queries that consume a high amount of credits
- C . Identifying logical issues with the queries
- D . Identifying inefficient micro-partition pruning
- E . Data spilling to a local or remote disk
A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
- A . 1 second
- B . 60 seconds
- C . 5 minutes
- D . 60 minutes
Which of the following describes external functions in Snowflake?
- A . They are a type of User-defined Function (UDF).
- B . They contain their own SQL code.
- C . They call code that is stored inside of Snowflake.
- D . They can return multiple rows for each row received
When cloning a database, what is cloned with the database? (Choose two.)
- A . Privileges on the database
- B . Existing child objects within the database
- C . Future child objects within the database
- D . Privileges on the schemas within the database
- E . Only schemas and tables within the database
Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)
- A . Caching query results
- B . Running EXPLAIN and SHOW commands
- C . Cloning a database
- D . Running a custom query
- E . Running COPY commands
Which features make up Snowflake’s column level security? (Select TWO).
- A . Continuous Data Protection (CDP)
- B . Dynamic Data Masking
- C . External Tokenization
- D . Key pair authentication
- E . Row access policies
What are supported file formats for unloading data from Snowflake? (Choose three.)
- A . XML
- B . JSON
- C . Parquet
- D . ORC
- E . AVRO
- F . CSV