Snowflake SnowPro Core Practice Test - Questions Answers, Page 42
List of questions
Related questions
Question 411

Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?
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.
Question 412

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?
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.
Question 413

What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
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
Question 414

What will prevent unauthorized access to a Snowflake account from an unknown source?
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.
Question 415

What is the purpose of a Query Profile?
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
Question 416

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?
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
Question 417

What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?
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.
Question 418

What metadata does Snowflake store for rows in micro-partitions? (Select TWO).
Explanation:
Snowflake stores metadata for rows in micro-partitions, including the range of values for each column and the number of distinct values1.
Question 419

What is a directory table in Snowflake?
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.
Question 420

Which Snowflake command can be used to unload the result of a query to a single file?
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:
Question