Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
SnowPro Core
Free trial
Verified
Question 201
How does Snowflake optimize queries on tables by leveraging the sorting and storage of data within micro-partitions?
- A: The data is pruned by column to eliminate unnecessary micro-partitions, then the rows within the remaining micro-partitions are filtered.
- B: The data is pruned by micro-partitions based on column values, then rows within the remaining micro-partitions are filtered.
- C: Any micro-partitions that are not needed for the query are pruned, then the data within the remaining micro-partitions is pruned by column.
- D: The data within micro-partitions is sorted by rows, then the columns are filtered based on the query conditions.
Question 202
Which resource monitor setting will cancel all active queries in a virtual warehouse when the threshold is met?
- A: NOTIFY
- B: NOTIFY_USERS
- C: SUSPEND
- D: SUSPEND_IMMEDIATE
Question 203
What role should be used when creating a new user?
- A: ORGADMIN
- B: SECURITYADMIN
- C: USERADMIN
- D: SYSADMIN
Question 204
Which ACCOUNT_USAGE view will identify long-running queries?
- A: DATA_TRANSFER_HISTORY
- B: TASK_HISTORY
- C: QUERY_HISTORY
- D: METERING_DAILY_HISTORY
Question 205
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
- A: True
- B: False
Question 206
When sharing data among multiple Snowflake accounts, what charges are incurred by a data consumer when viewing shared data using their own account?
- A: Cloud services charges
- B: Compute charges
- C: Data storage charges
- D: Data egress charges
Question 207
What is the MINIMUM Snowflake edition required to use the query acceleration service?
- A: Standard
- B: Enterprise
- C: Business Critical
- D: Virtual Private Snowflake (VPS)
Question 208
Which objects can be cloned in Snowflake? (Choose two.)
- A: Virtual warehouses
- B: Internal named stages
- C: External named stages
- D: Dynamic tables
- E: External tables
Question 209
What happens to foreign key constraints when a table is cloned to another database?
- A: All referenced tables will be cloned.
- B: The cloned table will reference the primary key in the source table.
- C: The cloned table will lose all references to the primary key.
- D: The cloned table will lose all references to the foreign and primary keys
Question 210
What step must be taken to ensure that a user can only access Snowsight from a specific location, or when working from home?
- A: Use a company Virtual Private Network (VPN) connection.
- B: Use Multi-Factor Authentication (MFA).
- C: Use Single Sign-On (SSO).
- D: Add the user's IP address to the network policy allowed list.
Question 211
What actions will trigger a data pipe to load? (Choose two.)
- A: Use of an INSERT statement
- B: Use of a COPY INTO [table] statement
- C: Use of the insertFiles REST endpoint
- D: Use of the insertReport REST endpoint
- E: Set the pipe parameter to auto-ingest
Question 212
What does a Query Profile metric that shows excessive spillage indicate?
- A: Poor query optimization
- B: Expired temporary tables
- C: Improper virtual warehouse sizing
- D: Improper Common Table Expressions (CTEs)
Question 213
A query is using more credits than expected. The Query Profile shows that a majority of the query execution is spent on remote disk I/O.
How can this be prevented in the future?
- A: Convert the virtual warehouse to Maximized mode.
- B: Increase the size of the virtual warehouse.
- C: Increase the auto suspend time in the virtual warehouse.
- D: Increase the number of clusters in the virtual warehouse.
Question 214
In a SPLIT_PART function, what will the returned value be if the partNumber is out of range?
- A: −1
- B: An empty string
- C: The full string
- D: An error
Question 215
From which locations can data files be downloaded using the GET command? (Choose two.)
- A: External stage
- B: Table stage
- C: User stage
- D: Directory table
- E: Permanent table
Question 216
Which of the following commands sets the Virtual Warehouse for a session?
- A: COPY WAREHOUSE FROM <<config file>>;
- B: SET WAREHOUSE = <<warehouse name>>;
- C: USE WAREHOUSE <<warehouse name>>;
- D: USE VIRTUAL_WAREHOUSE <<warehouse name>>;
Question 217
How would you determine the size of the virtual warehouse used for a task?
- A: Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
- B: Querying (SELECT) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
- C: If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
- D: Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
Question 218
What Snowflake features are recommended to restrict unauthorized users from accessing Personal Identifiable Information (PI)? (Choose two.)
- A: Dynamic Data Masking
- B: Transient tables
- C: Secure views
- D: Multi-Factor Authentication (MFA)
- E: Data encryption
Question 219
Which Snowflake keywords help retrieve data without the need to completely scan a table? (Choose two.)
- A: TOP [n]
- B: LIMIT
- C: FETCH
- D: SAMPLE
- E: TABLESAMPLE
Question 220
A complex query has been running in Snowsight for more than one hour. At the same time, several other queries from other worksheets ran successfully.
What is FASTEST way to cancel the long-running query?
- A: Immediately suspend the virtual warehouse that the query is running on.
- B: Return to the worksheet and abort the query.
- C: Set the auto_suspend virtual warehouse property to 0.
- D: Find the query in the query activity view and cancel the query.
Question 221
How can a Snowflake user automate virtual warehouse operations for optimal credit consumption? (Choose two.)
- A: Auto-resume when a query is in a queue.
- B: Auto-resume after a set time period.
- C: Auto-suspend while the query is being written.
- D: Auto-suspend after a set time period.
- E: Auto-suspend after a specified period of inactivity.
Question 222
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
Question 223
A single cluster virtual warehouse has no free resources.
What will happen to new queries that are run against this warehouse?
- A: The queries will be assigned to another virtual warehouse.
- B: The queries will be skipped.
- C: The queries will be placed in a queue.
- D: The warehouse will automatically resize and execute the queries.
Question 224
How does the search optimization service improve query performance?
- A: By clustering the tables
- B: By creating a persistent data structure
- C: By using caching
- D: By optimizing the use of micro-partitions
Question 225
Use of what parameter will allow files to be loaded even if the file metadata has expired?
- A: MATCH_BY_COLUMN_NAME = CASE_INSENSITIVE
- B: ENFORCE_LENGTH = TRUE
- C: PURGE = TRUE
- D: LOAD_UNCERTAIN_FILES = TRUE
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!