(PDF) SnowPro Core SnowPro-Core Exam and Certification Test Engine
Use SnowPro-Core Exam Dumps (2021 PDF Dumps) To Have Reliable SnowPro-Core Test Engine
Who should take the SnowPro Core Certification
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.
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. For this, you can use our SNOWFLAKE SNOWPRO CORE practice exam and SNOWFLAKE SNOWPRO CORE practice tests to ensure that you are ready for the exam.
NEW QUESTION 93
When can a Virtual Warehouse start running queries?
- A. 12am-5am
- B. When its provisioning is complete
- C. Only during administrator defined time slots
- D. After replication
Answer: C
NEW QUESTION 94
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
- A. True
- B. False
Answer: A
NEW QUESTION 95
What is the recommended Snowflake data type to store semi-structured data like JSON?
- A. RAW
- B. VARCHAR
- C. LOB
- D. VARIANT
Answer: D
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html
NEW QUESTION 96
The number of queries that a Warehouse can concurrently process is determined by:
Choose 2 answers
- A. The size of the data required for each query
- B. The tool that s executing the query
- C. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
- D. The complexity of each query
Answer: A,D
NEW QUESTION 97
Which of the following are common use cases for zero-copy cloning?
Choose 3 answers
- A. Data backups
- B. Quick provisioning of Dev and Test/QA environments
- C. Point in time snapshots
- D. Performance optimization
Answer: A,B,C
NEW QUESTION 98
The PUT command: (Choose two.)
- A. Automatically uses the last Stage created
- B. Automatically compresses files using Gzip
- C. Automatically encrypts files
- D. Automatically creates a File Format object
Answer: B,C
NEW QUESTION 99
Which of the following statements is true of Snowflake micro-partitioning?
- A. Micro-partitioning: requires a partitioning schema to be defined up front
- B. Micro-partitioning has been known to introduce data skew
- C. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
- D. Micro-partitioning can be disabled within a Snowflake account
Answer: C
NEW QUESTION 100
In which layer of its architecture does Snowflake store its metadata statistics?
- A. Storage Layer
- B. Compute Layer
- C. Database Layer
- D. Cloud Services Layer
Answer: D
Explanation:
Explanation/Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/
NEW QUESTION 101
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:
- A. Scaling max
- B. Scaling Up
- C. Scaling rhythmically
- D. Scaling out
Answer: B
NEW QUESTION 102
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)
- A. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period
- B. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period
- C. The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
- D. The "24 hour" timer on the precomputed results gets renewed every time the exact query is executed
Answer: B,C
NEW QUESTION 103
True or False: An active warehouse is required to run a COPY INTO statement.
- A. True
- B. False
Answer: A
NEW QUESTION 104
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers
- A. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
- B. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
- C. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
- D. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
Answer: B,C
NEW QUESTION 105
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. True
- B. False
Answer: A
NEW QUESTION 106
Which of the following objects can be cloned? (Choose four.)
- A. Databases
- B. Users
- C. Schemas
- D. Shares
- E. Tables
- F. Named File Formats
Answer: A,B,C,E
NEW QUESTION 107
True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.
- A. True
- B. False
Answer: B
NEW QUESTION 108
True or False: You can query the files in an External Stage directly without having to load the data into a table.
- A. True
- B. False
Answer: A
NEW QUESTION 109
How would you determine the size of the virtual warehouse used for a task?
- A. 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
- 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. 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
- D. 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
Answer: B
NEW QUESTION 110
True or False: You can resize a Virtual Warehouse while queries are running.
- A. True
- B. False
Answer: A
NEW QUESTION 111
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
- A. Enterprise
- B. Standard
- C. Premier
- D. Business Critical Edition
Answer: D
NEW QUESTION 112
......
Understanding functional and technical aspects of SnowPro Core Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE dumps:
- Continuous Data Protection
- Snowflake Overview and Architecture
- Using Persisted Query Results
- Introduction to Semi-Structured Data
- Querying Semi-Structured Data
- A Quick Look at Zero-copy Cloning
- Snowflake Fast Clone
- Bringing Together Structured and Semi-Structured Data
- Semi-Structured Data Types
- Overview of Key Features
SnowPro-Core Dumps Full Questions with Free PDF Questions to Pass: https://www.exams4collection.com/SnowPro-Core-latest-braindumps.html
SnowPro-Core PDF Recently Updated Questions Dumps to Improve Exam Score: https://drive.google.com/open?id=10M8Z7EbKVqq69mndY2nF5v2rTUqN7iDu
