Updated Apr 10, 2023 Test Engine to Practice Test for SnowPro-Core Valid and Updated Dumps [Q128-Q152]

admin SnowPro-Core Snowflake April 10, 2023

Rate this post

Updated Apr 10, 2023 Test Engine to Practice Test for SnowPro-Core Valid and Updated Dumps

Exam Questions for SnowPro-Core Updated Versions With Test Engine

NEW QUESTION 128
True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

True

False

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

Temporary

Translent

Provisioned

Permanent

NEW QUESTION 130
Which command sets the Virtual Warehouse for a session?

COPY WAREHOUSE FROM <<config file>>;

SET WAREHOUSE = <<warehouse name>>;

USE WAREHOUSE <<warehouse name>>;

USE VIRTUAL_WAREHOUSE <<warehouse name>>;

NEW QUESTION 131
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

Custom

Economy

Optimized

Standard

NEW QUESTION 132
When should you consider disabling auto-suspend for a Virtual Warehouse? (Choose two.)

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 do not want to have to manually turn on the Warehouse each time a user needs it

NEW QUESTION 133
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

NEW QUESTION 134
Where is Snowflake metadata stored?

Within the data files

In the virtual warehouse layer

In the cloud services layer

In the remote storage layer

NEW QUESTION 135
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

STATEMENT_TIMEOUT__IN__SECONDS

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

MAX_CONCURRENCY__LEVEL

QUERY_TIMEOUT_IN_SECONDS

NEW QUESTION 136
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

Changing a column that is not in the cached query

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

True

False

NEW QUESTION 138
Which statement best describes “clustering”?

Clustering represents the way data is grouped together and stored within Snowflake’s micro-partitions

The database administrator must define the clustering methodology for each Snowflake table

The clustering key must be included on the COPY command when loading data into Snowflake

Clustering can be disabled within a Snowflake account

NEW QUESTION 139
What is the recommended compressed file size range for continuous data loads using Snowpipe?

8-16 MB

16-24 MB

10-99 MB

100-250 MB

NEW QUESTION 140
How can a row access policy be applied to a table or a view? (Choose two.)

Within the policy DDL

Within the create table or create view DDL

By future APPLY for all objects in a schema

Within a control table

Using the command ALTER <object> ADD ROW ACCESS POLICY <policy>;

NEW QUESTION 141
The Snowflake Cloud Data Platform is described as having which of the following architectures?

Shared-disk

Shared-nothing

Multi-cluster shared data

Serverless query engine

NEW QUESTION 142
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

Is available to all Snowflake Editions

Is only available to customers with Business Critical Edition

Restricts or enables access to specific IP addresses

Is activated using an “ALTER DATABASE” command

NEW QUESTION 143
The FLATEEN function is used to query which type of data in Snowflake?

Structured data

Semi-structured data

Both of the above

None of the above

NEW QUESTION 144
What is a best practice after creating a custom role?

Create the custom role using the SYSADMIN role.

Assign the custom role to the SYSADMIN role

Assign the custom role to the PUBLIC role

Add__CUSTOM to all custom role names

NEW QUESTION 145
A company’s security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
FROM ACCOUNT_USAGE.USERS;

SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user())

SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.ACCESS_HISTORY;

SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.LOGIN_HISTORY;

NEW QUESTION 146
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

True

False

NEW QUESTION 147
Select the different types of Internal Stages: (Choose three.)

Named Stage

User Stage

Table Stage

Schema Stage

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

SHOW STORAGE BY TABLE;

SHOW TABLES;

Information Schema -> TABLE_HISTORY

Information Schema -> TABLE_FUNCTION

Information Schema -> TABLE_STORAGE_METRICS

NEW QUESTION 149
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

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

True

False

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

True

False

NEW QUESTION 152
If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

All Snowflake sessions using the warehouse are terminated.

The last query using the warehouse completes.

There are no users loaned into Snowflake.