SnowPro-Core Practice Question and Answers

A.  

Data is hashed by the cluster key to facilitate fast searches for common data values

B.  

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

C.  

Smaller micro-partitions are created for common data values to allow for more parallelism

D.  

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

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.  

A Materialized View cannot support any aggregate functions

B.  

A Materialized View can only reference up to two tables

C.  

A Materialized View cannot be joined with other tables

D.  

A Materialized View cannot be defined with a JOIN

A.  

ACCOUNTADMIN

B.  

ORGADMIN

C.  

SECURITYADMIN

D.  

SYSADMIN

A.  

A User Defined Function (UDF)

B.  

A stored procedure

C.  

A single copy_into statement

D.  

A single insert__into statement

A.  

Bytes scanned

B.  

Bytes sent over the network

C.  

Number of partitions scanned

D.  

Percentage scanned from cache

E.  

External bytes scanned

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.  

All data from all of the files on the stage will be appended to the table

B.  

Only data about new customers from the new files will be appended to the table

C.  

The operation will fail with the error uncertain files in stage.

D.  

All data from only the newly-added files will be appended to the table.

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.  

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.  

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.  

Snowflake parameters

B.  

Micro-partitions

C.  

Query history

D.  

Persisted query results

E.  

Standard and secure view results

A.  

Each Snowflake account can be hosted in a different cloud vendor and region.

B.  

Each Snowflake account must be hosted in a different cloud vendor and region

C.  

All Snowflake accounts must be hosted in the same cloud vendor and region

D.  

Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

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.  

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.  

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.  

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.  

Gathering the hourly credit usage for an account

B.  

Compiling an account's average cloud services cost over the previous month

C.  

Summarizing the throughput of Snowpipe costs for an account

D.  

Calculating the funds left on an account's contract

A.  

Custom Edition

B.  

Virtual Private Snowflake

C.  

Business Critical Edition

D.  

Standard Edition

E.  

Enterprise Edition

A.  

STRIP_NULL_VALUES

B.  

SKIP_BYTE_ORDER_MARK

C.  

REPLACE_INVALID_CHARACTERS

D.  

VALIDATION_MODE

A.  

True

B.  

False

A.  

CHECK_OPTION

B.  

IS_SECURE

C.  

IS_UPDATEABLE

D.  

TABLE_NAME

A.  

@

B.  

&

C.  

$

D.  

#

A.  

The Data Consumer pays for data storage as well as for data computing.

B.  

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

C.  

A Snowflake account can both provide and consume shared data.

D.  

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

E.  

The Data Consumer pays only for compute resources to query the shared data.

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.  

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.  

1 second

B.  

60 seconds

C.  

5 minutes

D.  

60 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.  

parse_json()

B.  

json_extract_path_text()

C.  

object_construct()

D.  

flatten

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.  

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.  

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.  

JOIN

B.  

COPY INTO

C.  

PUT

D.  

GET

A.  

CONTENT

B.  

PATH

C.  

BYTE_SIZE

D.  

INDEX

E.  

DATATYPE

A.  

Compute resources

B.  

Query execution

C.  

Authentication

D.  

Data storage

E.  

Metadata

A.  

COPY INTO

B.  

CREATE PIPE

C.  

INSERT INTO

D.  

TABLE STREAM

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.  

Automatically creates a File Format object

B.  

Automatically uses the last Stage created

C.  

Automatically compresses files using Gzip

D.  

Automatically encrypts files

A.  

Database

B.  

Tables

C.  

Warehouses

D.  

Worksheets

A.  

Tables

B.  

Schemas

C.  

Databases

D.  

Stages

A.  

True

B.  

False

A.  

INITTIALLY_SUSPENDED = TRUE/FALSE

B.  

START_AFTCR_CREATE = TRUE/FALSE

C.  

START_TTIME = 60 // (seconds from now)

D.  

START.TIME = CURRENT.DATE()

A.  

1 Hour

B.  

3 Hours

C.  

12 hours

D.  

24 hours

A.  

UPDATE

B.  

INSERT

C.  

MERGE

D.  

COPY

A.  

True

B.  

False

A.  

Temporary Tables

B.  

Transient Tables

C.  

Provisional Tables

D.  

Permanent Tables

A.  

On-premise availability

B.  

Simplicity

C.  

Open source based

D.  

Concurrency

E.  

Performance

A.  

True

B.  

False

A.  

True

B.  

False

A.  

Micro-partitions

B.  

Clustering keys

C.  

Key partitions

D.  

Clustered partitions

A.  

True

B.  

False

A.  

Quick provisioning of Dev and Test/QA environments

B.  

Data backups

C.  

Point in time snapshots

D.  

Performance optimization

A.  

True

B.  

False

A.  

True

B.  

False

A.  

Configure the Maximum Clusters setting to “Auto-Scale”

B.  

Set the Warehouse type to “Auto”

C.  

Set the Minimum Clusters and Maximum Clusters settings to the same value

D.  

Set the Minimum Clusters and Maximum Clusters settings to the different values

A.  

Through the Snowflake web interface (Ul)

B.  

Through the DATA_SHARE=TRUE parameter

C.  

Through SQL commands

D.  

Through the enable__share=true parameter

E.  

Using the CREATE SHARE AS SELECT * TABLE command

A.  

True

B.  

False

A.  

True

B.  

False

A.  

ROLES

B.  

POLICY_REFERENCES

C.  

QUERY_HISTORY

D.  

RESOURCE_MONIT ORS

E.  

ACCESS_HISTORY

A.  

As configured in the create pipe settings

B.  

Until the pipe is dropped

C.  

64 days

D.  

14 days

A.  

Masking policy

B.  

Stored procedure

C.  

Task

D.  

External table