SnowPro-Core PDF Pass Leader, SnowPro-Core Latest Real Test [Q60-Q79]

4.5/5 - (2 votes)

SnowPro-Core PDF Pass Leader, SnowPro-Core Latest Real Test

Valid SnowPro-Core Test Answers & SnowPro-Core Exam PDF

NEW QUESTION 60
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Number of users

Warehouse size

Amount of data processed

# of clusters for the Warehouse

Explanation
https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage “Snowflake credits are charged based on the number of virtual warehouses you use, how long they run, and their size.”

NEW QUESTION 61
What is the maximum compressed row size in Snowflake?

8KB

16MB

50MB

4000GB

Explanation
MAX size for compressed data for semi-structured data type is also 16 MB. That means if our table has a semi-structured data type column with 16MB data other columns will have NULL data.

NEW QUESTION 62
True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

True

False

NEW QUESTION 63
True or False: Fail-safe can be disabled within a Snowflake account.

True

False

NEW QUESTION 64
True or False: Data Providers can share data with only the Data Consumer.

True

False

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

Tables

Named File Formats

Schemas

Databases

Users

NEW QUESTION 66
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

Concurrency

Performance

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

Temporary

Transient

Provisioned

Permanent

NEW QUESTION 68
When loading data into Snowflake, the COPY command supports:
Choose 2 answers

Joins

Fitters

Data type conversions

Column reordering

Aggregates

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

Scaling rhythmically

Scaling max

Scaling out

Scaling Up

NEW QUESTION 70
What is the minimum Snowflake edition that provides data sharing?

Standard

Premier

Enterprise

Business Critical Edition

NEW QUESTION 71
Which of the following objects is not covered by Time Travel?

Tables

Schemas

Databases

Stages

NEW QUESTION 72
True or False: A single database can exist in more than one Snowflake account.

True

False

NEW QUESTION 73
The Query History in the Snowflake Web Interface (UI) is kept for approximately:

60 minutes

24 hours

14 days

30 days

1 year

NEW QUESTION 74
Which of the following commands 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>>;

Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

NEW QUESTION 75
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)

The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period

The same exact query will return the precomputed results if the underlying data hasn’t changed and the results were last accessed within previous 24 hour period

The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period

The “24 hour” timer on the precomputed results gets renewed every time the exact query is executed

NEW QUESTION 76
Which of the following commands sets the Virtual Warehouse for a session?

COPT WAREHOUSE FROM <<Config file> ;

SET warehouse = <<warehouse name>>;

USE WAREHOUSE <<warehouse name>>;

USE VIRTUAL_WAREHOUSE <<warehouse name>>;

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

NEW QUESTION 78
Which object allows you to limit the number of credits consumed within a Snowflake account?
Select one.

Account usage Tracking

Resource Monitor

Warehouse Limit Parameter

Credit Consumption Tracker

NEW QUESTION 79
Which of the following are options when creating a virtual Warehouse?
Choose 2 answers

Auto-drop

Auto resize

Auto-resume

Auto-suspend

Loading …

SnowPro-Core Dumps Ensure Your Passing: https://www.validbraindumps.com/SnowPro-Core-exam-prep.html

Free valid test braindumps

SnowPro-Core PDF Pass Leader, SnowPro-Core Latest Real Test [Q60-Q79]

Leave a Reply Cancel reply