Summer Sale - Limited Time 55% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 5763r953

Welcome To DumpsPedia

SnowPro-Core Sample Questions Answers

Questions 4

Which Snowflake edition enables data sharing only through Snowflake Support?

Options:

A.

Virtual Private Snowflake

B.

Business Critical

C.

Enterprise

D.

Standard

Buy Now
Questions 5

How can a user change which columns are referenced in a view?

Options:

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

Buy Now
Questions 6

What action can a user take to address query concurrency issues?

Options:

A.

Enable the query acceleration service.

B.

Enable the search optimization service.

C.

Add additional clusters to the virtual warehouse

D.

Resize the virtual warehouse to a larger instance size.

Buy Now
Questions 7

Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

Options:

A.

Pre-signed URL

B.

Scoped URL

C.

Signed URL

D.

File URL

Buy Now
Questions 8

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

Options:

A.

Pipes

B.

Streams

C.

Tasks

D.

Procedures

Buy Now
Questions 9

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

Options:

A.

STATEMENT_TIMEOUT__IN__SECONDS

B.

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

C.

MAX_CONCURRENCY__LEVEL

D.

QUERY_TIMEOUT_IN_SECONDS

Buy Now
Questions 10

User-level network policies can be created by which of the following roles? (Select TWO).

Options:

A.

ROLEADMIN

B.

ACCOUNTADMIN

C.

SYSADMIN

D.

SECURITYADMIN

E.

USERADMIN

Buy Now
Questions 11

Which Snowflake partner specializes in data catalog solutions?

Options:

A.

Alation

B.

DataRobot

C.

dbt

D.

Tableau

Buy Now
Questions 12

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

Options:

A.

Pipe

B.

External stage

C.

Task

D.

Stream

Buy Now
Questions 13

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Options:

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

Buy Now
Questions 14

A user unloaded a Snowflake table called mytable to an internal stage called mystage.

Which command can be used to view the list of files that has been uploaded to the staged?

Options:

A.

list @mytable;

B.

list @%raytable;

C.

list @ %m.ystage;

D.

list @mystage;

Buy Now
Questions 15

What is a responsibility of Snowflake's virtual warehouses?

Options:

A.

Infrastructure management

B.

Metadata management

C.

Query execution

D.

Query parsing and optimization

E.

Management of the storage layer

Buy Now
Questions 16

The fail-safe retention period is how many days?

Options:

A.

1 day

B.

7 days

C.

45 days

D.

90 days

Buy Now
Questions 17

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

Options:

A.

The user has the appropriate privileges on the objects associated with the query

B.

Micro-partitions have been reclustered since the query was last run

C.

The new query is run using the same virtual warehouse as the previous query

D.

The query includes a User Defined Function (UDF)

E.

The query has been run within 24 hours of the previously-run query

Buy Now
Questions 18

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

Options:

A.

ROLES

B.

POLICY_REFERENCES

C.

QUERY_HISTORY

D.

RESOURCE_MONIT ORS

E.

ACCESS_HISTORY

Buy Now
Questions 19

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

Options:

A.

STRUCT

B.

OBJECT

C.

BINARY

D.

ARRAY

E.

CLOB

Buy Now
Questions 20

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

Options:

A.

Masking policy

B.

Stored procedure

C.

Task

D.

External table

Buy Now
Questions 21

What are the default Time Travel and Fail-safe retention periods for transient tables?

Options:

A.

Time Travel - 1 day. Fail-safe - 1 day

B.

Time Travel - 0 days. Fail-safe - 1 day

C.

Time Travel - 1 day. Fail-safe - 0 days

D.

Transient tables are retained in neither Fail-safe nor Time Travel

Buy Now
Questions 22

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:

COPY INTO my__table FROM @my__stage;

The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

If the user runs the same copy into command what will happen?

Options:

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.

Buy Now
Questions 23

Which data types does Snowflake support when querying semi-structured data? (Select TWO)

Options:

A.

VARIANT

B.

ARRAY

C.

VARCHAR

D.

XML

E.

BLOB

Buy Now
Questions 24

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

Buy Now
Questions 25

Which copy INTO command outputs the data into one file?

Options:

A.

SINGLE=TRUE

B.

MAX_FILE_NUMBER=1

C.

FILE_NUMBER=1

D.

MULTIPLE=FAISE

Buy Now
Questions 26

In which use cases does Snowflake apply egress charges?

Options:

A.

Data sharing within a specific region

B.

Query result retrieval

C.

Database replication

D.

Loading data into Snowflake

Buy Now
Questions 27

What is the MOST performant file format for loading data in Snowflake?

Options:

A.

CSV (Unzipped)

B.

Parquet

C.

CSV (Gzipped)

D.

ORC

Buy Now
Questions 28

Which command can be used to stage local files from which Snowflake interface?

Options:

A.

SnowSQL

B.

Snowflake classic web interface (Ul)

C.

