[Apr-2022] Free SnowPro-Core Exam Dumps to Improve Exam Score [Q38-Q52]

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

Custom

Economy

Optimized

Standard

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

4

16

32

128

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

NEW QUESTION 41
True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

True

False

NEW QUESTION 42
Which of the following are options when creating a Virtual Warehouse?

Auto-suspend

Auto-resume

Local SSD size

User count

NEW QUESTION 43
Which formats are supported for unloading data from Snowflake?
Choose 2 answers

Delimited (CSV, TSV, etc.)

Avro

JSON

ORC

NEW QUESTION 44
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

True

False

NEW QUESTION 45
What happens when a Data Provider revokes privileges to a Share on an object in their source database?

The object immediately becomes unavailable for all Data Consumers

Any additional data arriving after this point in time will not be visible to Data Consumers

The Data Consumers stop seeing data updates and become responsible for storage charges for the object

A static copy of the object at the time the privilege was revoked is created In the Data Consumers’ accounts

NEW QUESTION 46
Which of the following DML commands isn’t supported by Snowflake?

UPSERT

MERGE

UPDATE

TRUNCATE TABLE

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

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

NEW QUESTION 48
When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
Select one.

Concurrency

Performance

NEW QUESTION 49
A Virtual Warehouse’s auto-suspend and auto-resume settings apply to:

The primary cluster in the Virtual Warehouse

The entire Virtual Warehouse

The database the Virtual Warehouse resides in

The queries currently being run by the Virtual Warehouse

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

NEW QUESTION 51
Which of the following statements are true of Snowflake releases: (Choose two.)

They happen approximately weekly

They roll up and release approximately monthly, but customers can request early release application

During a release, new customer requests/queries/connections transparently move over to the newer version

A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

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

8KB

16MB

50MB

4000GB

[Apr-2022] Free SnowPro-Core Exam Dumps to Improve Exam Score [Q38-Q52]

Be the first to reply

Leave a Reply Cancel reply