A.  

Bytes scanned

B.  

Bytes written to result

C.  

Partitions scanned

D.  

Partitions total

E.  

Percentage scanned from cache

A.  

To store actual data from external stages

B.  

To automatically expire file URLs for security

C.  

To manage user privileges and access control

D.  

To store file-level metadata about data files in a stage

A.  

CREATE SESSION POLICY

B.  

CREATE NETWORK RULE

C.  

CREATE SECURITY INTEGRATION

D.  

CREATE PASSWORD POLICY

A.  

ARRAY

B.  

BLOB

C.  

CLOB

D.  

JSON

E.  

VARIANT

A.  

Access history

B.  

Data classification

C.  

Dynamic Data Masking

D.  

Object tagging

A.  

DATABASE_STORAGE_USAGE_HISTORY

B.  

TABLE_STORAGE_METRICS

C.  

STORAGE_DAILY_HISTORY

D.  

STAGE STORAGE USAGE HISTORY

A.  

A separate database object that is used to store file-level metadata

B.  

An object layered on a stage that is used to store file-level metadata

C.  

A database object with grantable privileges for unstructured data tasks

D.  

A Snowflake table specifically designed for storing unstructured files

A.  

The temporary table will take precedence over the permanent table.

B.  

The permanent table will take precedence over the temporary table.

C.  

An error will say there cannot be two tables with the same name in a schema.

D.  

The table that was created most recently will take precedence over the older table.

A.  

Tags

B.  

Comments

C.  

Internal tokenization

D.  

Row access policies

A.  

Use clustering keys

B.  

Create materialized views

C.  

Use the search optimization service

D.  

Use the query acceleration service

A.  

ACCESS_HISTORY

B.  

COPY_HISTORY

C.  

QUERY_HISTORY

D.  

ROW ACCESS POLICIES

A.  

TO_CHAR

B.  

TO_VARIANT

C.  

TO_VARCHAR

D.  

STRIP NULL VALUE

A.  

Tag

B.  

Task

C.  

Stream

D.  

Stored procedure

A.  

Add and remove members.

B.  

Delete data categories.

C.  

Approve and deny listing approval requests.

D.  

Transfer listing ownership.

E.  

Transfer ownership of a provider profile.

A.  

File URL

B.  

Staged URL

C.  

Scoped URL

D.  

Pre-signed URL

A.  

SHOW

B.  

MERGE

C.  

INSERT

D.  

DELETE

E.  

DESCRIBE

A.  

Flatten the data and store it in structured data types in a flattened table. Query the table.

B.  

Store the data in a table with a variant data type. Query the table.

C.  

Store the data in a table with a vai : ant data type and include STRIP_NULL_VALUES while loading the table. Query the table.

D.  

Store the data in an external stage and create views on top of it. Query the views.

A.  

A single data type, with one or more conditions, and one or more masking functions

B.  

A single data type, with only one condition, and only one masking function

C.  

Multiple data types, with only one condition, and one or more masking functions

D.  

Multiple data types, with one or more conditions, and one or more masking functions

A.  

RETURN_-1_R0WS

B.  

RETURN_n_ROWS

C.  

RETURN_ERRORS

D.  

RETURN ALL ERRORS

A.  

Account

B.  

Database

C.  

Schema

D.  

Table

A.  

Column compression

B.  

Data clustering

C.  

Micro-partitioning

D.  

Metadata management

A.  

Automatic clustering

B.  

Materialized views

C.  

Query acceleration service

D.  

Search optimization service

A.  

Data Replication

B.  

Secure Data Sharing

C.  

Data Exchange

D.  

Snowflake Marketplace

A.  

Bytes scanned

B.  

Partitions scanned

C.  

Bytes spilled to local storage

D.  

Bytes spilled to remote storage

E.  

Percentage scanned from cache

A.  

Manually re-cluster the table regularly.

B.  

Choose one high cardinality column as the clustering key.

C.  

Use the column that is most-frequently used in query select clauses as the clustering key.

D.  

Assess the average table depth to identify how clustering is impacting the query.

A.  

Send an alert notification to all account users who have notifications enabled.

