Summer Special Discount 60% Offer - Ends in 0d 00h 00m 00s - Coupon code: brite60

ExamsBrite Dumps

SnowPro Core Certification Exam Question and Answers

SnowPro Core Certification Exam

Last Update Oct 16, 2025
Total Questions : 605

We are offering FREE SnowPro-Core Snowflake exam questions. All you do is to just go and sign up. Give your details, prepare SnowPro-Core free exam questions and then go for complete pool of SnowPro Core Certification Exam test questions that will help you more.

SnowPro-Core pdf

SnowPro-Core PDF

$42  $104.99
SnowPro-Core Engine

SnowPro-Core Testing Engine

$50  $124.99
SnowPro-Core PDF + Engine

SnowPro-Core PDF + Testing Engine

$66  $164.99
Questions 1

Which statement about billing applies to Snowflake credits?

Options:

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

Discussion 0
Questions 2

What SQL command would be used to view all roles that were granted to user.1?

Options:

A.  

show grants to user USER1;

B.  

show grants of user USER1;

C.  

describe user USER1;

D.  

show grants on user USER1;

Discussion 0
Questions 3

What is a best practice after creating a custom role?

Options:

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

Discussion 0
Questions 4

Which of the following objects can be shared through secure data sharing?

Options:

A.  

Masking policy

B.  

Stored procedure

C.  

Task

D.  

External table

Discussion 0
Questions 5

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.

Which application will the Snowflake users need to install on their devices in order to connect with MFA?

Options:

A.  

Okta Verify

B.  

Duo Mobile

C.  

Microsoft Authenticator

D.  

Google Authenticator

Discussion 0
Questions 6

True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

Options:

A.  

True

B.  

False

Discussion 0
Questions 7

Which of the following describes external functions in Snowflake?

Options:

A.  

They are a type of User-defined Function (UDF).

B.  

They contain their own SQL code.

C.  

They call code that is stored inside of Snowflake.

D.  

They can return multiple rows for each row received

Discussion 0
Questions 8

What happens when a cloned table is replicated to a secondary database? (Select TWO)

Options:

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

Discussion 0
Questions 9

When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

Options:

A.  

1 hour

B.  

2 hours

C.  

4 hours

D.  

8 hours

Discussion 0
Questions 10

What factors impact storage costs in Snowflake? (Select TWO).

Options:

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

Discussion 0
Questions 11

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.

Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

Options:

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;

Discussion 0
Questions 12

When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

Options:

A.  

File URL

B.  

Scoped URL

C.  

Relative URL

D.  

Pre-Signed URL

Discussion 0
Questions 13

What step can reduce data spilling in Snowflake?

Options:

A.  

Using a larger virtual warehouse

B.  

Increasing the virtual warehouse maximum timeout limit

C.  

Increasing the amount of remote storage for the virtual warehouse

D.  

Using a common table expression (CTE) instead of a temporary table

Discussion 0
Questions 14

Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).

Options:

A.  

Bytes scanned

B.  

Partitions scanned

C.  

Bytes spilled to local storage

D.  

Bytes spilled to remote storage

E.  

Percentage scanned from cache

Discussion 0
Questions 15

What does a masking policy consist of in Snowflake?

Options:

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

Discussion 0
Questions 16

A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.

How can this be achieved?

Options:

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.

Discussion 0
Questions 17

What are the least privileges needed to view and modify resource monitors? (Select TWO).

Options:

A.  

SELECT

B.  

OWNERSHIP

C.  

MONITOR

D.  

MODIFY

E.  

USAGE

Discussion 0
Questions 18

Which commands are restricted in owner's rights stored procedures? (Select TWO).

Options:

A.  

SHOW

B.  

MERGE

C.  

INSERT

D.  

DELETE

E.  

DESCRIBE

Discussion 0
Questions 19

Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)

Options:

A.  

INTEGER

B.  

OBJECT

C.  

VARIANT

D.  

VARCHAR

E.  

LIST

Discussion 0
Questions 20

What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?

Options:

A.  

Access control

B.  

Fail-safe

C.  

Network policies

D.  

Time Travel

Discussion 0
Questions 21

Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?

Options:

A.  

OAuth

B.  

Network policies

C.  

Single Sign-On (SSO)

D.  

Multi-Factor Authentication (MFA)

Discussion 0
Questions 22

