[Jan 28, 2022] Free SnowPro Core SnowPro-Core Exam Question
SnowPro-Core dumps & SnowPro Core sure practice dumps
How to Prepare For SnowPro Core Certification
Preparation Guide for SnowPro Core Certification
Introduction for SnowPro Core Certification
SnowPro Core Certified individuals have demonstrated the knowledge necessary to apply specific core expertise in the marketplace with customers implementing and migrating to Snowflake. A SnowPro Core Certified 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.
Our SNOWFLAKE SNOWPRO CORE practice exams and SNOWFLAKE SNOWPRO CORE practice exams are there to help you in memorizing and understanding all the topics. Use them to prepare for all of the exam requirements.
Snowflake is a cloud data platform built from the ground up for the cloud. Snowflake is built on a patented, multi-cluster, shared data architecture created for the cloud to revolutionize data warehousing, data lakes, data analytics and a host of other use cases.
Snowflake is a single platform comprised of storage, compute, and services layers that are logically integrated but scale infinitely and independent from one another.
Snowflake is a SaaS solution and is maintained by Snowflake and not the customer. Snowflake manages the services, compute, and storage layers. Data is only accessible via SQL in Snowflake. Snowflake can be deployed within AWS, Azure or GCP although not in customer controlled accounts.
For more info read reference:
NEW QUESTION 45
What is the lowest Snowflake edition that offers Time Travel up to 90 days.
- A. Enterprise Edition
- B. standard Edition
- C. Premier Edition
- D. Business Critical Edition
Answer: A
NEW QUESTION 46
Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously?
Choose 3 answers
- A. COPY
- B. MIN(< < column value>>)
- C. SUM(<< column value >>)
- D. UPDATE
Answer: A,C,D
NEW QUESTION 47
If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:
- A. The last query using the warehouse completes.
- B. All Snowflake sessions using the warehouse are terminated.
- C. The Warehouse is inactive for a specified period of time.
- D. There are no users loaned into Snowflake.
Answer: C
NEW QUESTION 48
How a Snowpipe charges calculated?
- A. Per-second/per Warehouse size
- B. Per-second/per-core granularity
- C. Number of Pipes in account
- D. Total storage bucket size
Answer: B
NEW QUESTION 49
What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.
- A. Physical security
- B. Maintaining metadata and statists
- C. Patching software
- D. Installing and configuring hardware
Answer: B,C,D
NEW QUESTION 50
The Query History in the Snowflake Web Interface (UI) is kept for approximately:
- A. 14 days
- B. 30 days
- C. 24 hours
- D. 60 minutes
- E. 1 year
Answer: E
NEW QUESTION 51
Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:
- A. ACCOUNTADMIN
- B. SECURITYADMIN, ACCOUNTADMIN
- C. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
- D. SECURITYADMIN ACCOUNTADMIN, SYSADMIN
Answer: D
NEW QUESTION 52
What is the maximum compressed row size in Snowflake?
- A. 16MB
- B. 8KB
- C. 4000GB
- D. 50MB
Answer: A
NEW QUESTION 53
What privileges are required to create a task?
- A. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
- B. The global privilege create task is required to create a new task.
- C. Tasks are created at the Application level and can only be created by the Account Admin role.
- D. The role must have access to the target schema and the create task privilege on the schema itself.
Answer: B
NEW QUESTION 54
True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.
- A. True
- B. False
Answer: A
NEW QUESTION 55
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
NEW QUESTION 56
Which of the following objects is not covered by Time Travel?
- A. Tables
- B. Databases
- C. Stages
- D. Schemas
Answer: C
NEW QUESTION 57
Fail-safe is unavailable on which table types?
- A. Permanent
- B. Provisional
- C. Translent
- D. Temporary
Answer: C,D
NEW QUESTION 58
What is the minimum Snowflake edition that provides data sharing?
- A. Standard
- B. Enterprise
- C. Premier
- D. Business Critical Edition
Answer: A
NEW QUESTION 59
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 60
True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
- A. False
- B. True
Answer: A
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
NEW QUESTION 61
Which of the following terms best describes Snowflake's database architecture?
- A. Columnar shared nothing
- B. Shared disk
- C. Multi-cluster, shared data
- D. Cloud-native shared memory
Answer: B
NEW QUESTION 62
In which layer of its architecture does Snowflake store its metadata statistics?
Select one.
- A. Database Layer
- B. Cloud Service Layer
- C. Storage Layer
- D. Compute Layer
Answer: B
NEW QUESTION 63
True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).
- A. False
- B. True
Answer: A
NEW QUESTION 64
Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?
Select one.
- A. Database -> Table -> Schema -> Account
- B. Account -> Database -> Schema -> Table
- C. Account -> Schema -> Database -> Table
- D. Database -> Schema -> Table -> Account
Answer: B
NEW QUESTION 65
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
- A. Concurrency
- B. Performance
Answer: A
NEW QUESTION 66
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
- A. To accommodate more users
- B. To accommodate fluctuations in workload
- C. To accommodate a more complex workload
- D. To accommodate more queries
Answer: D
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
NEW QUESTION 67
Which of the following statements is true of zero-copy cloning?
- A. At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.
- B. All zero-copy clone objects inherit the privileges of their original objects
- C. Zero-copy clones objects inherit
- D. Zero-copy coning is licensed as an additional Snowflake feature
Answer: A
NEW QUESTION 68
......
Snowflake SnowPro-Core Actual Questions and Braindumps: https://passguide.testkingpass.com/SnowPro-Core-testking-dumps.html