The Secret Of Snowflake SnowPro-Core Pdf Exam

NEW QUESTION 1

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

• A. The explain plan output is available graphically.
• B. An explain plan can be used to conduct performance analysis without executing a query.
• C. An explain plan will handle queries with temporary tables and the query profiler will not.
• D. An explain plan's output will display automatic data skew optimization information.

Answer: B

NEW QUESTION 2

True or False: Pipes can be suspended and resumed.

• A. True
• B. False

Answer: A

Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:

NEW QUESTION 3

A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

• A. 1 second
• B. 60 seconds
• C. 5 minutes
• D. 60 minutes

Answer: B

NEW QUESTION 4

What is a key feature of Snowflake architecture?

• A. Zero-copy cloning creates a mirror copy of a database that updates with the original
• B. Software updates are automatically applied on a quarterly basis
• C. Snowflake eliminates resource contention with its virtual warehouse implementation
• D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters
• E. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

Answer: D

NEW QUESTION 5

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: C

Explanation:
https://www.snowflake.com/product/architecture/
Built from the ground up for the cloud, Snowflake’s unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today’s organizations require.

NEW QUESTION 6

True or False: Snowpipe via RFST API can only reference External Stages as source.

• A. True
• B. False

Answer: B

Explanation:
Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

NEW QUESTION 7

What tasks can be completed using the copy command? (Select TWO)

• A. Columns can be aggregated
• B. Columns can be joined with an existing table
• C. Columns can be reordered
• D. Columns can be omitted
• E. Data can be loaded without the need to spin up a virtual warehouse

Answer: CD

NEW QUESTION 8

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

• A. 60 minutes
• B. 24 hours
• C. 14 days
• D. 30 days
• E. 1 year

Answer: C

Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html

NEW QUESTION 9

True or false: it is best practice to define a clustering key on every table.

• A. True
• B. False

Answer: B

Explanation:
Reference: https://dwgeek.com/how-to-create-snowflake-clustered-tables-examples.html/

NEW QUESTION 10

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

• A. Materialized views
• B. Sequences
• C. Procedures
• D. Tables
• E. Secure User Defined Functions (UDFs)

Answer: DE

Explanation:
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
Tables
External tables
Secure views
Secure materialized views
Secure UDFs
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

NEW QUESTION 11

Which Snowflake feature is used for both querying and restoring data?

• A. Cluster keys
• B. Time Travel
• C. Fail-safe
• D. Cloning

Answer: B

Explanation:
https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%

NEW QUESTION 12

Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:

• A. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
• B. SECURITYADMIN ACCOUNTADMIN, SYSADMIN
• C. SECURITYADMIN, ACCOUNTADMIN
• D. ACCOUNTADMIN

Answer: D

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html

NEW QUESTION 13

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

• A. Data is hashed by the cluster key to facilitate fast searches for common data values
• B. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
• C. Smaller micro-partitions are created for common data values to allow for more parallelism
• D. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Answer: D

NEW QUESTION 14

What privileges are required to create a task?

• A. The global privilege create task is required to create a new task.
• B. Tasks are created at the Application level and can only be created by the Account Admin role.
• C. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
• D. The role must have access to the target schema and the create task privilege on the schema itself.

Answer: D

Explanation:
All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema.
https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks

NEW QUESTION 15

Which of the following describes a Snowflake stored procedure?

• A. They can be created as secure and hide the underlying metadata from the user.
• B. They can only access tables from a single database.
• C. They can contain only a single SQL statement.
• D. They can be created to run with a caller's rights or an owner's rights.

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.html

NEW QUESTION 16

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. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
• D. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
• E. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
• F. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Answer: DEF

NEW QUESTION 17

What is the minimum Snowflake edition that has column-level security enabled?

• A. Standard
• B. Enterprise
• C. Business Critical
• D. Virtual Private Snowflake

Answer: B

NEW QUESTION 18

Which of the following can be executed/called with Snowpipe?

• A. A User Defined Function (UDF)
• B. A stored procedure
• C. A single copy_into statement
• D. A single insert__into statement

Answer: C

NEW QUESTION 19

Which stage type can be altered and dropped?

• A. Database stage
• B. External stage
• C. Table stage
• D. User stage

Answer: C

Explanation:
https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages

NEW QUESTION 20
......