A.  

Table definition

B.  

Stage definition

C.  

Session level

D.  

COPY INTO TABLE statement

A.  

Configure 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 user's access to expire within a specified timeframe.

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.

A.  

The clone always stays in sync with the original table.

B.  

The clone has better query performance.

C.  

The clone is created almost instantly.

D.  

The clone will have time travel history from the original table.

E.  

The clone saves space by not duplicating storage.

A.  

ACCESS_HOSTORY

B.  

LOGIN_HISTORY

C.  

SESSIONS

D.  

QUERY HISTORY

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.  

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.  

Data Storage

B.  

Compute

C.  

Cloud Services

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.  

When using a paid listing on the Snowflake Marketplace

B.  

When using a private listing on the Snowflake Marketplace

C.  

When using a personalized listing on the Snowflake Marketplace

D.  

When using a Direct Share with another account

A.  

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

B.  

An error will occur, as views with qualified references cannot be cloned.

C.  

An error will occur, as stored objects cannot be cloned.

D.  

The stored procedures and views will refer to tables in the source database.

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.  

4 minutes

B.  

10 minutes

C.  

14 minutes

D.  

24 minutes

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.  

Cloud services layer

B.  

Compute layer

C.  

Storage layer

D.  

Cloud agnostic layer

A.  

NUMBER

B.  

OBJECT

C.  

STRING

D.  

VARCHAR

E.  

VARIANT

A.  

Caching query results

B.  

Running EXPLAIN and SHOW commands

C.  

Cloning a database

D.  

Running a custom query

E.  

Running COPY commands

A.  

Enterprise

B.  

Business Critical

C.  

Standard

D.  

Virtual Private Snowflake

A.  

10

B.  

50

C.  

64

D.  

256

A.  

The warehouse size does not change until all queries currently running in the warehouse have completed.

B.  

The warehouse size does not change until all queries currently in the warehouse queue have completed.

C.  

The warehouse size does not change until the warehouse is suspended and restarted.

D.  

It does not return from the command until the warehouse has finished changing its size.

A.  

READ

B.  

OWNERSHIP

C.  

USAGK

D.  

WRTTF

A.  

GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

B.  

GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYD

B.  

C.  

GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K"-'SCHEMA TO USER! ;

D.  

GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

A.  

Scale up the virtual warehouse.

B.  

Scale out the virtual warehouse.

C.  

Enable standard warehouse scaling.

D.  

Enable economy warehouse scaling.

A.  

Enable the data sharing feature in the account and validate the view.

B.  

Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.

C.  

Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.

D.  

Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.

A.  

list @bronzestage;

B.  

select * from directory(@bronzestage);

C.  

select metadata$filename from @bronzestage;

D.  

