Black Friday Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

Question # 6

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

A.

The tables are now orphaned

B.

The user that deleted the role

C.

SYSADMIN

D.

The assumed role that dropped the role

Full Access
Question # 7

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

A.

Users

B.

Tables

C.

Databases

D.

Internal Stages

Full Access
Question # 8

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

A.

True

B.

False

Full Access
Question # 9

True or false: it is best practice to define a clustering key on every table.

A.

True

B.

False

Full Access
Question # 10

True or False: A Virtual Warehouse can be resized while suspended.

A.

True

B.

False

Full Access
Question # 11

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.

A.

True

B.

False

Full Access
Question # 12

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

A.

True

B.

False

Full Access
Question # 13

Snowflake is designed for which type of workloads? (Choose two.)

A.

OLAP (Analytics) workloads

B.

OLTP (Transactional) workloads

C.

Concurrent workloads

D.

On-premise workloads

Full Access
Question # 14

The PUT command: (Choose two.)

A.

Automatically creates a File Format object

B.

Automatically uses the last Stage created

C.

Automatically compresses files using Gzip

D.

Automatically encrypts files

Full Access
Question # 15

How would you determine the size of the virtual warehouse used for a task?

A.

Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

B.

Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

C.

If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

D.

Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Full Access
Question # 16

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

A.

True

B.

False

Full Access
Question # 17

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

A.

True

B.

False

Full Access
Question # 18

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

A.

True

B.

False

Full Access
Question # 19

How many shares can be consumed by single Data Consumer?

A.

1

B.

10

C.

100, but can be increased by contacting support

D.

Unlimited

Full Access
Question # 20

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

data.

A.

True

B.

False

Full Access
Question # 21

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

A.

Tables

B.

Schemas

C.

Databases

D.

Stages

Full Access
Question # 22

Which formats are supported for unloading data from Snowflake?

Choose 2 answers

A.

Delimited (CSV, TSV, etc.)

B.

Avro

C.

JSON

D.

ORC

Full Access
Question # 23

Which object allows you to limit the number of credits consumed within a Snowflake account?

Select one.

A.

Account usage Tracking

B.

Resource Monitor

C.

Warehouse Limit Parameter

D.

Credit Consumption Tracker

Full Access
Question # 24

When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:

Select one.

A.

Concurrency

B.

Performance

Full Access