A.  

Tables, secure views, and secure UDFs can be shared

B.  

Shares can be shared

C.  

Data consumers can clone a new table from a share

D.  

Access to a share cannot be revoked once granted

A.  

In the metadata of the target table for 14 days

B.  

In the metadata of the pipe for 14 days

C.  

In the metadata of the target table for 64 days

D.  

In the metadata of the pipe for 64 days

A.  

The number of queries executed

B.  

The number of active users assigned to the warehouse

C.  

The size of the virtual warehouse

D.  

The length of time the warehouse is running

E.  

The duration of the queries that are executed

A.  

GeoJSON

B.  

Array

C.  

XML

D.  

Object

E.  

BLOB

A.  

Coordinates activities in the Snowflake account

B.  

Executes queries submitted by the Snowflake account users

C.  

Manages quotas on the Snowflake account storage

D.  

Manages the virtual warehouse cache to speed up queries

A.  

Amazon Web Services

B.  

Docker

C.  

IBM Cloud

D.  

Microsoft Azure Cloud

E.  

Google Cloud Platform

F.  

Oracle Cloud

A.  

Compute resources

B.  

Query execution

C.  

Authentication

D.  

Data storage

E.  

Metadata

A.  

STRIP_NULL_VALUES

B.  

SKIP_BYTE_ORDER_MARK

C.  

REPLACE_INVALID_CHARACTERS

D.  

VALIDATION_MODE

A.  

A reader account can consume data from the provider account that created it and combine it with its own data.

B.  

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

C.  

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

D.  

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

A.  

A directory table is a separate database object.

B.  

Directory tables store data file metadata.

C.  

A directory table will be automatically added to a stage.

D.  

Directory tables do not have their own grantable privileges.

E.  

Directory table data can not be refreshed manually.

A.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake

A.  

Database replication and failover

B.  

Automated index management

C.  

Customer managed keys (Tri-secret secure)

D.  

Extended time travel

E.  

Native support for geospatial data

A.  

All columns in a micro-partition

B.  

Any columns accessed during the query

C.  

The columns in the result set of the query

D.  

All rows accessed during the query

A.  

SELECT SUM (ORDER_AMT) FROM SALES;

B.  

SELECT AVG(ORDER_QTY) FROM SALES;

C.  

SELECT MIN(ORDER_AMT) FROM SALES;

D.  

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

A.  

Caching query results

B.  

Running EXPLAIN and SHOW commands

C.  

Cloning a database

D.  

Running a custom query

E.  

Running COPY commands

A.  

Growth of storage and compute are tightly coupled together

B.  

Storage expands without the requirement to add more compute

C.  

Compute can be scaled up or down without the requirement to add more storage

D.  

Multiple compute clusters can access stored data without contention

A.  

True

B.  

False

A.  

True

B.  

False

A.  

UPSERT

B.  

MERGE

C.  

UPDATE

D.  

TRUNCATE TABLE

A.  

Custom

B.  

Economy

C.  

Optimized

D.  

Standard

A.  

True

B.  

False

A.  

True

B.  

False

A.  

Columnar shared nothing

B.  

Shared disk

C.  

Multi-cluster, shared data

D.  

Cloud-native shared memory

A.  

The validation_mode option is used when creating an Internal Stage

B.  

validation_mode=return_all_errors is a parameter of the copy command

C.  

The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

D.  

The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

A.  

True

B.  

False

A.  

True

B.  

False

A.  

Standard

B.  

Premier

C.  

Enterprise

D.  

Business Critical Edition

A.  

Compute

B.  

Tri-Secret Secure

C.  

Storage

D.  

Cloud Services

A.  

True

B.  

False

A.  

It was built specifically for the cloud

B.  

It was built as an on-premises solution and then ported to the cloud

C.  

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

D.  

It was built for Hadoop architecture

E.  

It's based on an Oracle Architecture

A.  

account__usage . query history view

B.  

account__usage.query__history__archive View

C.  

information__schema . cruery_history view

D.  

information__schema - query history_by_ses s i on view

A.  

A single join node uses more than 50% of the query time

B.  

Partitions scanned is equal to partitions total

C.  

An AggregateOperacor node is present

D.  

The query is spilling to remote storage

A.  

Credits are billed per-minute with a 60-minute minimum

B.  

Credits are used to pay for cloud data storage usage

C.  

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

D.  

Credits are consumed based on the warehouse size and the time the warehouse is running

A.  

Snowflake parameters

B.  

Micro-partitions

C.  

Query history

D.  

Persisted query results

E.  

Standard and secure view results

A.  

Create the custom role using the SYSADMIN role.

B.  

Assign the custom role to the SYSADMIN role

C.  

Assign the custom role to the PUBLIC role

D.  

Add__CUSTOM to all custom role names

A.  

A read-only copy of the cloned tables is stored.

B.  

The replication will not be successful.

C.  

The physical data is replicated

D.  

Additional costs for storage are charged to a secondary account

E.  

Metadata pointers to cloned tables are replicated

A.  

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

B.  

When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

C.  

The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

D.  

Users who are trying to use the warehouse will receive an error message until the resizing is complete

A.  

Micro-partitions cannot overlap in their range of values

B.  

Micro-partitions are immutable objects that support the use of Time Travel.

C.  

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

D.  

Rows are automatically stored in sorted order within micro-partitions

E.  

Micro-partitions can be defined on a schema-by-schema basis

A.  

Materialized views

B.  

Sequences

C.  

Procedures

D.  

Tables

E.  

Secure User Defined Functions (UDFs)

A.  

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

B.  

Yes. because the compute resource is replaced in its entirety with a new compute resource.

C.  

No. because the size of the cache is independent from the warehouse size

D.  

Yes. became the new compute resource will no longer have access to the cache encryption key

A.  

CSV (Unzipped)

B.  

Parquet

C.  

CSV (Gzipped)

D.  

ORC

A.  

CREATE SHARE

B.  

ALTER WAREHOUSE

C.  

DROP ROLE

D.  

SHOW SCHEMAS

E.  

DESCRBE TABLE

A.  

The load HISTORY view

B.  

The Query history view

C.  

The show warehouses command

D.  

The WAREHOUSE_METERING__HISTORY View

E.  

The billing and usage tab in the Snowflake web Ul

A.  

COPY INTO

B.  

GET

C.  

WRITE

D.  

EXTRACT INTO

A.  

True

B.  

False

A.  

The ability to scale up warehouses

B.  

The use of warehouse auto scaling

C.  

The ability to resize warehouses

D.  

Use of multi-clustered warehouses

E.  

The use of warehouse indexing

A.  

It removes the last element of the outer array.

B.  

It removes the outer array structure and loads the records into separate table rows,

C.  

It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

D.  

It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

A.  

When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

B.  

Use the ENCODING file format option to change the encoding from the default UTF-8.

C.  

The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

D.  

By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

E.  

Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

A.  

The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

B.  

The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

C.  

The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

D.  

The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.