What metadata does Snowflake store for rows in micro-partitions? (Select TWO).

Options:

A.  

Range of values

B.  

Distinct values

C.  

Index values

D.  

Sorted values

E.  

Null values

Discussion 0
Questions 23

How is unstructured data retrieved from data storage?

Options:

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.

Discussion 0
Questions 24

A column named "Data" contains VARIANT data and stores values as follows:

How will Snowflake extract the employee's name from the column data?

Options:

A.  

Data:employee.name

B.  

DATA:employee.name

C.  

data:Employee.name

D.  

data:employee.name

Discussion 0
Questions 25

Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).

Options:

A.  

Bytes scanned

B.  

Bytes written to result

C.  

Partitions scanned

D.  

Partitions total

E.  

Percentage scanned from cache

Discussion 0
Questions 26

What does SnowCD help Snowflake users to do?

Options:

A.  

Copy data into files.

B.  

Manage different databases and schemas.

C.  

Troubleshoot network connections to Snowflake.

D.  

Write SELECT queries to retrieve data from external tables.

Discussion 0
Questions 27

For which use cases is running a virtual warehouse required? (Select TWO).

Options:

A.  

When creating a table

B.  

When loading data into a table

C.  

When unloading data from a table

D.  

When executing a show command

E.  

When executing a list command

Discussion 0
Questions 28

Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?

Options:

A.  

RETURN_-1_R0WS

B.  

RETURN_n_ROWS

C.  

RETURN_ERRORS

D.  

RETURN ALL ERRORS

Discussion 0
Questions 29

Which object can be used with Secure Data Sharing?

Options:

A.  

View

B.  

Materialized view

C.  

External table

D.  

User-Defined Function (UDF)

Discussion 0
Questions 30

Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).

Options:

A.  

A user with an USERADMIN or higher role

B.  

A user with a SECURITYADMIN or higher role

C.  

A role that has been granted the ATTACH POLICY privilege

D.  

A role that has the NETWORK_POLlCY account parameter set

E.  

A role that has the ownership of the network policy

Discussion 0
Questions 31

Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).

Options:

A.  

The separation allows independent scaling of computing resources.

B.  

The separation ensures consistent data encryption across all virtual data warehouses.

C.  

The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.

D.  

Storage volume growth and compute usage growth can be tightly coupled.

E.  

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

Discussion 0
Questions 32

Which type of loop requires a BREAK statement to stop executing?

Options:

A.  

FOR

B.  

LOOP

C.  

REPEAT

D.  

WHILE

Discussion 0
Questions 33

Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

Options:

A.  

CREATE STAGE

B.  

COPY INTO

C.  

COPY INTO

D.  

CREATE PIPE

Discussion 0
Questions 34

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

Options:

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.

Discussion 0
Questions 35

What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?

Options:

A.  

Standard Edition

B.  

Enterprise Edition

C.  

Business Critical Edition

D.  

Virtual Private Snowflake Edition

Discussion 0
Questions 36

How can a Snowflake user validate data that is unloaded using the COPY INTO command?

Options:

A.  

Load the data into a CSV file.

B.  

Load the data into a relational table.

C.  

Use the VALlDATlON_MODE - SQL statement.

D.  

Use the validation mode = return rows statement.

Discussion 0
Questions 37

Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?

Options:

A.  

Column compression

B.  

Data clustering

C.  

Micro-partitioning

D.  

Metadata management

Discussion 0
Questions 38

What is the purpose of the Snowflake SPLIT TO_TABLE function?

Options:

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

Discussion 0
Questions 39

What does a Notify & Suspend action for a resource monitor do?

Options:

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.

Discussion 0
Questions 40

While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

Options:

A.  

GET_PRESIGNED_URL

B.  

GET_ABSOLUTE_PATH

C.  

BUILD_STAGE_FILE_URL

D.  

BUILD SCOPED FILE URL

Discussion 0
Questions 41

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

Options:

A.  

An FTP server with TLS encryption

B.  

An HTTPS server with WebDAV

C.  

A Google Cloud storage bucket

D.  

A Windows server file share on Azure

Discussion 0
Questions 42

What feature can be used to reorganize a very large table on one or more columns?

Options:

A.  

Micro-partitions

B.  

Clustering keys

C.  

Key partitions

D.  

Clustered partitions

Discussion 0
Questions 43

