Special Black Friday Discounts Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

SnowPro-Core SnowPro Core Certification Exam Questions and Answers

Questions 4

True or False: Once created, a micro-partition will never be changed.

Options:

A.

True

B.

False

Buy Now
Questions 5

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

Options:

A.

Concurrency

B.

Performance

Buy Now
Questions 6

True or False: It is possible to load data into Snowflake without creating a named File Format object.

Options:

A.

True

B.

False

Buy Now
Questions 7

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

Options:

A.

Columnar shared nothing

B.

Shared disk

C.

Multi-cluster, shared data

D.

Cloud-native shared memory

Buy Now
Questions 8

What is the minimum duration charged when starting a virtual warehouse?

Options:

A.

1 second

B.

1 minute

C.

1 hour

D.

1 day

Buy Now
Questions 9

True or False: The COPY command must specify a File Format in order to execute.

Options:

A.

True

B.

False

Buy Now
Questions 10

What is the most granular object that the Time Travel retention period can be defined on?

Select one.

Options:

A.

Account

B.

Database

C.

Schema

D.

Table

Buy Now
Questions 11

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

Options:

A.

The object immediately becomes unavailable for all Data Consumers

B.

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

C.

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

D.

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

Buy Now
Questions 12

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

Options:

A.

Is available to all Snowflake Editions

B.

Is only available to customers with Business Critical Edition

C.

Restricts or enables access to specific IP addresses

D.

Is activated using an “ALTER DATABASE” command

Buy Now
Questions 13

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

Options:

A.

True

B.

False

Buy Now
Questions 14

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

Options:

A.

MIN(< < column value>>)

B.

COPY

C.

SUM(<< column value >>)

D.

UPDATE

Buy Now
Questions 15

Which of the following statements is true of data loading?

Select one.

Options:

A.

Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast

B.

The "deal file size for loading is 16MB to match micro-partition size

C.

Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism

Once loaded, there is no option to force a reload of an already loaded file

Buy Now
Questions 16

Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):

Select one:

Options:

A.

SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN

B.

SECURITYADMIN ACCOUNTADMIN, SYSADMIN

C.

SECURITYADMIN, ACCOUNTADMIN

D.

ACCOUNTADMIN

Buy Now
Questions 17

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

Options:

A.

True

B.

False

Buy Now
Questions 18

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

Options:

A.

Auto-suspend

B.

Auto-resume

C.

Local SSD size

D.

User count

Buy Now
Questions 19

Which item in the Data Warehouse migration process does not apply in Snowflake>

Options:

A.

Migrate Users

B.

Migrate Schemas

C.

Migrate Indexes

D.

Build the Data pipeline

Buy Now
Questions 20

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

Options:

A.

Configure the Maximum Clusters setting to “Auto-Scale”

B.

Set the Warehouse type to “Auto”

C.

Set the Minimum Clusters and Maximum Clusters settings to the same value

D.

Set the Minimum Clusters and Maximum Clusters settings to the different values

Buy Now
Questions 21

True or False: You can query the files in an External Stage directly without having to load the data into a table.

Options:

A.

True

B.

False

Buy Now
Questions 22

When creating a user it is advisable sable to:

Choose 2 answers

Options:

A.

Set the user to be initially disabled

B.

Force an immediate password change

C.

Set a default role for the user

D.

Set the number of minutes to unlock to 15 minutes

E.

Set the users access to expire within a specified timeframe

Buy Now
Questions 23

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

Options:

A.

60 minutes

B.

24 hours

C.

14 days

D.

30 days

E.

1 year

Buy Now
Questions 24

Which of the following statements are true about Schemas in Snowflake? (Choose two.)

Options:

A.

A Schema may contain one or more Databases

B.

A Database may contain one or more Schemas

C.

A Schema is a logical grouping of Database Objects

D.

Each Schema is contained within a Warehouse

Buy Now
Exam Code: SnowPro-Core
Exam Name: SnowPro Core Certification Exam
Last Update: Dec 5, 2021
Questions: 161

PDF + Testing Engine

$72  $179.99

Testing Engine

$56  $139.99
buy now SnowPro-Core testing engine

PDF (Q&A)

$48  $119.99
buy now SnowPro-Core pdf