Snowflake SnowPro Core SnowPro Core Certification Exam Online Training
Snowflake SnowPro Core Online Training
The questions for SnowPro Core were last updated at Nov 19,2024.
- Exam Code: SnowPro Core
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Nov 19,2024
True or False: All Snowflake table types include fail-safe storage.
- A . True
- B . False
True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.
- A . True
- B . False
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
- A . True
- B . False
What transformations are supported in a CREATE PIPE … AS COPY … FROM (….) statement? (Select TWO.)
- A . Data can be filtered by an optional where clause
- B . Incoming data can be joined with other tables
- C . Columns can be reordered
- D . Columns can be omitted
- E . Row level access can be defined
What is the minimum Snowflake edition that provides data sharing?
- A . Standard
- B . Premier
- C . Enterprise
- D . Business Critical Edition
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)
- A . JDBC
- B . SnowSQL
- C . Snowflake Web Interface (UI)
- D . ODBC
- E . Python
How long is Snowpipe data load history retained?
- A . As configured in the create pipe settings
- B . Until the pipe is dropped
- C . 64 days
- D . 14 days
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 . True
- B . False
What happens when a Data Provider revokes privileges to a Share on an object in their source database?
- A . The object immediately becomes unavailable for all Data Consumers
- B . Any additional data arriving after this point in time will not be visible to Data Consumers
- C . The Data Consumers stop seeing data updates and become responsible for storage charges for the object
- D . A static copy of the object at the time the privilege was revoked is created In the Data Consumers’ accounts
Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answers
- A . SnowSQL
- B . ODBC
- C . R
- D . HIVE