Which cache type is used to cache data output from SQL queries?

Options:

A.  

Metadata cache

B.  

Result cache

C.  

Remote cache

D.  

Local file cache

Discussion 0
Questions 44

Which Snowflake partner specializes in data catalog solutions?

Options:

A.  

Alation

B.  

DataRobot

C.  

dbt

D.  

Tableau

Discussion 0
Questions 45

A user needs to create a materialized view in the schema MYDB.MYSCHEMA.

Which statements will provide this access?

Options:

A.  

GRANT ROLE MYROLE TO USER USER1;

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

B.  

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYD

B.  

MYSCHEMA TO USER USER1;

C.  

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

D.  

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Discussion 0
Questions 46

Which Snowflake technique can be used to improve the performance of a query?

Options:

A.  

Clustering

B.  

Indexing

C.  

Fragmenting

D.  

Using INDEX__HINTS

Discussion 0
Questions 47

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Options:

A.  

Compute layer

B.  

Storage layer

C.  

Cloud infrastructure layer

D.  

Cloud services layer

Discussion 0
Questions 48

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

Options:

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

Discussion 0
Questions 49

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

Options:

A.  

True

B.  

False

Discussion 0
Questions 50

The fail-safe retention period is how many days?

Options:

A.  

1 day

B.  

7 days

C.  

45 days

D.  

90 days

Discussion 0
Questions 51

Which data type can be used to store geospatial data in Snowflake?

Options:

A.  

Variant

B.  

Object

C.  

Geometry

D.  

Geography

Discussion 0
Questions 52

What are value types that a VARIANT column can store? (Select TWO)

Options:

A.  

STRUCT

B.  

OBJECT

C.  

BINARY

D.  

ARRAY

E.  

CLOB

Discussion 0
Questions 53

What tasks can be completed using the copy command? (Select TWO)

Options:

A.  

Columns can be aggregated

B.  

Columns can be joined with an existing table

C.  

Columns can be reordered

D.  

Columns can be omitted

E.  

Data can be loaded without the need to spin up a virtual warehouse

Discussion 0
Questions 54

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

Options:

A.  

Compute Credits = 50 Credits Cloud Services = 10

B.  

Compute Credits = 80 Credits Cloud Services = 5

C.  

Compute Credits = 10 Credits Cloud Services = 9

D.  

Compute Credits = 120 Credits Cloud Services = 10

E.  

Compute Credits = 200 Credits Cloud Services = 26

Discussion 0
Questions 55

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

Options:

A.  

SCIM

B.  

Federated authentication

C.  

TLS 1.2

D.  

Key-pair authentication

E.  

OAuth

F.  

OCSP authentication

Discussion 0
Questions 56

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

Which of the following statements will accommodate this request?

Options:

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;

Discussion 0
Questions 57

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Options:

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

Discussion 0
Questions 58

Which of the following can be executed/called with Snowpipe?

Options:

A.  

A User Defined Function (UDF)

B.  

A stored procedure

C.  

A single copy_into statement

D.  

A single insert__into statement

Discussion 0
Questions 59

When unloading to a stage, which of the following is a recommended practice or approach?

Options:

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

Discussion 0
Questions 60

What is the purpose of an External Function?

Options:

A.  

To call code that executes outside of Snowflake

B.  

To run a function in another Snowflake database

C.  

To share data in Snowflake with external parties

D.  

To ingest data from on-premises data sources

Discussion 0
Questions 61

Which of the following commands cannot be used within a reader account?

Options:

A.  

CREATE SHARE

B.  

ALTER WAREHOUSE

C.  

DROP ROLE

D.  

SHOW SCHEMAS

E.  

DESCRBE TABLE

Discussion 0
Questions 62

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

Options:

A.  

Standard

B.  

Premium

C.  

Enterprise

D.  

Business Critical

Discussion 0
Questions 63

Which stage type can be altered and dropped?

Options:

A.  

Database stage

B.  

External stage

C.  

Table stage

D.  

User stage

Discussion 0
Questions 64

Which of the following are benefits of micro-partitioning? (Select TWO)

Options:

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

Discussion 0
Questions 65

What type of query benefits the MOST from search optimization?

Options:

A.  

A query that uses only disjunction (i.e., OR) predicates

B.  

A query that includes analytical expressions

C.  

A query that uses equality predicates or predicates that use IN

D.  