B.  

Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.

C.  

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.

D.  

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.

A.  

XML

B.  

JSON

C.  

Parquet

D.  

ORC

E.  

AVRO

F.  

CSV

A.  

Use data encryption.

B.  

Use dynamic data masking.

C.  

Use secure materialized views.

D.  

Revoke all roles for functional managers and end users.

A.  

Create a zero-copy clone of the worksheet and grant permissions to teammates

B.  

Create a private Data Exchange so that any teammate can use the worksheet

C.  

Share the worksheet with teammates within Snowsight

D.  

Create a database and grant all permissions to teammates

A.  

Avro

B.  

JSON

C.  

ORC

D.  

XML

E.  

Delimited (CSV, TSV, etc.)

A.  

90 days

B.  

1 day

C.  

7 days

D.  

45 days

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.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake

A.  

1 day

B.  

7 days

C.  

12 hours

D.  

0 days

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

A.  

There is no need to have a Snowflake account in the target region, a share will be created for each user.

B.  

The listing is replicated into all selected regions automatically, the data is not.

C.  

The user must have the ORGADMIN role available in at least one account to link accounts for replication.

D.  

Shares attached to listings in remote regions can be viewed from any account in an organization.

E.  

For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

A.  

Organize files into logical paths

B.  

Store the files on the external stage to ensure caching is maintained

C.  

Use pattern matching for regular expression execution

D.  

Load the data in one large file

A.  

Data is live, ready-to-query, and can be personalized.

B.  

Data needs to be loaded into a cloud provider as a consumer account.

C.  

Data is not available for copying or moving to an individual Snowflake account.

D.  

Data is available without copying or moving.

E.  

Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

A.  

JOIN

B.  

COPY INTO

C.  

PUT

D.  

GET

A.  

4

B.  

8

C.  

16

D.  

32

A.  

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

B.  

When the data cache is full, the least-recently used data will be cleared to make room.

C.  

A user can only access their own queries from the query result cache.

D.  

A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

E.  

The RESULT_SCAN table function can access and filter the contents of the query result cache.

A.  

Queries against large tables where frequent DML occurs

B.  

Queries against tables larger than 1 TB

C.  

Selective point lookup queries

D.  

Queries against a subset of columns in a table

A.  

Protegrity

B.  

Tableau

C.  

DBeaver

D.  

SAP

A.  

Row access policies

B.  

Data masking policies

C.  

Data encryption

D.  

Role based access control

A.  

VIEWS_HISTORY

B.  

OBJECT_HISTORY

C.  

ACCESS_HISTORY

D.  

LOGIN_HISTORY

A.  

Shared-disk

B.  

Shared-nothing

C.  

Multi-cluster shared data

D.  

Serverless query engine

A.  

When dropping an external stage, the files are not removed and only the stage is dropped

B.  

When dropping an external stage, both the stage and the files within the stage are removed

C.  

When dropping an internal stage, the files are deleted with the stage and the files are recoverable

D.  

When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

E.  

When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

A.  

Configure the warehouse to a size larger than generally required

B.  

Set the minimum and maximum clusters to autoscale

C.  

Use the standard warehouse scaling policy

D.  

Use the economy warehouse scaling policy

A.  

Role

B.  

Stream

C.  

Warehouse

D.  

External table

E.  

User

F.  

Share

A.  

Clustering

B.  

Materialized Views

C.  

Zero-copy Cloning

D.  

Search Optimization Service

A.  

Default Time Travel Retention is set to 0 days.

Maximum Time Travel Retention is 30 days.

Fail Safe retention time is 1 day.

B.  

Default Time Travel Retention is set to 1 day.

Maximum Time Travel Retention is 365 days.

Fail Safe retention time is 7 days.

C.  

Default Time Travel Retention is set to 0 days.

Maximum Time Travel Retention is 90 days.

Fail Safe retention time is 7 days.

D.  

Default Time Travel Retention is set to 1 day.

Maximum Time Travel Retention is 90 days.

Fail Safe retention time is 7 days.

E.  

Default Time Travel Retention is set to 7 days.

Maximum Time Travel Retention is 1 day.

