Current SnowPro-Core Exam Dumps [2023] Complete Snowflake Exam Smoothly [Q111-Q131]

Current SnowPro-Core  Exam Dumps [2023] Complete Snowflake Exam Smoothly

SnowPro-Core Premium PDF & Test Engine Files with 415 Questions & Answers

How to book the SnowPro Core Certification

To apply for the SnowPro Core Certification, You have to follow these steps:

• Attempt the exam whenever you want
• Click Add to Cart and complete your registration/purchase
• Click Enroll and log in to your Snowpro account

What is the duration, language, and format of SnowPro Core Certification

• No negative marking for wrong answers
• Passing grade: 70%
• Type of Questions: Multiple choice (MCQs), multiple answers

 

NEW QUESTION 111
What is the recommended file sizing for data loading using Snowpipe?

• A. A compressed file size greater than 100 MB, and up to 250 MB
• B. A compressed file size greater than 1 GB, and up to 2 GB
• C. A compressed file size greater than 10 MB, and up to 100 MB
• D. A compressed file size greater than 100 GB, and up to 250 GB

Answer: A

Explanation:
Explanation
https://www.phdata.io/blog/how-to-optimize-snowpipe-data-load/#:~:text=Snowpipe%20is%20typically%20use

 

NEW QUESTION 112
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

• A. 0
• B. 1
• C. 2
• D. 3

Answer: B

Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

 

NEW QUESTION 113
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

• A. STATEMENT_TIMEOUT__IN__SECONDS
• B. MAX_CONCURRENCY__LEVEL
• C. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
• D. QUERY_TIMEOUT_IN_SECONDS

Answer: C

Explanation:
The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue
https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text=The%20parameter%20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets%20the,indefinitely%20in%20the%20waiting%20queue.

 

NEW QUESTION 114
Which data types does Snowflake support when querying semi-structured data? (Select TWO)

• A. XML
• B. VARIANT
• C. BLOB
• D. VARCHAR
• E. ARRAY

Answer: B,E

Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.
The maximum length of a VARIANT is 16 MB.
A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.

 

NEW QUESTION 115
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers

• A. Permanent Tables
• B. Provisional Tables
• C. Transient Tables
• D. Temporary Tables

Answer: C,D

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

 

NEW QUESTION 116
True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

• A. False
• B. True

Answer: B

 

NEW QUESTION 117
The PUT command: (Choose two.)

• A. Automatically compresses files using Gzip
• B. Automatically uses the last Stage created
• C. Automatically encrypts files
• D. Automatically creates a File Format object

Answer: A,C

 

NEW QUESTION 118
Which type of table corresponds to a single Snowflake session?

• A. Translent
• B. Permanent
• C. Provisional
• D. Temporary

Answer: D

Explanation:
Explanation
Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creatin

 

NEW QUESTION 119
Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:

• A. ACCOUNTADMIN
• B. SECURITYADMIN ACCOUNTADMIN, SYSADMIN
• C. SECURITYADMIN, ACCOUNTADMIN
• D. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN

Answer: B

 

NEW QUESTION 120
Data storage for individual tables can be monitored using which commands and/or object(s)?
Choose 2 answers

• A. SHOW STORAGE BY TABLE;
• B. SHOW TABLES;
• C. Information Schema -> TASLE_HISTORY
• D. Information Schema -> TABLE_STORAGE_METRICS

Answer: B,D

 

NEW QUESTION 121
Select the different types of Internal Stages: (Choose three.)

• A. Schema Stage
• B. Named Stage
• C. Table Stage
• D. User Stage

Answer: B,C,D

Explanation:
Reference:
Named-Stage

 

NEW QUESTION 122
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

• A. Data is live, ready-to-query, and can be personalized.
• B. Data is not available for copying or moving to an individual Snowflake account.
• C. Data is available without copying or moving.
• D. Data needs to be loaded into a cloud provider as a consumer account.
• E. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

Answer: A,C

 

NEW QUESTION 123
A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?

• A. Use dynamic data masking.
• B. Use data encryption.
• C. Use secure materialized views.
• D. Revoke all roles for functional managers and end users.

Answer: A

 

NEW QUESTION 124
Which type of table corresponds to a single Snowflake session?

• A. Translent
• B. Permanent
• C. Provisional
• D. Temporary

Answer: D

Explanation:
Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remainder%20of%20the%20session.

 

NEW QUESTION 125
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

• A. False
• B. True

Answer: B

Explanation:
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.

 

NEW QUESTION 126
What is the most granular object that the Time Travel retention period can be defined on?
Select one.

• A. Table
• B. Database
• C. Schema
• D. Account

Answer: D

 

NEW QUESTION 127
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

• A. False
• B. True

Answer: A

 

NEW QUESTION 128
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

• A. The validation_mode option is used when creating an Internal Stage
• B. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
• C. validation_mode=return_all_errors is a parameter of the copy command
• D. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

Answer: C,D

 

NEW QUESTION 129
Which of the following statements are true of Snowflake data loading? (Choose three.)

• A. It is recommended to use staging tables to manage MERGE statements
• B. It is recommended to do frequent, single row DMLs
• C. It is recommended to validate the data before loading into the Snowflake target table
• D. VARIANT "null" values are not the same as SQL NULL values

Answer: A,C,D

 

NEW QUESTION 130
Fail-safe is unavailable on which table types?

• A. Transient
• B. Permanent
• C. Provisional
• D. Temporary

Answer: A,D

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

 

NEW QUESTION 131
......

For more info read reference:

SnowPro Website

 

SnowPro-Core Premium Files Practice Valid Exam Dumps Question: https://pass4sure.passtorrent.com/SnowPro-Core-latest-torrent.html