Snowflake SnowPro Core Certification Exam Questions

  Edina  03-03-2021

To pass the SnowPro Core Certification, you have to prepare according to the latest and actual syllabus of the SnowPro Core Certification Exam. PassQuestion provides trustworthy Snowflake SnowPro Core Certification Exam Questions to prepare for the SnowPro Core test.These questions and answers will help you in understanding your SnowPro Core exam in the best possible way. You can score the maximum marks in the Snowflake SnowPro Core test with the help of these expertly designed and verified Snowflake SnowPro Core Certification Exam Questions.

Snowflake SnowPro Core Certification Exam Introduction

The Snowflake SnowPro Core Certification demonstrates an individual's knowledge to apply specific core expertise implementing and migrating to Snowflake. A Snowflake SnowPro Core Certificate individual has a thorough understanding of Snowflake as a cloud data warehouse and has the knowledge necessary to design, develop and manage secure, scalable Snowflake solutions to drive business objectives.

About the SnowPro Certification Exam

This exam's objective is to measure an individual's knowledge and ability to use Snowflake based data warehouse solution. To earn this certification, you must pass the SnowPro Core Certification exam. The exam format consists of multiple select, multiple choice, True/False, fill-in the blank and terminology matching questions. The exam has no mandatory prerequisites and is administered by our third-party proctor.

Length: 2 hours
Format: Multiple choice, Multiple Select, True/False
Passing Score: 80% and above
Registration fee: $175 USD for online, requires external web camera $175 USD for onsite, available at Kryterion Testing Centers
Language: Currently only available in English

Snowpro Core Subject Area Breakdown

Snowflake Overview and Architecture: 28%
Snowflake Virtual Warehouses: 18%
Snowflake Storage and Protection: 15%
Data Movement (Loading and Unloading): 14%
Snowflake Account and Security: 12%
Snowflake Performance and Tuning: 9%
Semi-Structured: 4%

View Online Snowflake SnowPro Core Certification Free Questions

1.True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
A. True
B. False
Answer: A

2.True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
A. True
B. False
Answer: B

3.Data storage for individual tables can be monitored using which commands and/or object(s)?
Choose 2 answers
A. SHOW TABLES;
B. SHOW STORAGE BY TABLE;
C. Information Schema -> TABLE_STORAGE_METRICS
D. Information Schema -> TASLE_HISTORY
Answer: A,D

4.When creating a user it is advisable sable to: Choose 2 answers
A. Set the user to be initially disabled
B. Force an immediate password change
C. Set a default role for the user
D. Set the number of minutes to unlock to 15 minutes
E. Set the users access to expire within a specified timeframe
Answer: B,C

5.True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.
A. True
B. false:
Answer: B

6.What is the recommended method for loading data into Snowflake?
A. Load row by row
B. Load data in batch
C. Load data by writing it In the Snowflake Web Interface (UI)
D. Load data via frequent, angle row DML's
Answer: B

Leave And reply:

  TOP 50 Exam Questions
Exam