Aug-2022 Snowflake SnowPro-Core Actual Questions and 100% Cover Real Exam Questions
SnowPro-Core Free Exam Questions and Answers PDF Updated on Aug-2022
What is the duration, language, and format of SnowPro Core Certification
- Passing grade: 70%
- Language of Exam: English, Japanese, Korean
- Type of Questions: Multiple choice (MCQs), multiple answers
How much SnowPro Core CertificationCost
The cost of the SnowPro Core Certification is $175. For more information related to exam price, please visit the official website as the cost of exams may be subjected to vary county-wise.
NEW QUESTION 108
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.
- A. True
- B. False
Answer: A
NEW QUESTION 109
True or False: You can define multiple columns within a clustering key on a table.
- A. True
- B. False
Answer: A
NEW QUESTION 110
Which of the following statements is true of data loading?
Select one.
- A. Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
- B. Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file
- C. The "deal file size for loading is 16MB to match micro-partition size
Answer: B
NEW QUESTION 111
Which of the following items does the Cloud services Layer manage?
Choose 4 answers
- A. user authentication
- B. Metadata
- C. Data security
- D. external blob storage
- E. Query compilation and optimization
Answer: A,B,C,E
NEW QUESTION 112
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.
- A. False
- B. True
Answer: A
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/jdbc.html
Snowflake provides a JDBC type 4 driver that supports core JDBC functionality. The JDBC driver must be installed in a 64-bit environment and requires Java 1.8 (or higher). The driver can be used with most client tools/applications that support JDBC for connecting to a database server.
NEW QUESTION 113
Which of the following is true of Snowpipe via REST API?
Choose 2 answers
- A. you can only use it on internal Stages
- B. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
- C. All COPY INTO options are available fluting pipe creation
- D. Snowpipe keeps track of which files it has loaded
Answer: B,D
Explanation:
Explanation
https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#usage-notes
NEW QUESTION 114
When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
Select one.
- A. Performance
- B. Concurrency
Answer: A
NEW QUESTION 115
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A. SQL commands
- B. All of the above
- C. The Snowflake Web Interface (UI)
- D. Data integration tools
Answer: B
NEW QUESTION 116
True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.
- A. False
- B. True
Answer: A
NEW QUESTION 117
What are the three layers that make up Snowflake's architecture?
Choose 3 answer
- A. Storage
- B. Tri-Secret Secure
- C. Cloud Services
- D. Compute
Answer: A,C,D
NEW QUESTION 118
What SQL command would be used to view all roles that were granted to user.1?
- A. describe user USER1;
- B. show grants on user USER1;
- C. show grants of user USER1;
- D. show grants to user USER1;
Answer: D
NEW QUESTION 119
True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.
- A. False
- B. True
Answer: A
NEW QUESTION 120
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)
- A. SnowSQL
- B. ODBC
- C. Python
- D. JDBC
- E. Snowflake Web Interface (UI)
Answer: A,B,C,D,E
Explanation:
D18912E1457D5D1DDCBD40AB3BF70D5D
NEW QUESTION 121
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A. SQL commands
- B. The Snowflake Web Interface (UI)
- C. Data integration tools
- D. All of the above
Answer: A
NEW QUESTION 122
True or False: The COPY command must specify a File Format in order to execute.
- A. True
- B. False
Answer: A
NEW QUESTION 123
Which command is used to unload data from a Snowflake table into a file in a stage?
- A. COPY INTO
- B. WRITE
- C. EXTRACT INTO
- D. GET
Answer: A
Explanation:
https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%20the%20COPY%20INTO%20command%20to%20unload%20all%20the,more%20files%20in%20your%20stage.
NEW QUESTION 124
True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.
- A. False
- B. True
Answer: A
NEW QUESTION 125
Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),
- A. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
- B. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
- C. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
- D. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region
- E. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
- F. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
Answer: C,D,F
NEW QUESTION 126
When can a Virtual Warehouse start running queries?
- A. Only during administrator defined time slots
- B. When its provisioning is complete
- C. 12am-5am
- D. After replication
Answer: A
NEW QUESTION 127
What is the most granular object that the Time Travel retention period can be defined on?
Select one.
- A. Table
- B. Schema
- C. Database
- D. Account
Answer: D
NEW QUESTION 128
True or False: Snowpipe via RFST API can only reference External Stages as source.
- A. True
- B. False
Answer: A
NEW QUESTION 129
......
Snowflake SnowPro-Core Real 2022 Braindumps Mock Exam Dumps: https://examcollection.dumpsvalid.com/SnowPro-Core-brain-dumps.html