ExamGecko
Search Search Login
Home Home / Snowflake / SnowPro Core

Snowflake SnowPro Core Practice Test - Questions Answers, Page 23

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 221

Report
Export
Collapse

How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

A.
The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.
A.
The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.
Answers
B.
The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.
B.
The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.
Answers
C.
The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.
C.
The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.
Answers
D.
The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.
D.
The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.
Answers
Suggested answer: D

Explanation:

Snowflake allows data providers to share data with consumers across different cloud platforms and regions through database replication. The data provider must replicate the database to a secondary account in the target region or cloud platform within the same organization, and then create a share to the data consumer's account.This process ensures that the data is available in the consumer's region and on their cloud platform, facilitating seamless data sharing.

Reference: Sharing data securely across regions and cloud platforms | Snowflake Documentation

Question 222

Report
Export
Collapse

Which statement describes how Snowflake supports reader accounts?

A.
A reader account can consume data from the provider account that created it and combine it with its own data.
A.
A reader account can consume data from the provider account that created it and combine it with its own data.
Answers
B.
A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
B.
A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
Answers
C.
The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
C.
The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
Answers
D.
The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
D.
The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
Answers
Suggested answer: B

Explanation:

Snowflake supports reader accounts, which are a type of account that allows data providers to share data with consumers who are not Snowflake customers.However, for data sharing to occur, the consumer needs to become a licensed Snowflake customer because data sharing is only supported between Snowflake accounts.

Reference: Introduction to Secure Data Sharing | Snowflake Documentation2.

Question 223

Report
Export
Collapse

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

A.
USERADMIN
A.
USERADMIN
Answers
B.
PUBLIC
B.
PUBLIC
Answers
C.
ORGADMIN
C.
ORGADMIN
Answers
D.
SYSADMIN
D.
SYSADMIN
Answers
Suggested answer: A

Explanation:

The first user assigned to a new Snowflake account, typically with the ACCOUNTADMIN role, should create at least one additional user with the USERADMIN administrative privilege.This role is responsible for creating and managing users and roles within the Snowflake account.

Reference: Access control considerations | Snowflake Documentation

Question 224

Report
Export
Collapse

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

A.
A directory table is a separate database object.
A.
A directory table is a separate database object.
Answers
B.
Directory tables store data file metadata.
B.
Directory tables store data file metadata.
Answers
C.
A directory table will be automatically added to a stage.
C.
A directory table will be automatically added to a stage.
Answers
D.
Directory tables do not have their own grantable privileges.
D.
Directory tables do not have their own grantable privileges.
Answers
E.
Directory table data can not be refreshed manually.
E.
Directory table data can not be refreshed manually.
Answers
Suggested answer: B, D

Explanation:

Directory tables in Snowflake are used to store metadata about data files in a stage. They are not separate database objects but are conceptually similar to external tables.Directory tables do not have grantable privileges of their own

Question 225

Report
Export
Collapse

Which data type can store more than one type of data structure?

A.
JSON
A.
JSON
Answers
B.
BINARY
B.
BINARY
Answers
C.
VARCHAR
C.
VARCHAR
Answers
D.
VARIANT
D.
VARIANT
Answers
Suggested answer: D

Explanation:

The VARIANT data type in Snowflake can store multiple types of data structures, as it is designed to hold semi-structured data.It can contain any other data type, including OBJECT and ARRAY, which allows it to represent various data structures

Question 226

Report
Export
Collapse

Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

A.
Schema Stage
A.
Schema Stage
Answers
B.
User Stage
B.
User Stage
Answers
C.
Database Stage
C.
Database Stage
Answers
D.
Table Stage
D.
Table Stage
Answers
E.
External Named Stage
E.
External Named Stage
Answers
F.
Internal Named Stage
F.
Internal Named Stage
Answers
Suggested answer: B, D, F

Explanation:

The Snowflake PUT command is used to upload files from a local file system to Snowflake stages, specifically the user stage, table stage, and internal named stage.These stages are where the data files are temporarily stored before being loaded into Snowflake tables

Question 227

Report
Export
Collapse

What internal stages are available in Snowflake? (Choose three.)

A.
Schema stage
A.
Schema stage
Answers
B.
Named stage
B.
Named stage
Answers
C.
User stage
C.
User stage
Answers
D.
Stream stage
D.
Stream stage
Answers
E.
Table stage
E.
Table stage
Answers
F.
Database stage
F.
Database stage
Answers
Suggested answer: B, C, E

Explanation:

Snowflake supports three types of internal stages: Named, User, and Table stages. These stages are used for staging data files to be loaded into Snowflake tables.Schema, Stream, and Database stages are not supported as internal stages in Snowflake.

Reference: Snowflake Documentation1.

Question 228

Report
Export
Collapse

How would a user run a multi-cluster warehouse in maximized mode?

A.
Configure the maximum clusters setting to 'Maximum.'
A.
Configure the maximum clusters setting to 'Maximum.'
Answers
B.
Turn on the additional clusters manually after starting the warehouse.
B.
Turn on the additional clusters manually after starting the warehouse.
Answers
C.
Set the minimum Clusters and maximum Clusters settings to the same value.
C.
Set the minimum Clusters and maximum Clusters settings to the same value.
Answers
D.
Set the minimum clusters and maximum clusters settings to different values.
D.
Set the minimum clusters and maximum clusters settings to different values.
Answers
Suggested answer: C

Explanation:

To run a multi-cluster warehouse in maximized mode, a user should set the minimum and maximum number of clusters to the same value.This ensures that all clusters are available when the warehouse is started, providing maximum resources for query execution.

Reference: Snowflake Documentation2.

Question 229

Report
Export
Collapse

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

A.
SHOW STORAGE BY TABLE;
A.
SHOW STORAGE BY TABLE;
Answers
B.
SHOW TABLES;
B.
SHOW TABLES;
Answers
C.
Information Schema -> TABLE_HISTORY
C.
Information Schema -> TABLE_HISTORY
Answers
D.
Information Schema -> TABLE_FUNCTION
D.
Information Schema -> TABLE_FUNCTION
Answers
E.
Information Schema -> TABLE_STORAGE_METRICS
E.
Information Schema -> TABLE_STORAGE_METRICS
Answers
Suggested answer: A, E

Explanation:

To monitor data storage for individual tables, the commands and objects that can be used are 'SHOW STORAGE BY TABLE;' and the Information Schema view 'TABLE_STORAGE_METRICS'.These tools provide detailed information about the storage utilization for tables.

Reference: Snowflake Documentation

Question 230

Report
Export
Collapse

How many resource monitors can be assigned at the account level?

A.
1
A.
1
Answers
B.
2
B.
2
Answers
C.
3
C.
3
Answers
D.
4
D.
4
Answers
Suggested answer: A

Explanation:

Snowflake allows for only one resource monitor to be assigned at the account level.This monitor oversees the credit usage of all the warehouses in the account.

Reference: Snowflake Documentation

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