[Jun 16, 2023] SnowPro-Core Free Exam Questions with Quality Guaranteed [Q213-Q235]

NEW QUESTION 213
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

NEW QUESTION 214
What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

NEW QUESTION 215
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers

NEW QUESTION 216
How long is the Fail-safe period for temporary and transient tables?

NEW QUESTION 217
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

NEW QUESTION 218
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

NEW QUESTION 219
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?

NEW QUESTION 220
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers

NEW QUESTION 221
True or False: You can resize a Virtual Warehouse while queries are running.

NEW QUESTION 222
True or False: It is possible to load data into Snowflake without creating a named File Format object.

NEW QUESTION 223
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

NEW QUESTION 224
which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.

NEW QUESTION 225
What is the default character set used when loading CSV files into Snowflake?

NEW QUESTION 226
Which of the following DML commands isn’t supported by Snowflake?

NEW QUESTION 227
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

NEW QUESTION 228
What is a best practice after creating a custom role?

NEW QUESTION 229
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

NEW QUESTION 230
When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers

NEW QUESTION 231
Which of the following statements is true of zero-copy cloning?

NEW QUESTION 232
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

NEW QUESTION 233
What type of query benefits the MOST from search optimization?

NEW QUESTION 234
On which of the following cloud platform can a Snowflake account be hosted?
Choose 2 answers

NEW QUESTION 235
True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer’s Snowflake account.