Accurate Hot Selling SnowPro-Core Exam Dumps 2022 Newly Released [Q174-Q197]

Rate this post

Accurate Hot Selling SnowPro-Core Exam Dumps 2022 Newly Released

Get 100% Authentic Snowflake SnowPro-Core Dumps with Correct Answers

Understanding functional and technical aspects of SnowPro Core Certification

The following will be discussed in SNOWFLAKE SNOWPRO CORE exam dumps:

Clustering
Time Travel, Fail Safe
Data Loading
Storage Monitoring
Error handling & Troubleshooting
Data Storages – Cost & Retention
Continuous Load Options – Snowpipe
Loading Consideration & Load Management
Data Encryption
Metadata
Security – Network Policies
Federated Authentication & SSO
Table Types, File Formats

QUESTION 174
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

Enterprise

Business Critical

Standard

Virtual Private Snowflake

QUESTION 175
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

True

False

QUESTION 176
Which of the following statements is true of Snowflake micro-partitioning?

Micro-partitioning has been known to introduce data skew

Micro-partitioning: requires a partitioning schema to be defined up front

Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded

Micro-partitioning can be disabled within a Snowflake account

QUESTION 177
Which of the following terms best describes Snowflake’s database architecture?

Columnar shared nothing

Shared disk

Multi-cluster, shared data

Cloud-native shared memory

QUESTION 178
Select the three types of tables that exist within Snowflake.
Choose 3 answers

Temporary

Transient

Provisioned

Permanent

QUESTION 179
Where can a user find and review the failed logins of a specific user for the past 30 days?

The USERS view in ACCOUNT_USAGE

The LOGIN_HISTORY view in ACCOUNT_USAGE

The ACCESS_HISTORY view in ACCOUNT_USAGE

The SESSIONS view in ACCOUNT_USAGE

QUESTION 180
Which of the following describes external functions in Snowflake?

They are a type of User-defined Function (UDF).

They contain their own SQL code.

They call code that is stored inside of Snowflake.

They can return multiple rows for each row received

QUESTION 181
Which type of table corresponds to a single Snowflake session?

Temporary

Translent

Provisional

Permanent

QUESTION 182
User-level network policies can be created by which of the following roles? (Select TWO).

ROLEADMIN

ACCOUNTADMIN

SYSADMIN

SECURITYADMIN

USERADMIN

QUESTION 183
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 184
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
Select one.

1 Hour

3 Hours

12 hours

24 hours

QUESTION 185
True or False: Pipes can be suspended and resumed.

True

False

QUESTION 186
A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?

Use data encryption.

Use dynamic data masking.

Use secure materialized views.

Revoke all roles for functional managers and end users.

QUESTION 187
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Customers can change the size of the Warehouse after creation

A Warehouse can be resized while running

A Warehouse can be configured to suspend after a period of inactivity

A Warehouse can be configured to auto-resume when new queries are submitted

QUESTION 188
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 189
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Customer-managed encryption keys through Tri-Secret Secure

Automatic encryption of all data

Up to 90 days of data recovery through Time Travel

Object-level access control

Column-level security to apply data masking policies to tables and views

QUESTION 190
How a Snowpipe charges calculated?

Per-second/per Warehouse size

Per-second/per-core granularity

Number of Pipes in account

Total storage bucket size

QUESTION 191
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Load files that are approximately 25 MB or smaller.

Remove all dates and timestamps.

Load files that are approximately 100-250 MB (or larger)

Avoid using embedded characters such as commas for numeric data types

Remove semi-structured data types

QUESTION 192
Fail-safe is unavailable on which table types?

Temporary

Transient

Provisional

Permanent

QUESTION 193
What transformations are supported in a CREATE PIPE … AS COPY … FROM (….) statement? (Select TWO.)

Data can be filtered by an optional where clause

Incoming data can be joined with other tables

Columns can be reordered

Columns can be omitted

Row level access can be defined

QUESTION 194
True or False: All Snowflake table types include fail-safe storage.

True

False

QUESTION 195
True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

True

False

QUESTION 196
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Configure the warehouse to a size larger than generally required

Set the minimum and maximum clusters to autoscale

Use the standard warehouse scaling policy

Use the economy warehouse scaling policy

QUESTION 197
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

Scaling rhythmically

Scaling max

Scaling out

Scaling Up