Pass Snowflake SnowPro-Core With ExamcollectionPass Exam Dumps - Updated on Jul-2023 [Q159-Q178]

Rate this post

Pass Snowflake SnowPro-Core With ExamcollectionPass Exam Dumps – Updated on Jul-2023

Fully Updated SnowPro-Core Dumps – 100% Same Q&A In Your Real Exam

QUESTION 159
Which statements are true of micro-partitions?
Choose 2 answers

They are approximately 16MB in size

They are stored compressed only if COMPRESS=TRUE on Table

They are Immutable

They are only encrypted in the Enterprise edition and above

QUESTION 160
What is a limitation of a Materialized View?

A Materialized View cannot support any aggregate functions

A Materialized View can only reference up to two tables

A Materialized View cannot be joined with other tables

A Materialized View cannot be defined with a JOIN

QUESTION 161
A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?

Create a task that runs a copy into operation from an external stage every 5 minutes

Create a task that puts the files in an internal stage and automate the data loading wizard

Create a task that runs a GET operation to intermittently check for new files

Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

QUESTION 162
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

True

False

QUESTION 163
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?
(Choose all that apply.)

Growth of storage and compute are tightly coupled together

Storage expands without the requirement to add more compute

Compute can be scaled up or down without the requirement to add more storage

Multiple compute clusters can access stored data without contention

QUESTION 164
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.

Directory tables store data file metadata.

A directory table will be automatically added to a stage.

Directory tables do not have their own grantable privileges.

Directory table data can not be refreshed manually.

QUESTION 165
Which of the following objects can be cloned? (Choose four.)

Tables

Named File Formats

Schemas

Databases

Users

QUESTION 166
A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

Increase the warehouse size from Medium to 2XL.

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

Configure the warehouse to a multi-cluster warehouse.

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

QUESTION 167
What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

Row level access policies

Data masking policies

Data encryption

Time Travel

External tokenization

QUESTION 168
Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Tri-Secret Secure

Time Travel

Fail-safe

Data encryption

External stages

QUESTION 169
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

It removes the last element of the outer array.

It removes the outer array structure and loads the records into separate table rows,

It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

QUESTION 170
The PUT command: (Choose two.)

Automatically creates a File Format object

Automatically uses the last Stage created

Automatically compresses files using Gzip

Automatically encrypts files

QUESTION 171
Which feature is only available in the Enterprise or higher editions of Snowflake?

Column-level security

SOC 2 type II certification

Multi-factor Authentication (MFA)

Object-level access control

QUESTION 172
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

128

QUESTION 173
Which of the following roles is recommended to be used to create and manage users and roles?

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

QUESTION 174
True or False: Users are able to see the result sets of queries executed by other users that share their same role.

True

False

QUESTION 175
Which of the following can be used when unloading data from Snowflake? (Choose two.)

When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

Use the ENCODING file format option to change the encoding from the default UTF-8.

The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

QUESTION 176
A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

All data from all of the files on the stage will be appended to the table

Only data about new customers from the new files will be appended to the table

The operation will fail with the error uncertain files in stage.

All data from only the newly-added files will be appended to the table.

QUESTION 177
True or False: You can define multiple columns within a clustering key on a table.

True

False

QUESTION 178
What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Removing a column from the query SELECT list

Stopping the virtual warehouse that the query is running against

Clustering of the data used by the query

Executing the RESULTS_SCAN() table function