A query that filters on semi-structured data types

Discussion 0
Questions 66

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

Options:

A.  

The Pipe load history is reset to empty.

B.  

The REFRESH command is executed.

C.  

The stage will be purged.

D.  

The destination table is truncated.

Discussion 0
Questions 67

What affects whether the query results cache can be used?

Options:

A.  

If the query contains a deterministic function

B.  

If the virtual warehouse has been suspended

C.  

If the referenced data in the table has changed

D.  

If multiple users are using the same virtual warehouse

Discussion 0
Questions 68

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

Options:

A.  

PURGE

B.  

MODIFY

C.  

REMOVE

D.  

DELETE

Discussion 0
Questions 69

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

Options:

A.  

Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

B.  

All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

C.  

The ACCOUNTADMIN role must be granted to only one user.

D.  

Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

E.  

All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Discussion 0
Questions 70

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

Options:

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.

Discussion 0
Questions 71

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:

COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:

Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

Options:

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.

Discussion 0
Questions 72

What are supported file formats for unloading data from Snowflake? (Choose three.)

Options:

A.  

XML

B.  

JSON

C.  

Parquet

D.  

ORC

E.  

AVRO

F.  

CSV

Discussion 0
Questions 73

Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

Options:

A.  

CONTENT

B.  

PATH

C.  

BYTE_SIZE

D.  

INDEX

E.  

DATATYPE

Discussion 0
Questions 74

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

Options:

A.  

Amazon Web Services

B.  

Docker

C.  

IBM Cloud

D.  

Microsoft Azure Cloud

E.  

Google Cloud Platform

F.  

Oracle Cloud

Discussion 0
Questions 75

Which statement is true about running tasks in Snowflake?

Options:

A.  

A task can be called using a CALL statement to run a set of predefined SQL commands.

B.  

A task allows a user to execute a single SQL statement/command using a predefined schedule.

C.  

A task allows a user to execute a set of SQL commands on a predefined schedule.

D.  

A task can be executed using a SELECT statement to run a predefined SQL command.

Discussion 0
Questions 76

The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

Options:

A.  

Local disk caching

B.  

Authentication and access control

C.  

Metadata management

D.  

Query processing

E.  

Database storage

Discussion 0
Questions 77

Where can a user find and review the failed logins of a specific user for the past 30 days?

Options:

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

Discussion 0
Questions 78

Which file formats are supported for unloading data from Snowflake? (Choose two.)

Options:

A.  

Avro

B.  

JSON

C.  

ORC

D.  

XML

E.  

Delimited (CSV, TSV, etc.)

Discussion 0
Questions 79

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete

2. Leaves for 15 minutes

3. Returns and runs a query that takes 10 seconds to complete

4. Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

Options:

A.  

4 minutes

B.  

10 minutes

C.  

14 minutes

D.  

24 minutes

Discussion 0
Questions 80

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Options:

A.  

Removing a column from the query SELECT list

B.  

Stopping the virtual warehouse that the query is running against

C.  

Clustering of the data used by the query

D.  

Executing the RESULTS_SCAN() table function

E.  

Changing a column that is not in the cached query

Discussion 0
Questions 81

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

Options:

A.  

INSERT

B.  

PUT

C.  

GET

D.  

COPY

Discussion 0
Questions 82

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

Options:

A.  

PUT

B.  

GET

C.  

COPY

D.  

SELECT

Discussion 0
Questions 83

Which minimum Snowflake edition allows for a dedicated metadata store?

Options:

A.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake

Discussion 0
Questions 84

What is the minimum Snowflake edition that has column-level security enabled?

Options:

A.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake

Discussion 0
Questions 85

Which of the following describes the Snowflake Cloud Services layer?

Options:

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

Discussion 0
Questions 86

A virtual warehouse is created using the following command:

Create warehouse my_WH with

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

Options:

A.  

Increase the warehouse size from Medium to 2XL.

B.  

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

C.  

Configure the warehouse to a multi-cluster warehouse.

D.  

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Discussion 0
Questions 87

How can a row access policy be applied to a table or a view? (Choose two.)

Options:

A.  

Within the policy DDL

B.  

Within the create table or create view DDL

C.  

By future APPLY for all objects in a schema

D.  

Within a control table

E.  

Using the command ALTER ADD ROW ACCESS POLICY ;

Discussion 0