Fail Safe retention time is 90 days.

F.  

Default Time Travel Retention is set to 90 days.

Maximum Time Travel Retention is 7 days.

Fail Safe retention time is 356 days.

A.  

Custom Edition

B.  

Virtual Private Snowflake

C.  

Business Critical Edition

D.  

Standard Edition

E.  

Enterprise Edition

A.  

Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

B.  

The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

C.  

SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

D.  

A user cannot specify a default warehouse when using the ODBC driver.

E.  

The default virtual warehouse size can be changed at any time.

A.  

4 minutes

B.  

10 minutes

C.  

14 minutes

D.  

24 minutes

A.  

The USERS view in ACCOUNT_USAGE

B.  

The LOGIN_HISTORY view in ACCOUNT_USAGE

C.  

The ACCESS_HISTORY view in ACCOUNT_USAGE

D.  

The SESSIONS view in ACCOUNT_USAGE

A.  

The explain plan output is available graphically.

B.  

An explain plan can be used to conduct performance analysis without executing a query.

C.  

An explain plan will handle queries with temporary tables and the query profiler will not.

D.  

An explain plan's output will display automatic data skew optimization information.

A.  

The data is cloned into a historical object.

B.  

The data moves to Fail-safe

C.  

Time Travel on the historical data is dropped.

D.  

The object containing the historical data is dropped.

A.  

Fail-safe makes data available up to 1 day, recoverable by user operations.

B.  

Fail-safe makes data available for 7 days, recoverable by user operations.

C.  

Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

D.  

Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

A.  

list @mytable;

B.  

list @%raytable;

C.  

list @ %m.ystage;

D.  

list @mystage;

A.  

As configured in the create pipe settings

B.  

Until the pipe is dropped

C.  

64 days

D.  

14 days

A.  

CSV

B.  

JSON

C.  

Parquet

D.  

XML

A.  

Set SINGLE: = true for larger files

B.  

Use OBJECT_CONSTRUCT ( * ) when using Parquet

C.  

Avoid the use of the CAST function

D.  

Define an individual file format

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.  

Yes, because a table owner has full control and can unset masking policies.

B.  

Yes, because masking policies only apply to cloned tables.

C.  

No, because masking policies must always reference specific access roles.

D.  

No, because ownership of a table does not include the ability to change masking policies

A.  

Customer-managed encryption keys through Tri-Secret Secure

B.  

Automatic encryption of all data

C.  

Up to 90 days of data recovery through Time Travel

D.  

Object-level access control

E.  

Column-level security to apply data masking policies to tables and views

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.  

True

B.  

False

A.  

STATEMENT_TIMEOUT__IN__SECONDS

B.  

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

C.  

MAX_CONCURRENCY__LEVEL

D.  

QUERY_TIMEOUT_IN_SECONDS

A.  

Zero-copy cloning creates a mirror copy of a database that updates with the original

B.  

Software updates are automatically applied on a quarterly basis

C.  

Snowflake eliminates resource contention with its virtual warehouse implementation

D.  

Multi-cluster warehouses allow users to run a query that spans across multiple clusters

E.  

Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

A.  

LOAD

B.  

copy

C.  

GET

D.  

PUT

A.  

Pipe

B.  

External stage

C.  

Task

D.  

Stream

A.  

Materialized views

B.  

Sequences

C.  

Procedures

D.  

Tables

E.  

Secure User Defined Functions (UDFs)

A.  

Column-level security

B.  

SOC 2 type II certification

C.  

Multi-factor Authentication (MFA)

D.  

Object-level access control

A.  

A User Defined Function (UDF)

B.  

A stored procedure

C.  

A single copy_into statement

D.  

A single insert__into statement

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.  

Infrastructure management

B.  

Metadata management

C.  

Query execution

D.  

Query parsing and optimization

E.  

Management of the storage layer

A.  

Data can be filtered by an optional where clause

B.  

Incoming data can be joined with other tables

C.  

Columns can be reordered

D.  

Columns can be omitted

E.  

Row level access can be defined

A.  

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

B.  

Clustering keys sort the designated columns over time, without blocking DML operations

C.  

Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