Snowsight

D.

.NET driver

Buy Now
Questions 29

Which Snowflake feature is used for both querying and restoring data?

Options:

A.

Cluster keys

B.

Time Travel

C.

Fail-safe

D.

Cloning

Buy Now
Questions 30

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

Buy Now
Questions 31

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

Options:

A.

True

B.

False

Buy Now
Questions 32

What are ways to create and manage data shares in Snowflake? (Select TWO)

Options:

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

Buy Now
Questions 33

When is the result set cache no longer available? (Select TWO)

Options:

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

Buy Now
Questions 34

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

Buy Now
Questions 35

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

Options:

A.

Clustering

B.

Indexing

C.

Fragmenting

D.

Using INDEX__HINTS

Buy Now
Questions 36

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

Buy Now
Questions 37

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;

Buy Now
Questions 38

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

Options:

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

Buy Now
Questions 39

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Options:

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

Buy Now
Questions 40

When unloading data to an external stage, what is the MAXIMUM file size supported?

Options:

A.

1 GB

B.

5 GB

C.

10 GB

D.

16 GB

Buy Now
Questions 41

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

What will occur?

Options:

A.

No virtual warehouse will be used, data will be read from the result cache.

B.

No virtual warehouse will be used, data will be read from the local disk cache.

C.

The default virtual warehouse will be used to read all data.

D.

The virtual warehouse that is defined at the session level will be used to read all data.

Buy Now
Questions 42

Using variables in Snowflake is denoted by using which SQL character?

Options:

A.

@

B.

&

C.

$

D.

#

Buy Now
Questions 43

What is the MAXIMUM size limit for a record of a VARIANT data type?

Options:

A.

8MB

B.

16MB

C.

32MB

D.

128MB

Buy Now
Questions 44

How would a user execute a series of SQL statements using a task?

Options:

A.

Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1

WHERE ..

B.

A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS

call stored_proc1(); call stored_proc2();

C.

Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

D.

Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

Buy Now
Questions 45

Which statement describes how Snowflake supports reader accounts?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 46

Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

Options:

A.

COPY INTO

B.

CREATE PIPE

C.

INSERT INTO

D.

TABLE STREAM

Buy Now
Questions 47

What column type does a Kafka connector store formatted information in a single column?

Options:

A.

ARRAY

B.

OBJECT

C.

VARCHAR

D.

VARIANT

Buy Now
Questions 48

When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?

Options:

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

Buy Now
Questions 49

Which statement describes pruning?

Options:

A.

The filtering or disregarding of micro-partitions that are not needed to return a query.

B.

The return of micro-partitions values that overlap with each other to reduce a query's runtime.

C.

A service that is handled by the Snowflake Cloud Services layer to optimize caching.

D.

The ability to allow the result of a query to be accessed as if it were a table.

Buy Now
Questions 50

Which of the following can be used when unloading data from Snowflake? (Choose two.)

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Buy Now
Questions 51

Which of the following is the Snowflake Account_Usage.Metering_History view used for?

Options:

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

Buy Now
Questions 52

Which formats does Snowflake store unstructured data in? (Choose two.)

Options:

A.

GeoJSON

B.

Array

C.

XML

D.

Object

E.

BLOB

Buy Now
Questions 53

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

Options:

A.

USAGE

B.

OPERATE

C.

MONITOR

D.

MODIFY

Buy Now
Questions 54

What is a characteristic of the Snowflake Query Profile?

Options:

A.

It can provide statistics on a maximum number of 100 queries per week.

B.

It provides a graphic representation of the main components of the query processing.

C.

It provides detailed statistics about which queries are using the greatest number of compute resources.

D.

It can be used by third-party software using the Query Profile API.

Buy Now
Questions 55

What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

Options:

A.

READ

B.

OWNERSHIP

C.

USAGK

D.

WRTTF

Buy Now
Questions 56

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

Options:

A.

Cloud services layer

B.

Compute layer

C.

Storage layer

D.

Cloud agnostic layer

Buy Now
Questions 57

What is cached during a query on a virtual warehouse?

Options:

A.

All columns in a micro-partition

B.

Any columns accessed during the query

C.

The columns in the result set of the query

D.

All rows accessed during the query

Buy Now
Questions 58

What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).

Options:

A.

Bytes spilled to local cache.

B.

Bytes spilled to local storage.

C.

Bytes spilled to remote cache.

D.

Bytes spilled to remote storage.

E.

Bytes spilled to remote metastore.

Buy Now
Questions 59

Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?

Options:

A.

PARSE_JSON

B.

CHECK_JSON

C.

JSON_EXTRACT_PATH_TEXT

D.

PARSE_XML

Buy Now
Questions 60

Which role has the ability to create and manage users and roles?

Options:

A.

ORGADMIN

B.

USERADMIN

C.

SYSADMIN

D.

SECURITYADMIN

Buy Now
Questions 61

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

Options:

A.

