ExamGecko
Home / Snowflake / SnowPro Core
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 42

Question list
Search

Question 411

Report
Export
Collapse

Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?

OAuth
OAuth
Network policies
Network policies
Single Sign-On (SSO)
Single Sign-On (SSO)
Multi-Factor Authentication (MFA)
Multi-Factor Authentication (MFA)
Suggested answer: D

Explanation:

Multi-Factor Authentication (MFA) provides increased login security for users connecting to Snowflake. Snowflake's MFA is powered by Duo Security service, which adds an additional layer of security during the login process.

asked 23/09/2024
Claudious Utete
40 questions

Question 412

Report
Export
Collapse

A Snowflake account has activated federated authentication.

What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?

The user will be unable to enter a password.
The user will be unable to enter a password.
The user will encounter an error, and will not be able to log in.
The user will encounter an error, and will not be able to log in.
The user will be able to log into Snowflake successfully.
The user will be able to log into Snowflake successfully.
After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.
After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.
Suggested answer: A

Explanation:

When federated authentication is activated in Snowflake, users authenticate via an external identity provider (IdP) rather than using Snowflake-managed credentials. Therefore, a user with a password defined by Snowflake will be unable to enter a password and must use their IdP credentials to log in.


asked 23/09/2024
Amir Trujillo
38 questions

Question 413

Report
Export
Collapse

What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

FLATTEN
FLATTEN
GET_PATH
GET_PATH
CHECK_JSON
CHECK_JSON
PARSE JSON
PARSE JSON
Suggested answer: A

Explanation:

The FLATTEN function can be used with the recursive argument to return a list of distinct key names in all nested elements within an object.This function is particularly useful for working with semi-structured data in Snowflake

asked 23/09/2024
Arnold Bronson TCHOFFO
44 questions

Question 414

Report
Export
Collapse

What will prevent unauthorized access to a Snowflake account from an unknown source?

Network policy
Network policy
End-to-end encryption
End-to-end encryption
Multi-Factor Authentication (MFA)
Multi-Factor Authentication (MFA)
Role-Based Access Control (RBAC)
Role-Based Access Control (RBAC)
Suggested answer: A

Explanation:

A network policy in Snowflake is used to restrict access to the Snowflake account from unauthorized or unknown sources.It allows administrators to specify allowed IP address ranges, thus preventing access from any IP addresses not listed in the policy1.

asked 23/09/2024
ROBERTO INFANTAS
34 questions

Question 415

Report
Export
Collapse

What is the purpose of a Query Profile?

To profile how many times a particular query was executed and analyze its u^age statistics over time.
To profile how many times a particular query was executed and analyze its u^age statistics over time.
To profile a particular query to understand the mechanics of the query, its behavior, and performance.
To profile a particular query to understand the mechanics of the query, its behavior, and performance.
To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.
To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.
To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.
To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.
Suggested answer: B

Explanation:

The purpose of a Query Profile is to provide a detailed analysis of a particular query's execution plan, including the mechanics, behavior, and performance.It helps in identifying potential performance bottlenecks and areas for optimization

asked 23/09/2024
Karabo Mabeba
29 questions

Question 416

Report
Export
Collapse

When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

File URL
File URL
Scoped URL
Scoped URL
Relative URL
Relative URL
Pre-Signed URL
Pre-Signed URL
Suggested answer: B

Explanation:

A Scoped URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens.It provides a secure way to share access to files stored in Snowflake

asked 23/09/2024
francesca parisi
25 questions

Question 417

Report
Export
Collapse

What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?

Standard Edition
Standard Edition
Enterprise Edition
Enterprise Edition
Business Critical Edition
Business Critical Edition
Virtual Private Snowflake Edition
Virtual Private Snowflake Edition
Suggested answer: C

Explanation:

The minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data is the Business Critical Edition.This edition offers enhanced security features necessary for compliance with regulations such as HIPAA and HITRUST CSF4.

asked 23/09/2024
J.L.M. van Loo
48 questions

Question 418

Report
Export
Collapse

What metadata does Snowflake store for rows in micro-partitions? (Select TWO).

Range of values
Range of values
Distinct values
Distinct values
Index values
Index values
Sorted values
Sorted values
Null values
Null values
Suggested answer: A, B

Explanation:

Snowflake stores metadata for rows in micro-partitions, including the range of values for each column and the number of distinct values1.

asked 23/09/2024
Kostiantyn Lazurenko
44 questions

Question 419

Report
Export
Collapse

What is a directory table in Snowflake?

A separate database object that is used to store file-level metadata
A separate database object that is used to store file-level metadata
An object layered on a stage that is used to store file-level metadata
An object layered on a stage that is used to store file-level metadata
A database object with grantable privileges for unstructured data tasks
A database object with grantable privileges for unstructured data tasks
A Snowflake table specifically designed for storing unstructured files
A Snowflake table specifically designed for storing unstructured files
Suggested answer: B

Explanation:

A directory table in Snowflake is an object layered on a stage that is used to store file-level metadata.It is not a separate database object but is conceptually similar to an external table because it stores metadata about the data files in the stage5.

asked 23/09/2024
Miguel Triebel
36 questions

Question 420

Report
Export
Collapse

Which Snowflake command can be used to unload the result of a query to a single file?

Use COPY INTO <external stage> followed by a GET command to download the file.
Use COPY INTO <external stage> followed by a GET command to download the file.
Use COPY INTO <internal stage> followed by a put command to download the file.
Use COPY INTO <internal stage> followed by a put command to download the file.
Use COPY INTO <internal stage> with SINGLE = TRUE followed by a GET command to download the file.
Use COPY INTO <internal stage> with SINGLE = TRUE followed by a GET command to download the file.
Use COPY INTO <external stage> with SINGLE = TRUE followed by a PUT command to download the file.
Use COPY INTO <external stage> with SINGLE = TRUE followed by a PUT command to download the file.
Suggested answer: C

Explanation:

The Snowflake command to unload the result of a query to a single file isCOPY INTO <internal stage> with SINGLE = TRUEfollowed by aGETcommand to download the file.This command unloads the query result into a single file in the specified internal stage

Explanation:

asked 23/09/2024
Kevin Intriago
36 questions
Total 627 questions
Go to page: of 63