D.  

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

A.  

30 Days

B.  

60 Days

C.  

90 Days

D.  

365 Days

A.  

ROLEADMIN

B.  

ACCOUNTADMIN

C.  

SYSADMIN

D.  

SECURITYADMIN

E.  

USERADMIN

A.  

ACCOUNTADMIN

B.  

ORGADMIN

C.  

SECURITYADMIN

D.  

SYSADMIN

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.  

SCIM

B.  

Federated authentication

C.  

TLS 1.2

D.  

Key-pair authentication

E.  

OAuth

F.  

OCSP authentication

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 another warehouse is used to execute the query

B.  

When another user executes the query

C.  

When the underlying data has changed

D.  

When the warehouse used to execute the query is suspended

E.  

When it has been 24 hours since the last query

A.  

The table contains a column that has very low cardinality

B.  

DML statements that are being issued against the table are blocked

C.  

The table has a small number of micro-partitions

D.  

Queries on the table are running slower than expected

E.  

The clustering depth for the table is large

A.  

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME

FROM ACCOUNT_USAGE.USERS;

B.  

SELECT EVENT_TIMESTAMP, USER_NAME

FROM table(information_schema.login_history_by_user())

C.  

SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.ACCESS_HISTORY;

D.  

SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.LOGIN_HISTORY;

A.  

CREATE SHARE

B.  

ALTER WAREHOUSE

C.  

DROP ROLE

D.  

SHOW SCHEMAS

E.  

DESCRBE TABLE

A.  

SHOW TABLES command

B.  

SHOW EXTERNAL TABLES command

C.  

TABLES view

D.  

TABLE STORAGE METRICS view

A.  

GROUP BY

B.  

LIMIT

C.  

ORDER BY

D.  

PARTITION BY

E.  

UNION ALL

A.  

Binary file in Avro

B.  

Binary file in Parquet

C.  

Comma-separated JSON

D.  

Newline Delimited JSON

E.  

Plain text file containing XML elements

A.  

If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

B.  

If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

C.  

If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.

D.  

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.

E.  

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

A.  

1 hour

B.  

2 hours

C.  

4 hours

D.  

8 hours

A.  

Snowflake will resolve them according to the SEARCH_PATH parameter.

B.  

Snowflake will only check the schema the UDF belongs to.

C.  

Snowflake will first check the current schema, and then the schema the previous query used

D.  

Snowflake will first check the current schema, and them the PUBLIC schema of the current database.

A.  

UTF-8

B.  

UTF-16

C.  

ISO-8859-1

D.  

WINDOWS-1253

A.  

Worksheets can be grouped under folder, and a folder of folders.

B.  

Each worksheet is a unique Snowflake session.

C.  

Users are limited to running only one on a worksheet.

D.  

The Snowflake session ends when a user switches worksheets.

E.  

Users can import worksheets and share them with other users.

A.  

Data classification

B.  

Query acceleration service

C.  

Search optimization service

D.  

Tagging

A.  

A single-cluster shared data architecture using a central data repository and massively parallel processing (MPP)

B.  

A multi-duster shared nothing architecture using a soloed data repository and massively parallel processing (MPP)

C.  

A single-cluster shared nothing architecture using a sliced data repository and symmetric multiprocessing (SMP)

D.  

A multi-cluster shared nothing architecture using a siloed data repository and symmetric multiprocessing (SMP)

A.  

Syntax error

B.  

Inefficient pruning

C.  

Ambiguous column names

D.  

Queries too large to fit in memory

E.  

Object does not exist or not authorized

A.  

They are a set of rules that define the network routes within Snowflake.

B.  

They are a set of rules that dictate how Snowflake accounts can be used between multiple users.

C.  

They are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.

D.  

They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connect

to Snowflake.

A.  

Disaster recovery

B.  

Time Travel

C.  

Fail-safe

D.  

Database failover and fallback

E.  

Data security

A.  

The column name and element names are both case-sensitive.

B.  

The column name and element names are both case-insensitive.

C.  

The column name is case-sensitive but element names are case-insensitive.

D.  

The column name is case-insensitive but element names are case-sensitive.

