[Nov 22, 2021] SnowPro-Core Dumps Full Questions - Exam Study Guide
SnowPro Core Free Certification Exam Material from ActualTestsQuiz with 164 Questions
For more info read reference:
Understanding functional and technical aspects of SnowPro Core Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE dumps:
- Snowflake Fast Clone
- Querying Semi-Structured Data
- A Quick Look at Zero-copy Cloning
- Using Persisted Query Results
- Continuous Data Protection
- Overview of Key Features
- Semi-Structured Data Types
- Snowflake Overview and Architecture
- Introduction to Semi-Structured Data
- Bringing Together Structured and Semi-Structured Data
NEW QUESTION 12
Which of the following terms best describes Snowflake's database architecture?
- A. Cloud-native shared memory
- B. Multi-cluster, shared data
- C. Columnar shared nothing
- D. Shared disk
Answer: D
NEW QUESTION 13
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
- A. Custom
- B. Economy
- C. Optimized
- D. Standard
Answer: B,D
NEW QUESTION 14
Which of the following objects is not covered by Time Travel?
- A. Stages
- B. Schemas
- C. Databases
- D. Tables
Answer: A
NEW QUESTION 15
Select the different types of Internal Stages: (Choose three.)
- A. Table Stage
- B. Named Stage
- C. Schema Stage
- D. User Stage
Answer: A,B,D
NEW QUESTION 16
What is the minimum Snowflake edition that provides data sharing?
- A. Premier
- B. Standard
- C. Business Critical Edition
- D. Enterprise
Answer: D
NEW QUESTION 17
What is the most granular object that the Time Travel retention can be defined on?
Select one.
- A. Database
- B. Schema
- C. Account
- D. Table
Answer: D
NEW QUESTION 18
True or False: The user has to specify which cluster a query will run on in a multi-cluster Warehouse.
- A. True
- B. False
Answer: A
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
NEW QUESTION 19
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
- A. True
- B. False
Answer: B
NEW QUESTION 20
True or False: You can resize a Virtual Warehouse while queries are running.
- A. True
- B. False
Answer: A
NEW QUESTION 21
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: B
NEW QUESTION 22
When loading data into Snowflake, the COPY command supports:
Choose 2 answers
- A. Column reordering
- B. Aggregates
- C. Joins
- D. Fitters
- E. Data type conversions
Answer: A,E
NEW QUESTION 23
When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers
- A. When users will be using compute at different times throughout a 24/7 period
- B. When managing a steady workload
- C. When you don't want to have to manually turn on the Warehouse each time a user needs it
- D. When the compute must be available with no delay or lag time
Answer: B,D
NEW QUESTION 24
What command is used to load files into an Internal Stage within Snowflake? Select one.
- A. COPY INTO
- B. TRANSFER
- C. INSERT
- D. PUT
Answer: D
NEW QUESTION 25
True or False: Data Providers can share data with only the Data Consumer.
- A. True
- B. False
Answer: A
NEW QUESTION 26
Which of the following DML commands isn't supported by Snowflake?
- A. MERGE
- B. UPDATE
- C. TRUNCATE TABLE
- D. UPSERT
Answer: D
NEW QUESTION 27
Which statements are true of micro-partitions?
Choose 2 answers
- A. They are stored compressed only if COMPRESS=TRUE on Table
- B. They are approximately 16MB in size
- C. They are Immutable
- D. They are only encrypted in the Enterprise edition and above
Answer: B,C
NEW QUESTION 28
When creating a user it is advisable sable to:
Choose 2 answers
- A. Set a default role for the user
- B. Set the user to be initially disabled
- C. Set the number of minutes to unlock to 15 minutes
- D. Set the users access to expire within a specified timeframe
- E. Force an immediate password change
Answer: A,E
NEW QUESTION 29
......
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.
Dumps Brief Outline Of The SnowPro-Core Exam: https://www.actualtestsquiz.com/SnowPro-Core-test-torrent.html
Use Real SnowPro-Core - 100% Cover Real Exam Questions: https://drive.google.com/open?id=1ZzpQkbDYpiZ9MXZXrnbWzZnkyGPinb2d
