Updated Feb-2023 COF-R02 Free Exam Files Downloaded Instantly
Practice Exams and Training Solutions for Certifications
NEW QUESTION 152
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
- A. Data can be filtered by an optional where clause
- B. Row level access can be defined
- C. Columns can be omitted
- D. Incoming data can be joined with other tables
- E. Columns can be reordered
Answer: C,E
NEW QUESTION 153
A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?
- A. Produce the largest files possible, reducing the overall number of files to process.
- B. Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.
- C. Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
- D. Use auto-ingest Snowpipes to load large files in a serverless model.
Answer: A
NEW QUESTION 154
What feature can be used to reorganize a very large table on one or more columns?
- A. Clustered partitions
- B. Micro-partitions
- C. Clustering keys
- D. Key partitions
Answer: C
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
NEW QUESTION 155
True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
- A. True
- B. False
Answer: A
Explanation:
Explanation
Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.
NEW QUESTION 156
What is the minimum Snowflake edition required to use Dynamic Data Masking?
- A. Virtual Private Snowflake (VPC)
- B. Enterprise
- C. Business Critical
- D. Standard
Answer: A
NEW QUESTION 157
True or False: A Virtual Warehouse can be resized while suspended.
- A. True
- B. False
Answer: A
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse
NEW QUESTION 158
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?
- A. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
- B. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
- C. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
- D. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
Answer: D
NEW QUESTION 159
Which of the following objects can be directly restored using the UNDROP command? (Choose two.)
- A. Internal stage
- B. User
- C. Schema
- D. View
- E. Role
- F. Table
Answer: C,F
NEW QUESTION 160
How would a user execute a series of SQL statements using a task?
- A. Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..
- B. A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();
- C. Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();
- D. Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.
Answer: D
NEW QUESTION 161
User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?
- A. SHOW GRANTS TO USER INQUISITIVE_PERSON
- B. SHOW GRANTS OF ROLE DATA_SCIENCE
- C. SHOW GRANTS ON ROLE DATA_SCIENCE
- D. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
Answer: D
NEW QUESTION 162
What is the maximum Time Travel retention period for a temporary Snowflake table?
- A. 7 days
- B. 1 day
- C. 45 days
- D. 90 days
Answer: B
NEW QUESTION 163
Which Snowflake feature is used for both querying and restoring data?
- A. Cluster keys
- B. Fail-safe
- C. Cloning
- D. Time Travel
Answer: D
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%
NEW QUESTION 164
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
- A. Tasks
- B. Procedures
- C. Pipes
- D. Streams
Answer: D
Explanation:
Explanation
https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%
NEW QUESTION 165
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. 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
- C. 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
- D. 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
Answer: B
NEW QUESTION 166
Users are responsible for data storage costs until what occurs?
- A. Data is deleted from a table
- B. Data is truncated from a table
- C. Data expires from Time Travel
- D. Data expires from Fail-safe
Answer: D
NEW QUESTION 167
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
- A. 7 days
- B. 48 hours
- C. 30 days
- D. 24 hours
Answer: D
NEW QUESTION 168
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake?
(Choose two.)
- A. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
- B. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
- C. All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
- D. The ACCOUNTADMIN role must be granted to only one user.
- E. All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.
Answer: A,B
NEW QUESTION 169
How would a user run a multi-cluster warehouse in maximized mode?
- A. Configure the maximum clusters setting to "Maximum."
- B. Set the minimum Clusters and maximum Clusters settings to the same value.
- C. Turn on the additional clusters manually after starting the warehouse.
- D. Set the minimum clusters and maximum clusters settings to different values.
Answer: D
NEW QUESTION 170
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
- A. Set the Warehouse type to "Auto"
- B. Set the Minimum Clusters and Maximum Clusters settings to the same value
- C. Configure the Maximum Clusters setting to "Auto-Scale"
- D. Set the Minimum Clusters and Maximum Clusters settings to the different values
Answer: D
Explanation:
Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse
NEW QUESTION 171
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
- A. Database storage
- B. Query processing
- C. Authentication and access control
- D. Metadata management
- E. Local disk caching
Answer: B,D
NEW QUESTION 172
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
- A. Snowflake leverages a Role-Based Access Control (RBAC) model.
- B. Snowflake can run within a user's own Virtual Private Cloud (VPC).
- C. Snowflake requires a user to configure an IAM user to connect to the database.
- D. All data in Snowflake is compressed.
- E. All data in Snowflake is encrypted.
Answer: A,B
NEW QUESTION 173
Which stage type can be altered and dropped?
- A. External stage
- B. User stage
- C. Database stage
- D. Table stage
Answer: D
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages
NEW QUESTION 174
......
Q&As with Explanations Verified & Correct Answers: https://exampasspdf.testkingit.com/Snowflake/latest-COF-R02-exam-dumps.html