ExamGecko
Home / Snowflake / SnowPro Core
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 15

Question list
Search

Question 141

Report
Export
Collapse

Network policies can be set at which Snowflake levels? (Choose two.)

Role
Role
Schema
Schema
User
User
Database
Database
Account
Account
Tables
Tables
Suggested answer: C, E

Explanation:

Network policies in Snowflake can be set at the user level and at the account level2.

asked 23/09/2024
Nipunika Jayasundara
36 questions

Question 142

Report
Export
Collapse

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.
Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.
Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 365 days. Fail Safe retention time is 7 days.
Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 365 days. Fail Safe retention time is 7 days.
Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.
Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.
Default Time Travel Retention is set to 90 days. Maximum Time Travel Retention is 7 days. Fail Safe retention time is 356 days.
Default Time Travel Retention is set to 90 days. Maximum Time Travel Retention is 7 days. Fail Safe retention time is 356 days.
Suggested answer: D

Explanation:

In the Snowflake Enterprise Edition, the default Time Travel retention is set to 1 day, the maximum Time Travel retention can be set up to 90 days, and the Fail-safe retention time is 7 days3.

asked 23/09/2024
JR Gee
33 questions

Question 143

Report
Export
Collapse

Which of the following objects are contained within a schema? (Choose two.)

Role
Role
Stream
Stream
Warehouse
Warehouse
External table
External table
User
User
Share
Share
Suggested answer: B, D

Explanation:

In Snowflake, a schema is a logical grouping of database objects, which can include streams and external tables. A stream is an object that allows users to query data that has changed in specified tables or views, and an external table is a table that references data stored outside of Snowflake. Roles, warehouses, users, and shares are not contained within a schema.

Reference:SHOW OBJECTS,Database, Schema, & Share DDL

asked 23/09/2024
William Hyde
40 questions

Question 144

Report
Export
Collapse

Which of the following statements describe features of Snowflake data caching? (Choose two.)

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
When the data cache is full, the least-recently used data will be cleared to make room.
When the data cache is full, the least-recently used data will be cleared to make room.
A user can only access their own queries from the query result cache.
A user can only access their own queries from the query result cache.
A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
The RESULT_SCAN table function can access and filter the contents of the query result cache.
The RESULT_SCAN table function can access and filter the contents of the query result cache.
Suggested answer: B, E

Explanation:

Snowflake's data caching features include the ability to clear the least-recently used data when the data cache is full to make room for new data. Additionally, the RESULT_SCAN table function can access and filter the contents of the query result cache, allowing users to retrieve and work with the results of previous queries. The other statements are incorrect: the data cache is not saved on the remote storage layer when a virtual warehouse is suspended, users can access queries from the query result cache that were run by other users, and there is no setting called USE_METADATA_CACHE in Snowflake.

Reference:Caching in the Snowflake Cloud Data Platform,Optimizing the warehouse cache

asked 23/09/2024
Robert Miletich
46 questions

Question 145

Report
Export
Collapse

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:

COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:

Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

Compress the file and load the compressed file.
Compress the file and load the compressed file.
Split the file into multiple files in the recommended size range (100 MB - 250 MB).
Split the file into multiple files in the recommended size range (100 MB - 250 MB).
Use a larger-sized warehouse.
Use a larger-sized warehouse.
Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.
Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.
Suggested answer: B

Explanation:

The error ''Max LOB size (16777216) exceeded'' indicates that the size of the parsed column exceeds the maximum size allowed for a single column value in Snowflake, which is 16 MB. To resolve this issue, the file should be split into multiple smaller files that are within the recommended size range of 100 MB to 250 MB. This will ensure that each JSON document within the files is smaller than the maximum LOB size allowed. Compressing the file, using a larger-sized warehouse, or setting STRIP_OUTER_ARRAY=TRUE will not resolve the issue of the column size exceeding the maximum allowed.

Reference:COPY INTO Error during Structured Data Load: ''Max LOB size (16777216) exceeded...''

asked 23/09/2024
Muneer Deers
43 questions

Question 146

