The Best SnowPro-Core Exam Study Material and Preparation Test Question Dumps [Q124-Q146]

4/5 - (1 vote)

The Best SnowPro-Core Exam Study Material and Preparation Test Question Dumps

Get Ready to Pass the SnowPro-Core exam Right Now Using Our SnowPro Core Exam Package

NO.124 Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

ROLES

POLICY_REFERENCES

QUERY_HISTORY

RESOURCE_MONIT ORS

ACCESS_HISTORY

NO.125 What data is stored in the Snowflake storage layer? (Select TWO).

Snowflake parameters

Micro-partitions

Query history

Persisted query results

Standard and secure view results

NO.126 True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

True

False

NO.127 Which statement best describes Snowflake tables?

Snowflake tables are logical representations of underlying physical data

Snowflake tables ate the physical instantiation of data loaded Into Snowflake

Snowflake tables require that clustering keys be defined to perform optimally

Snowflake tables are owned by a user

NO.128 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

NO.129 What is the default character set used when loading CSV files into Snowflake?

UTF-8

UTF-16

ISO S859-1

ANSI_X3.A

NO.130 When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

The Pipe load history is reset to empty

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

All of the above

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

True

False

NO.132 Select the different types of Internal Stages: (Choose three.)

Named Stage

User Stage

Table Stage

Schema Stage

NO.133 When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers

When users will be using compute at different times throughout a 24/7 period

When managing a steady workload

When the compute must be available with no delay or lag time

When you don’t want to have to manually turn on the Warehouse each time a user needs it

NO.134 Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

Scaling rhythmically

Scaling max

Scaling out

Scaling Up

NO.135 Which type of table corresponds to a single Snowflake session?

Temporary

Translent

Provisional

Permanent

NO.136 Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously?
Choose 3 answers

MIN(< < column value>>)

COPY

SUM(<< column value >>)

UPDATE

NO.137 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

NO.138 Which of the following DML commands isn’t supported by Snowflake?

UPSERT

MERGE

UPDATE

TRUNCATE TABLE

NO.139 True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

True

False

NO.140 True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

True

False

NO.141 Which of the following is true of Snowpipe via REST API?
Choose 2 answers

you can only use it on internal Stages

All COPY INTO options are available fluting pipe creation

Snowflake automatically manages the compute required to execute the Pipe’s copy into commands

Snowpipe keeps track of which files it has loaded

NO.142 What are the default Time Travel and Fail-safe retention periods for transient tables?

Time Travel – 1 day. Fail-safe – 1 day

Time Travel – 0 days. Fail-safe – 1 day

Time Travel – 1 day. Fail-safe – 0 days

Transient tables are retained in neither Fail-safe nor Time Travel

NO.143 Which of the following roles is recommended to be used to create and manage users and roles?

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

NO.144 In which layer of its architecture does Snowflake store its metadata statistics?
Select one.

Storage Layer

Compute Layer

Database Layer

Cloud Service Layer

NO.145 Snowflake provides a mechanism for its customers to override its clustering algorithms. This method is:

Micro-partitions

Clustering keys

Key partitions

Clustered partitions

NO.146 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

Get Special Discount Offer of SnowPro-Core Certification Exam Sample Questions and Answers: https://www.actualcollection.com/SnowPro-Core-exam-questions.html

Leave a comment Cancel reply