A.  

There are multiple SOL UDFs with the same names and the same number of arguments.

B.  

There are multiple SQL UDFs with the same names and the same number of argument types.

C.  

There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.

D.  

There are multiple SQL UDFs with different names but the same number of arguments or argument types.

A.  

GRANT SEARCH OPTIMIZATION ON SCHEMA TO ROLE

B.  

GRANT SEARCH OPTIMIZATION ON DATABASE TO ROLE

C.  

GRANT ADD SEARCH OPTIMIZATION ON SCHEMA TO ROLE

D.  

GRANT ADD SEARCH OPTIMIZATION ON DATABASE TO ROLE

A.  

Temporary table

B.  

External table

C.  

Secure view

D.  

Materialized view

A.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake (VPS)

A.  

Clone the data from the production account to the non-production account.

B.  

Create a data share from the production account to the non-production account.

C.  

Create a subscription in the production account and have it publish to the non-production account.

D.  

Create a reader account using the production account and link the reader account to the non-production account.

A.  

TABLES

B.  

TABLE_STORAGE_METRICS

C.  

STORAGE_DAILY_HISTORY

D.  

STORAGE USAGE

A.  

Binary format

B.  

Columnar format

C.  

Compressed format

D.  

Raw format

E.  

Zipped format

A.  

Last_QUERY_ID

B.  

CURRENT_STATEMENT

C.  

UUID_STRING

D.  

JOB_ID

A.  

(12,2)

B.  

(10,4)

C.  

(14,8)

D.  

(15,9)

A.  

View

B.  

Secure view

C.  

Materialized view

D.  

External table

A.  

LIST

B.  

ALTER FILE FORMAT

C.  

DESCRIBE FILE FORMAT

D.  

SHOW FILE FORMATS

A.  

1

B.  

5

C.  

10

D.  

100

A.  

A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.

B.  

A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

C.  

A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.

D.  

Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

A.  

GET_STATE_LOCATION

B.  

GET_PRESENT_URL

C.  

BUILD_SCOPED_FILE_URL

D.  

BUILD_STAGE_FILE_URL

A.  

Use the SECURITYADMIN role.

B.  

Use the SYSADMIN role.

C.  

Use the USERADMIN role.

D.  

Contact Snowflake Support.

A.  

FLATTEN

B.  

CHECK_JSON

C.  

PARSE_JSON

D.  

TO_VARIANT

A.  

0 days

B.  

1 day

C.  

7 days

D.  

14 days

A.  

O days

B.  

1 day

C.  

7 days

D.  

90 days

A.  

Stored procedures can execute database operations while UDFs cannot.

B.  

Returning a value is required in a stored procedure while returning values in a UDF is optional.

C.  

Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.

D.  

Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.

A.  

60

B.  

91

C.  

120

D.  

121

A.  

Schema Stage

B.  

User Stage

C.  

Database Stage

D.  

Table Stage

E.  

External Named Stage

F.  

Internal Named Stage

A.  

A VARIANT column

B.  

A column with very low cardinality

C.  

A column with very high cardinality

D.  

A column that is most actively used in selective filters

E.  

A column that is most actively used in join predicates

A.  

Authy

B.  

Duo Security

C.  

One Login

D.  

RSA SecurlD Access

A.  

Caching query results

B.  

Running EXPLAIN and SHOW commands

C.  

Cloning a database

D.  

Running a custom query

E.  

Running COPY commands

A.  

Analyze query performance.

B.  

Write queries and execute them.

C.  

Provide an overview of the listings in the Snowflake Marketplace.

D.  

Connect to Snowflake partners to explore extended functionality.

A.  

It does not retain any privileges granted on the source object.

B.  

It replicates all granted privileges on the corresponding source objects.

C.  

It replicates all granted privileges on the corresponding child objects.

D.  

It replicates all granted privileges on the corresponding child schema objects.

A.  

Reorder the rows in a relational table and then unload the rows into a file

B.  

Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.

C.  

Reorder the data columns according to a target table definition and then unload the rows into the table.

D.  

Convert the rows in a source file to a single variant column and then load the rows from the file to a variant table.