select * from table(information_schema.stage_directory_file_registration_history(

stage name=>'bronzestage1));

A.  

Swift

B.  

JavaScript

C.  

Python

D.  

SQL

A.  

CHECK_JSON

B.  

TO_JSON

C.  

FLATTEN

D.  

PARSE_JSON

A.  

When users will be using compute at different times throughout a 24/7 period

B.  

When managing a steady workload

C.  

When the compute must be available with no delay or lag time

D.  

When the user does not want to have to manually turn on the warehouse each time it is needed

E.  

When the warehouse is shared across different teams

A.  

SHOW MASKING POLICIES

B.  

DESCRIBE MASKING POLICY

C.  

GET_DDL

D.  

LIST MASKING POLICIES

A.  

A User-Defined Table Function (UDTF)

B.  

A Scalar User Function (UDF)

C.  

A stored procedure

D.  

A task

A.  

Account and user authentication is only available with the Snowflake Business Critical edition.

B.  

Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

C.  

Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

D.  

Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

A.  

The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.

B.  

Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

C.  

The clustering key must be included in the COPY command when loading data into Snowflake.

D.  

Clustering can be disabled within a Snowflake account.

A.  

Schema Stage

B.  

User Stage

C.  

Database Stage

D.  

Table Stage

E.  

External Named Stage

F.  

Internal Named Stage

A.  

Create a view.

B.  

Cluster a table.

C.  

Enable the search optimization service.

D.  

Enable Time Travel.

E.  

Index a table.

A.  

IMPORT SHARE

B.  

OWNERSHIP

C.  

REFERENCES

D.  

USAGE

A.  

SnowCD

B.  

Snowpark

C.  

Snowsight

D.  

SnowSQL

A.  

SnowCLI

B.  

SnowUI

C.  

SnowSQL

D.  

SnowCD

A.  

Query execution

B.  

Data loading

C.  

Time Travel data

D.  

Security

E.  

Authentication and access control

A.  

BINARY

B.  

GEOGRAPHY

C.  

GEOMETRY

D.  

OBJECT

E.  

VARIANT

A.  

Into single files with 100-250 MB of compressed data per file

B.  

Into single files with 1-100 MB of compressed data per file

C.  

Into files of maximum size of 1 GB of compressed data per file

D.  

Into files of maximum size of 4 GB of compressed data per file

A.  

ACCOUNTADMIN

B.  

SECURITYADMIN

C.  

SYSADMIN

D.  

ORGADMIN

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.  

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.  

Temporary table

B.  

External table

C.  

Secure view

D.  

Materialized view

A.  

SINGLE=TRUE

B.  

MULTIPLE=TRUE

C.  

MULTIPLE=FALSE

D.  

SINGLE=FALSE

A.  

Amazon Web Services

B.  

Docker

C.  

IBM Cloud

D.  

Microsoft Azure Cloud

E.  

Google Cloud Platform

F.  

Oracle Cloud

A.  

Compress the file and load the compressed file.

B.  

Split the file into multiple files in the recommended size range (100 MB - 250 MB).

C.  

Use a larger-sized warehouse.

D.  

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

A.  

BINARY_FORMAT

B.  

ESCAPE_UNENCLOSED_FIELD

C.  

FIELD_OPTIONALLY_ENCLOSED_BY

D.  

SKIP BYTE ORDER MARK

A.  

Add or remove users from a worksheet.

B.  

Move a worksheet to a folder or a dashboard.

C.  

Combine multiple worksheets into a single worksheet.

D.  

Tag frequently accessed worksheets for ease of access.

A.  

TEXT

B.  

BINARY

C.  

STRING

D.  

VARIANT

A.  

ARRAY_AGG

B.  

OBJECT_AGG

C.  

ARRAY_CONSTRUCT

D.  

OBJECT_CONSTRUCT

A.  

Last_QUERY_ID

B.  

CURRENT_STATEMENT

C.  

UUID_STRING

D.  

JOB_ID

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.  

GET_STATE_LOCATION

B.  

GET_PRESENT_URL

C.  

BUILD_SCOPED_FILE_URL

D.  

BUILD_STAGE_FILE_URL

A.  

COPY INTO

B.  

GET

C.  

INSERT INTO

D.  

PUT

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.  

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;

A.  

SYSTEMADMIN_TAG

B.  

SYSTEM$GET_PRIVATELINK

C.  

SYSTEMSALLONTLIST

D.  

SYSTEMAUTHORIZE

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.  

The data from the permanent table.

B.  

The data from the temporary table.

C.  

An error stating that the view could not be compiled.

D.  

An error stating that the referenced object could not be uniquely identified.

A.  

ARRAY

B.  

OBJECT

C.  

VARCHAR

D.  

VARIANT

A.  

Modify the columns in the underlying table

B.  

Use the ALTER VIEW command to update the view

C.  

Recreate the view with the required changes

D.  

Materialize the view to perform the changes

A.  

If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

B.  

A Data Exchange allows groups of accounts to share data privately among the accounts.

C.  

A Data Exchange allows accounts to share data with third, non-Snowflake parties.

D.  

Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

E.  

The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

A.  

INTERSECT

B.  

MFRCK

C.  

MINUS

D.  

UNION

A.  

Warehouses that are multi-cluster can have nodes of different sizes.

B.  

Warehouses can be started and stopped at any time.

C.  

Warehouses can be resized at any time, even while running.

D.  

Warehouses are billed on a per-minute usage basis.

E.  

Warehouses can only be used for querying and cannot be used for data loading.

A.  

ARRAY

B.  

BLOB

C.  

CLOB

D.  

JSON

E.  

VARIANT

A.  

CREATE TABLE LIKE TABLE_A;

B.  

CREATE VIEW AS SELECT * FROM TABLE_A;

C.  

CREATE TABLE AS SELECT * FROM TABLE_A;

D.  

CREATE MATERIALIZED VIEW AS SELECT * FROM TABLE A;

A.  

Use clustering keys

B.  

Create materialized views

C.  

Use the search optimization service

D.  

Use the query acceleration service

A.  

Account

B.  

Database

C.  

Schema

D.  

Table

A.  

INTEGER

B.  

OBJECT

C.  

VARIANT

D.  

VARCHAR

E.  

LIST

A.  

TO_OBJECT

B.  

TO_JSON

C.  

TO_VARIANT

D.  

OBJECT CONSTRUCT

A.  

The user will be unable to enter a password.

B.  

The user will encounter an error, and will not be able to log in.

C.  

The user will be able to log into Snowflake successfully.

D.  

After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.

A.  

USAGE_VIEWER

B.  

GOVERNANCE_VIEWER

C.  

OBJECT_VIEWER

D.  

SECURITY_VIEWER

A.  

Insert a colon (:) between the VARIANT column name and any first-level element.

B.  

Insert a colon (:) between the VARIANT column name and any second-level element. C. Insert a double colon (: :) between the VARIANT column name and any first-level element.

C.  

Insert a double colon (: :) between the VARIANT column name and any second-level element.

A.  

MONITOR

B.  

OPERATE

C.  

OWNERSHIP

D.  

D.  

A.  

Enable Time Travel.

B.  

Clone the dropped stage.

C.  

Execute the UNDROP command.

D.  

Recreate the dropped stage.

A.  

SQL functions like the GET command can be used to copy the unstructured data to a location on the client.

B.  

SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.

C.  

SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.

D.  

SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.

A.  

Temporary tables

B.  

Permanent tables

C.  

Transient tables

D.  

External tables

E.  

User-Defined Table Functions (UDTFs)

A.  

The account type

B.  

The storage file format

C.  

The cloud region used by the account

D.  

The type of data being stored

E.  

The cloud platform being used

A.  

Range of values

B.  

Distinct values

C.  

Index values

D.  

Sorted values

E.  

Null values

A.  

Automatic clustering

B.  

Materialized views

C.  

Query acceleration service

D.  

Search optimization service

A.  

GET_PRESIGNED_URL

B.  

GET_ABSOLUTE_PATH

C.  

BUILD_STAGE_FILE_URL

D.  

BUILD SCOPED FILE URL

A.  

All child objects will retain data for the new retention period.

B.  

All child objects that do not have an explicit retention period will automatically inherit the new retention period.

C.  

All child objects with an explicit retention period will be overridden with the new retention period.

D.  

All explicit child object retention periods will remain unchanged.

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.  

Queries without filters or aggregation

B.  

Queries with large scans and selective filters

C.  

Queries where the GROUP BY has high cardinality

D.  

Queries of tables that have search optimization service enabled

A.  

SHOW

B.  

MERGE

C.  

INSERT

D.  

DELETE

E.  

DESCRIBE

A.  

Data Replication

B.  

Secure Data Sharing

C.  

Data Exchange

D.  

Snowflake Marketplace

A.  

Secure view

B.  

Materialized view

C.  

Temporary table

D.  

Transient table

A.  

RETURN_-1_R0WS

B.  

RETURN_n_ROWS

C.  

RETURN_ERRORS

D.  

RETURN ALL ERRORS

A.  

CREATE SESSION POLICY

B.  

CREATE NETWORK RULE

C.  

CREATE SECURITY INTEGRATION

D.  

CREATE PASSWORD POLICY

A.  

The objects are dropped.

B.  

The objects enter the Fail-safe period.

C.  

The objects enter the Time Travel period.

D.  

The objects are immediately moved to the provider account.

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.  

To count the number of characters in a string

B.  

To split a string into an array of sub-strings

C.  

To split a string and flatten the results into rows

D.  

To split a string and flatten the results into columns

A.  

Views

B.  

Materialized views

C.  

Tables

D.  

External tables

E.  

Future grants

A.  

1 hour

B.  

2 hours

C.  

4 hours

D.  

8 hours

A.  

Data:employee.name

B.  

DATA:employee.name

C.  

data:Employee.name

D.  

data:employee.name

A.  

Materialized views do not allow joins.

B.  

Clones of materialized views can be created directly by the user.

C.  

Multiple tables can be joined in the underlying query of a materialized view.

D.  

Aggregate functions can be used as window functions in materialized views.

A.  

Column compression

B.  

Data clustering

C.  

Micro-partitioning

D.  

Metadata management

A.  

Operator tree

B.  

Table pruning

C.  

Most expensive nodes

D.  

Nodes by execution time

A.  

Tag

B.  

Task

C.  

Stream

D.  

Stored procedure

A.  

Access history

B.  

Data classification

C.  

Dynamic Data Masking

D.  

Object tagging

A.  

Standard Edition

B.  

Enterprise Edition

C.  

Business Critical Edition

D.  

Virtual Private Snowflake Edition

A.  

list @file__stage

B.  

show @file__stage

C.  

view @file__stage

D.  

verify @file__stage

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.  

Load files that are approximately 25 MB or smaller.

B.  

Remove all dates and timestamps.

C.  

Load files that are approximately 100-250 MB (or larger)

D.  

Avoid using embedded characters such as commas for numeric data types

E.  

Remove semi-structured data types

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.  

Clustering

B.  

Indexing

C.  

Fragmenting

D.  

Using INDEX__HINTS

A.  

Compute layer

B.  

Storage layer

C.  

Cloud infrastructure layer

D.  

Cloud services layer

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.  

Cluster keys

B.  

Time Travel

C.  

Fail-safe

D.  

Cloning

A.  

Standard Edition

B.  

Enterprise Edition

C.  

Business Critical Edition

D.  

Virtual Private Snowflake Edition

A.  

ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

B.  

GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

C.  

GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

D.  

GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

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.  

list @mytable;

B.  

list @%raytable;

C.  

list @ %m.ystage;

D.  

list @mystage;

A.  

show grants to user USER1;

B.  

show grants of user USER1;

C.  

describe user USER1;

D.  

show grants on user USER1;

A.  

Column-level security

B.  

SOC 2 type II certification

C.  

Multi-factor Authentication (MFA)

D.  

Object-level access control

A.  

True

B.  

False

A.  

Pipes

B.  

Streams

C.  

Tasks

D.  

D.  

A.  

The primary cluster in the virtual warehouse

B.  

The entire virtual warehouse

C.  

The database in which the virtual warehouse resides

D.  

The Queries currently being run on the virtual warehouse

A.  

Materialized views

B.  

Sequences

C.  

Procedures

D.  

Tables

E.  

Secure User Defined Functions (UDFs)

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.  

Snowflake parameters

B.  

Micro-partitions

C.  

Query history

D.  

Persisted query results

E.  

Standard and secure view results

A.  

CSV (Unzipped)

B.  

Parquet

C.  

CSV (Gzipped)

D.  

ORC

A.  

True

B.  

False

A.  

SINGLE=TRUE

B.  

MAX_FILE_NUMBER=1

C.  

FILE_NUMBER=1

D.  

MULTIPLE=FAISE

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.  

SnowSQL

B.  

Snowflake classic web interface (Ul)

C.  

Snowsight

D.  

.NET driver

A.  

CREATE SHARE

B.  

ALTER WAREHOUSE

C.  

DROP ROLE

D.  

SHOW SCHEMAS

E.  

DESCRBE TABLE

A.  

Execute a COPY command

B.  

Updating data

C.  

Snowpipe

D.  

AUTOMATIC__CLUSTERING

E.  

Scaling up a warehouse

A.  

30 Days

B.  

60 Days

C.  

90 Days

D.  

365 Days

A.  

1 day

B.  

7 days

C.  

45 days

D.  

90 days

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.  

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.  

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.  

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.  

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.  

Metadata cache

B.  

Result cache

C.  

Remote cache

D.  

Local file cache

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.  

Database stage

B.  

External stage

C.  

Table stage

D.  

User stage

A.  

UTF-8

B.  

UTF-16

C.  

ISO S859-1

D.  

ANSI_X3.A

A.  

VARIANT

B.  

VARRAY

C.  

STRUCT

D.  

ARRAY

E.  

QUEUE

A.  

To validate external table files in table t1 across all sessions

B.  

To validate task SQL statements against table t1 in the last 14 days

C.  

To validate a file for errors before it gets executed using a COPY command

D.  

To return errors from the last executed COPY command into table t1 in the current session

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.  

5 MB

B.  

8 GB

C.  

16 MB

D.  

32 MB

A.  

Optimizes the virtual warehouse size and multi-cluster setting to economy mode

B.  

Allows a user to import the files in a sequential order

C.  

Increases the latency staging and accuracy when loading the data

D.  

Allows optimization of parallel operations

A.  

view @my_stage

B.  

list @my_stage

C.  

show @my_stage

D.  

display @my_stage

A.  

1 day

B.  

7 days

C.  

12 hours

D.  

0 days

A.  

To create separate data warehouses to increase query optimization

B.  

To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

C.  

To eliminate or reduce Queuing of concurrent queries

D.  

To allow the warehouse to resize automatically

A.  

Clustering

B.  

Materialized Views

C.  

Zero-copy Cloning

D.  

Search Optimization Service

A.  

Business Critical Edition

B.  

Standard Edition

C.  

Virtual Private Snowflake (VPS)

D.  

Enterprise Edition

A.  

Role

B.  

Schema

C.  

User

D.  

Database

E.  

Account

F.  

Tables

A.  

Per second multiplied by an automatic sizing for the job

B.  

Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

C.  

Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter

D.  

Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

A.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake

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.  

Protegrity

B.  

Tableau

C.  

DBeaver

D.  

SAP

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.  

Those IP addresses are allowed access to the Snowflake account as Snowflake applies the allowed IP address list first.

B.  

Those IP addresses are denied access lei the Snowflake account as Snowflake applies the blocked IP address list first.

C.  

Snowflake issues an alert message and adds the duplicate IP address values lo both 'he allowed and blocked IP address lists.

D.  

Snowflake issues an error message and adds the duplicate IP address values to both the allowed and blocked IP address list

A.  

Use the SHOW STAGES command.

B.  

Use the DESCRIBE STAGE command.

C.  

Use the GET_ABSOLUTE_PATH function.

D.  

Use the GET_STAGE_LOCATION function.

A.  

UTF-8

B.  

UTF-16

C.  

ISO-8859-1

D.  

WINDOWS-1253

A.  

ARRAY

B.  

CHARACTER

C.  

STRING

D.  

VARCHAR

E.  

VARIANT

A.  

MODIFY

B.  

READ

C.  

SELECT

D.  

USAGE

A.  

LIST

B.  

ALTER FILE FORMAT

C.  

DESCRIBE FILE FORMAT

D.  

SHOW FILE FORMATS

A.  

1

B.  

5

C.  

10

D.  

100

A.  

GROUP BY

B.  

LIMIT

C.  

ORDER BY

D.  

PARTITION BY

E.  

UNION ALL

A.  

Cloud services

B.  

Query processing

C.  

Elastic memory

D.  

Database storage

A.  

ACCOUNTADMIN

B.  

SECURITYADMIN

C.  

SYSADMIN

D.  

ORGADMIN

A.  

Disjuncts (OR) in join predicates

B.  

LIKE/ILIKE/RLIKE join predicates

C.  

Join predicates on VARIANT columns

D.  

Conjunctions (AND) of multiple equality predicates

A.  

1 hour

B.  

2 hours

C.  

4 hours

D.  

8 hours

A.  

The provisioning of new compute resources for the warehouse will begin immediately.

B.  

The warehouse will remain suspended but new resources will be added to the query acceleration service.

C.  

The provisioning of additional compute resources will be in effect when the warehouse is next resumed.

D.  

The warehouse will resume immediately and start to share the compute load with other running virtual warehouses.

A.  

0 days

B.  

1 day

C.  

7 days

D.  

90 days

A.  

User stage

B.  

Table stage

C.  

Named internal stage

D.  

Named external stage

A.  

Hierarchical key model

B.  

Client-side encryption

C.  

Tri-secret secure encryption

D.  

Key pair authentication

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.  

SHOW TABLES command

B.  

SHOW EXTERNAL TABLES command

C.  

TABLES view

D.  

TABLE STORAGE METRICS view

A.  

Binary format

B.  

Columnar format

C.  

Compressed format

D.  

Raw format

E.  

Zipped format

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.  

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.  

The access to a single table

B.  

The access to data stored in stage objects

C.  

The list of values provided with the VALUES clause

D.  

The records generated using the TABLE (GENERATOR (...)) construct

A.  

If User2 has the sysadmin role they will be able to see the results.

B.  

If User2 has the securityadmin role they will be able to see the results.

C.  

If User2 has the ACCOUNTADMIN role they will be able to see the results.

D.  

User2 will be unable to view the result set of the query executed by User1.

A.  

Aggregate

B.  

Scalar

C.  

Table

D.  

Window

A.  

TASK_HISTORY

B.  

TASK_DEPENDENTS

C.  

CURRENT_TASK_GRAPHS

D.  

COMPLETE_TASK_GRAPHS

A.  

When the query contains multiple filters and no data is returned.

B.  

When a virtual warehouse runs out of memory while executing the query.

C.  

When the number of queries exceeds the max_concurrency_level parameter setting.

D.  

When running queries that exceed the statement_timecut_in_seccnds parameter setting.

A.  

Source_column.element[1]:name

B.  

Source_column.element[0]:name

C.  

Source_column.element[1].name

D.  

Source_column.element[0]:name