ExamGecko
Search Search Login
Home Home / Snowflake / SnowPro Core

Snowflake SnowPro Core Practice Test - Questions Answers, Page 42

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
Which Snowflake technique can be used to improve the performance of a query?
What is a key feature of Snowflake architecture?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
User-level network policies can be created by which of the following roles? (Select TWO).
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Will data cached in a warehouse be lost when the warehouse is resized?

Question 411

Report
Export
Collapse

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

A.
OAuth
A.
OAuth
Answers
B.
Network policies
B.
Network policies
Answers
C.
Single Sign-On (SSO)
C.
Single Sign-On (SSO)
Answers
D.
Multi-Factor Authentication (MFA)
D.
Multi-Factor Authentication (MFA)
Answers
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.

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?

A.
The user will be unable to enter a password.
A.
The user will be unable to enter a password.
Answers
B.
The user will encounter an error, and will not be able to log in.
B.
The user will encounter an error, and will not be able to log in.
Answers
C.
The user will be able to log into Snowflake successfully.
C.
The user will be able to log into Snowflake successfully.
Answers
D.
After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.
D.
After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.
Answers
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.


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?

A.
FLATTEN
A.
FLATTEN
Answers
B.
GET_PATH
B.
GET_PATH
Answers
C.
CHECK_JSON
C.
CHECK_JSON
Answers
D.
PARSE JSON
D.
PARSE JSON
Answers
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

Question 414

Report
Export
Collapse

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

A.
Network policy
A.
Network policy
Answers
B.
End-to-end encryption
B.
End-to-end encryption
Answers
C.
Multi-Factor Authentication (MFA)
C.
Multi-Factor Authentication (MFA)
Answers
D.
Role-Based Access Control (RBAC)
D.
Role-Based Access Control (RBAC)
Answers
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.

Question 415

Report
Export
Collapse

What is the purpose of a Query Profile?

A.
To profile how many times a particular query was executed and analyze its u^age statistics over time.
A.
To profile how many times a particular query was executed and analyze its u^age statistics over time.
Answers
B.
To profile a particular query to understand the mechanics of the query, its behavior, and performance.
B.
To profile a particular query to understand the mechanics of the query, its behavior, and performance.
Answers
C.
To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.
C.
To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.
Answers
D.
To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.
D.
To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.
Answers
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

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?

A.
File URL
A.
File URL
Answers
B.
Scoped URL
B.
Scoped URL
Answers
C.
Relative URL
C.
Relative URL
Answers
D.
Pre-Signed URL
D.
Pre-Signed URL
Answers
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

Question 417

Report
Export
Collapse

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

A.
Standard Edition
A.
Standard Edition
Answers
B.
Enterprise Edition
B.
Enterprise Edition
Answers
C.
Business Critical Edition
C.
Business Critical Edition
Answers
D.
Virtual Private Snowflake Edition
D.
Virtual Private Snowflake Edition
Answers
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.

Question 418

Report
Export
Collapse

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

A.
Range of values
A.
Range of values
Answers
B.
Distinct values
B.
Distinct values
Answers
C.
Index values
C.
Index values
Answers
D.
Sorted values
D.
Sorted values
Answers
E.
Null values
E.
Null values
Answers
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.

Question 419

Report
Export
Collapse

What is a directory table in Snowflake?

A.
A separate database object that is used to store file-level metadata
A.
A separate database object that is used to store file-level metadata
Answers
B.
An object layered on a stage that is used to store file-level metadata
B.
An object layered on a stage that is used to store file-level metadata
Answers
C.
A database object with grantable privileges for unstructured data tasks
C.
A database object with grantable privileges for unstructured data tasks
Answers
D.
A Snowflake table specifically designed for storing unstructured files
D.
A Snowflake table specifically designed for storing unstructured files
Answers
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.

Question 420

Report
Export
Collapse

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

A.
Use COPY INTO <external stage> followed by a GET command to download the file.
A.
Use COPY INTO <external stage> followed by a GET command to download the file.
Answers
B.
Use COPY INTO <internal stage> followed by a put command to download the file.
B.
Use COPY INTO <internal stage> followed by a put command to download the file.
Answers
C.
Use COPY INTO <internal stage> with SINGLE = TRUE followed by a GET command to download the file.
C.
Use COPY INTO <internal stage> with SINGLE = TRUE followed by a GET command to download the file.
Answers
D.
Use COPY INTO <external stage> with SINGLE = TRUE followed by a PUT command to download the file.
D.
Use COPY INTO <external stage> with SINGLE = TRUE followed by a PUT command to download the file.
Answers
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:

Total 627 questions
Go to page: of 63
ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms