Snowflake SnowPro-Core Exam Practice Test Instant Access

Question 1

In Snowflake, the use of federated authentication enables which Single Sign-On (SSO) workflow activities? (Select TWO).

AAuthorizing users

BInitiating user sessions

CLogging into Snowflake

DLogging out of Snowflake

EPerforming role authentication

Answer : B, C

Federated authentication in Snowflake allows users to use their organizational credentials to log in to Snowflake, leveraging Single Sign-On (SSO). The key activities enabled by this setup include:

B . Initiating user sessions: Federated authentication streamlines the process of starting a user session in Snowflake by using the existing authentication mechanisms of an organization.

C . Logging into Snowflake: It simplifies the login process, allowing users to authenticate with their organization's identity provider instead of managing separate credentials for Snowflake.

Snowflake Documentation: Configuring Federated Authentication

Question 2

Which DDL/DML operation is allowed on an inbound data share?

AALTER TA3LE

BINSERT INTO

CMERGE

DSELECT

Answer : D

In Snowflake, an inbound data share refers to the data shared with an account by another account. The only DDL/DML operation allowed on an inbound data share is SELECT. This restriction ensures that the shared data remains read-only for the consuming account, maintaining the integrity and ownership of the data by the sharing account.

Snowflake Documentation: Using Data Shares

Question 3

What is one of the characteristics of data shares?

AData shares support full DML operations.

BData shares work by copying data to consumer accounts.

CData shares utilize secure views for sharing view objects.

DData shares are cloud agnostic and can cross regions by default.

Answer : C

Data sharing in Snowflake allows for live, read-only access to data across different Snowflake accounts without the need to copy or transfer the data. One of the characteristics of data shares is the ability to use secure views. Secure views are used within data shares to restrict the access of shared data, ensuring that consumers can only see the data that the provider intends to share, thereby preserving privacy and security.

Snowflake Documentation: Understanding Secure Views in Data Sharing

Question 4

What compute resource is used when loading data using Snowpipe?

ASnowpipe uses virtual warehouses provided by the user.

BSnowpipe uses an Apache Kafka server for its compute resources.

CSnowpipe uses compute resources provided by Snowflake.

DSnowpipe uses cloud platform compute resources provided by the user.

Answer : C

Snowpipe is Snowflake's continuous data ingestion service that allows for loading data as soon as it's available in a cloud storage stage. Snowpipe uses compute resources managed by Snowflake, separate from the virtual warehouses that users create for querying data. This means that Snowpipe operations do not consume the computational credits of user-created virtual warehouses, offering an efficient and cost-effective way to continuously load data into Snowflake.

Snowflake Documentation: Understanding Snowpipe

Question 5

How does the Snowflake search optimization service improve query performance?

AIt improves the performance of range searches.

BIt defines different clustering keys on the same source table.

CIt improves the performance of all queries running against a given table.

DIt improves the performance of equality searches.

DIt improves the performance of equality searches: The service optimizes the performance of queries that use equality search conditions (e.g., WHERE column = value). It creates and maintains a search index on the table's columns, which significantly speeds up the retrieval of rows based on those equality search conditions.
This optimization is particularly beneficial for large tables where traditional scans might be inefficient for equality searches. By using the Search Optimization Service, Snowflake can leverage the search indexes to quickly locate the rows that match the search criteria without scanning the entire table.

Answer : D, D

The Snowflake Search Optimization Service is designed to enhance the performance of specific types of queries on large tables. The correct answer is:

Snowflake Documentation: Search Optimization Service at Snowflake Documentation

Question 6

Which Snowflake tool is recommended for data batch processing?

ASnowCD

BSnowSQL

CSnowsight

DThe Snowflake API

Answer : B

For data batch processing in Snowflake, the recommended tool is:

B . SnowSQL: SnowSQL is the command-line client for Snowflake. It allows for executing SQL queries, scripts, and managing database objects. It's particularly suitable for batch processing tasks due to its ability to run SQL scripts that can execute multiple commands or queries in sequence, making it ideal for automated or scheduled tasks that require bulk data operations.

SnowSQL provides a flexible and powerful way to interact with Snowflake, supporting operations such as loading and unloading data, executing complex queries, and managing Snowflake objects from the command line or through scripts.

Snowflake Documentation: SnowSQL (CLI Client) at Snowflake Documentation

Question 7

A JSON object is loaded into a column named data using a Snowflake variant datatype. The root node of the object is BIKE. The child attribute for this root node is BIKEID.

Which statement will allow the user to access BIKEID?

Aselect data:BIKEID

Bselect data.BIKE.BIKEID

Cselect data:BIKE.BIKEID

Dselect data:BIKE:BIKEID

Answer : C

In Snowflake, when accessing elements within a JSON object stored in a variant column, the correct syntax involves using a colon (:) to navigate the JSON structure. The BIKEID attribute, which is a child of the BIKE root node in the JSON object, is accessed using data:BIKE.BIKEID. This syntax correctly references the path through the JSON object, utilizing the colon for JSON field access and dot notation to traverse the hierarchy within the variant structure. Reference: Snowflake documentation on accessing semi-structured data, which outlines how to use the colon and dot notations for navigating JSON structures stored in variant columns.

Snowflake SnowPro Core Exam Practice Test