ExamGecko
Login
Home / Snowflake / SnowPro Core / List of questions
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 23

List of questions

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?

The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.
The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.
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.
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.
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.
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.
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.
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.
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

asked 23/09/2024
James Davis
46 questions

Question 222

Report Export Collapse

Which statement describes how Snowflake supports reader accounts?

A reader account can consume data from the provider account that created it and combine it with its own data.
A reader account can consume data from the provider account that created it and combine it with its own data.
A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
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.

asked 23/09/2024
Ricardo de Sá Carvalho
43 questions

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?

USERADMIN
USERADMIN
PUBLIC
PUBLIC
ORGADMIN
ORGADMIN
SYSADMIN
SYSADMIN
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

asked 23/09/2024
Karthika Aravinth
36 questions

Question 224

Report Export Collapse

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

A directory table is a separate database object.
A directory table is a separate database object.
Directory tables store data file metadata.
Directory tables store data file metadata.
A directory table will be automatically added to a stage.
A directory table will be automatically added to a stage.
Directory tables do not have their own grantable privileges.
Directory tables do not have their own grantable privileges.
Directory table data can not be refreshed manually.
Directory table data can not be refreshed manually.
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

asked 23/09/2024
Bradley Coetzee
35 questions

Question 225

Report Export Collapse

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

JSON
JSON
BINARY
BINARY
VARCHAR
VARCHAR
VARIANT
VARIANT
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

asked 23/09/2024
Jim Apple
50 questions

Question 226

Report Export Collapse

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

Schema Stage
Schema Stage
User Stage
User Stage
Database Stage
Database Stage
Table Stage
Table Stage
External Named Stage
External Named Stage
Internal Named Stage
Internal Named Stage
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

asked 23/09/2024
Robin Koele
38 questions

Question 227

Report Export Collapse

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

Schema stage
Schema stage
Named stage
Named stage
User stage
User stage
Stream stage
Stream stage
Table stage
Table stage
Database stage
Database stage
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.

asked 23/09/2024
Priti Agrawal
38 questions

Question 228

Report Export Collapse

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

Configure the maximum clusters setting to 'Maximum.'
Configure the maximum clusters setting to 'Maximum.'
Turn on the additional clusters manually after starting the warehouse.
Turn on the additional clusters manually after starting the warehouse.
Set the minimum Clusters and maximum Clusters settings to the same value.
Set the minimum Clusters and maximum Clusters settings to the same value.
Set the minimum clusters and maximum clusters settings to different values.
Set the minimum clusters and maximum clusters settings to different values.
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.

asked 23/09/2024
martin lopez
36 questions

Question 229

Report Export Collapse

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

SHOW STORAGE BY TABLE;
SHOW STORAGE BY TABLE;
SHOW TABLES;
SHOW TABLES;
Information Schema -> TABLE_HISTORY
Information Schema -> TABLE_HISTORY
Information Schema -> TABLE_FUNCTION
Information Schema -> TABLE_FUNCTION
Information Schema -> TABLE_STORAGE_METRICS
Information Schema -> TABLE_STORAGE_METRICS
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

asked 23/09/2024
Eric Tegels
47 questions

Question 230

Report Export Collapse

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

1
1
2
2
3
3
4
4
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

asked 23/09/2024
Mario Alba Barrero
34 questions
Total 627 questions
Go to page: of 63
Open VPLUS File
Convert VPLUS to PDF

Related questions

What is a key feature of Snowflake architecture?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
How is unstructured data retrieved from data storage?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
A materialized view should be created when which of the following occurs? (Choose two.)
What happens when a virtual warehouse is resized?
How can a Snowflake user traverse semi-structured data?
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
User-level network policies can be created by which of the following roles? (Select TWO).