New Year Sale Special - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

In the Snowflake access control model, which entity owns an object by default?

A.

The user who created the object

B.

The SYSADMIN role

C.

Ownership depends on the type of object

D.

The role used to create the object

Which feature allows a user the ability to control the organization of data in a micro-partition?

A.

Range Partitioning

B.

Search Optimization Service

C.

Automatic Clustering

D.

Horizontal Partitioning

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON.

How can this be accomplished?

A.

select src:dealership from car_sales;

B.

select src.dealership from car_sales;

C.

select src:Dealership from car_sales;

D.

select dealership from car_sales;

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

A.

SYSADMIN

B.

SECURITYADMIN

C.

PUBLIC

D.

ACCOUNTADMIN

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

A.

True

B.

False

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

A.

Customers can change the size of the Warehouse after creation

B.

A Warehouse can be resized while running

C.

A Warehouse can be configured to suspend after a period of inactivity

D.

A Warehouse can be configured to auto-resume when new queries are submitted

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?

(Choose all that apply.)

A.

JDBC

B.

SnowSQL

C.

Snowflake Web Interface (UI)

D.

ODBC

E.

Python

D18912E1457D5D1DDCBD40AB3BF70D5D

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

A.

Tables

B.

Named File Formats

C.

Schemas

D.

Shares

E.

Databases

F.

Users

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

A.

Concurrency

B.

Performance

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

A.

They happen approximately weekly

B.

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

C.

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

version

D.

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