Question 551 · 1323 in bank
Select 2Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
Show answer
Answer: BE
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
Answer: BE
How would a user run a multi-cluster warehouse in maximized mode?
Answer: C
It is C. If min=max, there is no room for increasing any clusters and min and max would be same. Hence same value for maximized mode. If min < max then there is room for more clusters to go up till max, hence best for scaling.
Source: Adapted from community discussion — CuriouStudious
What internal stages are available in Snowflake? (Choose three.)
Answer: BCE
Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)
Answer: BDF
BDF Uploads (i.e. stages) data files from a local directory/folder on a client machine to one of the following Snowflake stages: Named internal stage. Internal stage for a specified table. Internal stage for the current user.
Source: Adapted from community discussion — GiselaS
Which data type can store more than one type of data structure?
Answer: D
User-level network policies can be created by which of the following roles? (Choose two.)
Answer: BD
Only security administrators (i.e. users with the SECURITYADMIN role) or higher or a role with the global CREATE NETWORK POLICY privilege can create network policies. Ownership of a network policy can be transferred to another role. https://docs.snowflake.com/en/user-guide/network-policies.html#:~:text=A%20security%20administrator%20(or%20higher,any%20number%20of%20network%20policies.
Source: Adapted from community discussion — SV1122
What SQL command would be used to view all roles that were granted to USER1?
Answer: A
Which ACCOUNT_USAGE views are used to evaluate the details of dynamic data masking? (Choose two.)
Answer: BF
Snowflake provides two Account Usage views to obtain information about masking policies: 1. The MASKING POLICIES view provides a list of all masking policies in your Snowflake account. 2. The POLICY_REFERENCES view provides a list of all objects in which a masking policy is set. https://docs.snowflake.com/en/user-guide/security-column-ddm-intro.html
Source: Adapted from community discussion — SV1122
Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)
Which of the following statements are true of Snowflake data loading? (Choose three.)
Answer: ACD
A. VARIANT “null” values are not the same as SQL NULL values: In Snowflake, a VARIANT type can store semi-structured data like JSON. A JSON null is distinct from an SQL NULL. JSON null is treated as a valid value in Snowflake, while SQL NULL represents the absence of a value. B. It is recommended to do frequent, single row DMLs: This is false. Snowflake is optimized for bulk operations, and frequent single-row DMLs (e.g., INSERT, UPDATE, DELETE) are not recommended as they can lead to inefficiencies and higher costs. C. It is recommended to validate the data before loading into the Snowflake target table: This is true. Validating data before loading ensures data quality and avoids errors or inconsistencies in the target table. D. It is recommended to use staging tables to manage MERGE statements: This is true. Staging tables are often used to prepare and validate data before applying MERGE operations, which helps ensure data integrity and efficiency. Correct Choices: A, C, D
Source: Adapted from community discussion — Sudhansu21
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 551. 1323 questions available.
Version 1.0.0. How we source questions