Question 71 · 1323 in bank
Select 2What transformations are supported when loading data into a table using the COPY INTO [table] command? (Choose two.)
Show answer
Answer: AB
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
What transformations are supported when loading data into a table using the COPY INTO [table] command? (Choose two.)
Answer: AB
Which object can be used with Secure Data Sharing?
Answer: C
Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?
Answer: C
Which commands are restricted in owner's rights stored procedures? (Choose two.)
Answer: AE
Owner’s rights stored procedures have several additional restrictions, besides the restrictions related to session variables and session parameters. These restrictions affect the following: The built-in functions that can be called from inside a stored procedure. Ability to execute ALTER USER statements. Monitoring stored procedures at execution time. SHOW and DESCRIBE commands. The types of SQL statements that can be called from inside a stored procedure.
Source: Adapted from community discussion — nexerSnow
What is the relationship between a Query Profile and a virtual warehouse?
Answer: A
Which transformation is supported by a COPY INTO [table] command?
Answer: C
How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?
Answer: C
How does conditional data masking work in Snowflake?
Answer: D
A. It selectively masks plain text data - because conditional data masking does involve selectively masking data based on certain conditions or criteria. However, it's important to clarify that these conditions are often related to user roles or other security measures rather than the content of the data itself. The key feature of conditional data masking is its ability to dynamically display either the original data or a masked version of the data based on the evaluation of these conditions.
Source: Adapted from community discussion — 663f98f
If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?
Answer: D
If a warehouse runs for 30 to 60 seconds, it is billed for 60 seconds. If a warehouse runs for 61 seconds, it is billed for only 61 seconds. If a warehouse runs for 61 seconds, shuts down, and then restarts and runs for less than 60 seconds, it is billed for 121 seconds (60 + 1 + 60).
Source: Adapted from community discussion — Anblicks
True or False: When active, a Pipe requires a dedicated Virtual Warehouse to execute.
Answer: B
Correct Answer Bulk-loading: Requires virtual warehouse to use COPY INTO command. Snowpipe (continuous loading): Uses Snowflake-supplied compute resources and charges based on how much of that is used.
Source: Adapted from community discussion — lhstudylh
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 71. 1323 questions available.
Version 1.0.0. How we source questions