Best Quality SnowPro-Core Exam Questions Snowflake Test To Gain Brilliante Result!
Preparations of SnowPro-Core Exam 2021 SnowPro Core Unlimited 164 Questions
NEW QUESTION 62
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
- A. Tables
- B. Databases
- C. Internal Stages
- D. Users
Answer: A,B,D
NEW QUESTION 63
In which layer of its architecture does Snowflake store its metadata statistics?
Select one.
- A. Cloud Service Layer
- B. Database Layer
- C. Storage Layer
- D. Compute Layer
Answer: A
NEW QUESTION 64
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 65
True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.
- A. True
- B. False
Answer: A
NEW QUESTION 66
When should you consider disabling auto-suspend for a Virtual Warehouse? (Choose two.)
- A. When you do not want to have to manually turn on the Warehouse each time a user needs it
- B. When managing a steady workload
- C. When the compute must be available with no delay or lag time
- D. When users will be using compute at different times throughout a 24/7 period
Answer: B,C
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
NEW QUESTION 67
What is the minimum Snowflake edition that provides data sharing?
- A. Enterprise
- B. Standard
- C. Business Critical Edition
- D. Premier
Answer: A
NEW QUESTION 68
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
- A. A Warehouse can be resized while running
- B. Customers can change the size of the Warehouse after creation
- C. A Warehouse can be configured to suspend after a period of inactivity
- D. A Warehouse can be configured to auto-resume when new queries are submitted
Answer: A,C
NEW QUESTION 69
In which layer of its architecture does Snowflake store its metadata statistics?
- A. Database Layer
- B. Storage Layer
- C. Compute Layer
- D. Cloud Services Layer
Answer: D
Explanation:
Explanation/Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/
NEW QUESTION 70
Fail-safe is unavailable on which table types?
- A. Translent
- B. Provisional
- C. Temporary
- D. Permanent
Answer: A,C
NEW QUESTION 71
True or False: An active warehouse is required to run a COPY INTO statement.
- A. True
- B. False
Answer: A
NEW QUESTION 72
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
- A. False
- B. True
Answer: A
NEW QUESTION 73
Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
- A. Storage expands without the requirement to add more compute
- B. Compute can be scaled up or down without the requirement to add more storage
- C. Multiple compute clusters can access stored data without contention
- D. Growth of storage and compute are tightly coupled together
Answer: D
Explanation:
Explanation/Reference: https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehouse- doesnt-separate-storage-and-compute-65d2dffd450f
NEW QUESTION 74
A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?
- A. SYSADMIN
- B. The tables are now orphaned
- C. The assumed role that dropped the role
- D. The user that deleted the role
Answer: C
NEW QUESTION 75
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers
- A. Temporary Tables
- B. Translent Tables
- C. Provisional Tables
- D. Permanent Tables
Answer: A,B
NEW QUESTION 76
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: A
NEW QUESTION 77
Which of the following statements are true about Schemas in Snowflake? (Choose two.)
- A. Each Schema is contained within a Warehouse
- B. A Schema may contain one or more Databases
- C. A Schema is a logical grouping of Database Objects
- D. A Database may contain one or more Schemas
Answer: C,D
NEW QUESTION 78
Which of the following are common use cases for zero-copy cloning?
Choose 3 answers
- A. Performance optimization
- B. Point in time snapshots
- C. Data backups
- D. Quick provisioning of Dev and Test/QA environments
Answer: B,C,D
NEW QUESTION 79
......
Focus on SnowPro-Core All-in-One Exam Guide For Quick Preparation: https://www.braindumpsit.com/SnowPro-Core_real-exam.html
SnowPro-Core All-in-One Exam Guide For Quick Preparation: https://drive.google.com/open?id=1ZPquvIh4bjqBlNQaWMvDtnfQVAjI8_lW