USERADMIN

B.

PUBLIC

C.

ORGADMIN

D.

SYSADMIN

Buy Now
Questions 62

What are benefits of using Snowpark with Snowflake? (Select TWO).

Options:

A.

Snowpark uses a Spark engine to generate optimized SQL query plans.

B.

Snowpark automatically sets up Spark within Snowflake virtual warehouses.

C.

Snowpark does not require that a separate cluster be running outside of Snowflake.

D.

Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

E.

Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

Buy Now
Questions 63

For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

Options:

A.

10

B.

50

C.

64

D.

256

Buy Now
Questions 64

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

Options:

A.

Roles

B.

Databases

C.

Warehouses

D.

Users

E.

Accounts

Buy Now
Questions 65

When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

Options:

A.

10-50 MB

B.

100-250 MB

C.

300-500 MB

D.

1000-1500 MB

Buy Now
Questions 66

Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

Options:

A.

Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

B.

Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

C.

Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

D.

Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

E.

All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

F.

Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Buy Now
Questions 67

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.

Buy Now
Questions 68

Which of the following accurately describes shares?

Options:

A.

Tables, secure views, and secure UDFs can be shared

B.

Shares can be shared

C.

Data consumers can clone a new table from a share

D.

Access to a share cannot be revoked once granted

Buy Now
Questions 69

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

Buy Now
Questions 70

What is the default file size when unloading data from Snowflake using the COPY command?

Options:

A.

5 MB

B.

8 GB

C.

16 MB

D.

32 MB

Buy Now
Questions 71

Which command can be used to load data files into a Snowflake stage?

Options:

A.

JOIN

B.

COPY INTO

C.

PUT

D.

GET

Buy Now
Questions 72

What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

Options:

A.

Custom Edition

B.

Virtual Private Snowflake

C.

Business Critical Edition

D.

Standard Edition

E.

Enterprise Edition

Buy Now
Questions 73

What are common issues found by using the Query Profile? (Choose two.)

Options:

A.

Identifying queries that will likely run very slowly before executing them

B.

Locating queries that consume a high amount of credits

C.

Identifying logical issues with the queries

D.

Identifying inefficient micro-partition pruning

E.

Data spilling to a local or remote disk

Buy Now
Questions 74

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

Options:

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.

Buy Now
Questions 75

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

Buy Now
Questions 76

Which of the following objects are contained within a schema? (Choose two.)

Options:

A.

Role

B.

Stream

C.

Warehouse

D.

External table

E.

User

F.

Share

Buy Now
Questions 77

When loading data into Snowflake, how should the data be organized?

Options:

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

Buy Now
Questions 78

When cloning a database, what is cloned with the database? (Choose two.)

Options:

A.

Privileges on the database

B.

Existing child objects within the database

C.

Future child objects within the database

D.

Privileges on the schemas within the database

E.

Only schemas and tables within the database

Buy Now
Questions 79

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

Buy Now
Questions 80

What is true about sharing data in Snowflake? (Choose two.)

Options:

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.

Buy Now
Questions 81

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Options:

A.

parse_json()

B.

json_extract_path_text()

C.

object_construct()

D.

flatten

Buy Now
Questions 82

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

Buy Now
Questions 83

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

Options:

A.

External Tokenization

B.

External Tables

C.

Materialized Views

D.

User-Defined Table Functions (UDTF)

Buy Now
Questions 84

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates

How can this worksheet be shared?

Options:

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

Buy Now
Questions 85

In a Snowflake role hierarchy, what is the top-level role?

Options:

A.

SYSADMIN

B.

ORGADMIN

C.

ACCOUNTADMIN

D.

SECURITYADMIN

Buy Now
Questions 86

Which of the following significantly improves the performance of selective point lookup queries on a table?

Options:

A.

Clustering

B.

Materialized Views

C.

Zero-copy Cloning

D.

Search Optimization Service

Buy Now
Questions 87

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

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Buy Now
Questions 88

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

Options:

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.

Buy Now
Questions 89

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

Buy Now
Questions 90

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

Options:

A.

Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

B.

Scaling out adds clusters of varying sizes to a virtual warehouse.

C.

Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

D.

Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

E.

Scaling up resizes a virtual warehouse so it can handle more complex workloads.

F.

Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

Buy Now
Questions 91

Network policies can be set at which Snowflake levels? (Choose two.)

Options:

A.

Role

B.

Schema

C.

User

D.

Database

E.

Account

F.

Tables

Buy Now
Questions 92

What COPY INTO SQL command should be used to unload data into multiple files?

Options:

A.

SINGLE=TRUE

B.

MULTIPLE=TRUE

C.

MULTIPLE=FALSE

D.

SINGLE=FALSE

Buy Now
Questions 93

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

Options:

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.

Buy Now
Questions 94

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON.

How can this be accomplished?

Options:

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;

Buy Now
Questions 95

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

Buy Now
Questions 96

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 ;

Buy Now