Report
Export
Collapse

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Tri-Secret Secure
Tri-Secret Secure
Time Travel
Time Travel
Fail-safe
Fail-safe
Data encryption
Data encryption
External stages
External stages
Suggested answer: B, C

Explanation:

The features associated with Continuous Data Protection (CDP) that require additional Snowflake-provided data storage are Time Travel and Fail-safe. Time Travel allows users to access historical data within a defined period, while Fail-safe provides an additional layer of data protection beyond the Time Travel period.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Lal George
26 questions

Question 147

Report
Export
Collapse

Where can a user find and review the failed logins of a specific user for the past 30 days?

The USERS view in ACCOUNT_USAGE
The USERS view in ACCOUNT_USAGE
The LOGIN_HISTORY view in ACCOUNT_USAGE
The LOGIN_HISTORY view in ACCOUNT_USAGE
The ACCESS_HISTORY view in ACCOUNT_USAGE
The ACCESS_HISTORY view in ACCOUNT_USAGE
The SESSIONS view in ACCOUNT_USAGE
The SESSIONS view in ACCOUNT_USAGE
Suggested answer: B

Explanation:

The LOGIN_HISTORY view in the ACCOUNT_USAGE schema provides information about login attempts, including both successful and failed logins. This view can be used to review the failed login attempts of a specific user for the past 30 days.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Amir Arefi
35 questions

Question 148

Report
Export
Collapse

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

Snowflake leverages a Role-Based Access Control (RBAC) model.
Snowflake leverages a Role-Based Access Control (RBAC) model.
Snowflake requires a user to configure an IAM user to connect to the database.
Snowflake requires a user to configure an IAM user to connect to the database.
All data in Snowflake is encrypted.
All data in Snowflake is encrypted.
Snowflake can run within a user's own Virtual Private Cloud (VPC).
Snowflake can run within a user's own Virtual Private Cloud (VPC).
All data in Snowflake is compressed.
All data in Snowflake is compressed.
Suggested answer: A, C

Explanation:

Snowflake uses a Role-Based Access Control (RBAC) model to manage access to data and resources. Additionally, Snowflake ensures that all data is encrypted, both at rest and in transit, to provide a high level of security for data stored within the platform.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
Sergio Escobar
34 questions

Question 149

Report
Export
Collapse

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete

2. Leaves for 15 minutes

3. Returns and runs a query that takes 10 seconds to complete

4. Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

4 minutes
4 minutes
10 minutes
10 minutes
14 minutes
14 minutes
24 minutes
24 minutes
Suggested answer: C

Explanation:

The billable compute time includes the time the warehouse is running queries plus the auto-suspend time after the last query if the warehouse is not manually suspended. In this scenario, the warehouse runs for 3 minutes, suspends after 10 minutes of inactivity, resumes for a 10-second query, and then is manually suspended. The total billable time is the sum of the initial 3 minutes, the 10 minutes of auto-suspend time, and the brief period for the 10-second query, which is rounded up to the next full minute due to Snowflake's billing practices.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide

asked 23/09/2024
andrea rosi
44 questions

Question 150

Report
Export
Collapse

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Removing a column from the query SELECT list
Removing a column from the query SELECT list
Stopping the virtual warehouse that the query is running against
Stopping the virtual warehouse that the query is running against
Clustering of the data used by the query
Clustering of the data used by the query
Executing the RESULTS_SCAN() table function
Executing the RESULTS_SCAN() table function
Changing a column that is not in the cached query
Changing a column that is not in the cached query
Suggested answer: B, D

Explanation:

The ResultSet cache is leveraged to quickly return results for repeated queries. Actions that prevent leveraging this cache include stopping the virtual warehouse that the query is running against (B) and executing the RESULTS_SCAN() table function (D).Stopping the warehouse clears the local disk cache, including the ResultSet cache1. The RESULTS_SCAN() function is used to retrieve the result of a previously executed query, which bypasses the need for the ResultSet cache.

asked 23/09/2024
Narender B
31 questions
Total 627 questions
Go to page: of 63