Winter Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netbudy65

COF-C02 SnowPro Core Certification Exam Questions and Answers

Questions 4

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Options:

A.

Tri-Secret Secure

B.

Time Travel

C.

Fail-safe

D.

Data encryption

E.

External stages

Buy Now
Questions 5

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

Which diagram indicates a well-clustered table?

Options:

A.

B.

C.

D.

Buy Now
Questions 6

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.

Buy Now
Questions 7

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 8

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 9

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 10

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

Options:

A.

Schema

B.

View

C.

Internal stage

D.

Table

E.

User

F.

Role

Buy Now
Questions 11

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 12

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 13

The Snowflake Search Optimization Services supports improved performance of which kind of query?

Options:

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

Buy Now
Questions 14

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Options:

A.

Management of metadata

B.

Computing the data

C.

Maintaining Availability Zones

D.

Infrastructure security

E.

Parsing and optimizing queries

Buy Now
Questions 15

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

Options:

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

Buy Now
Questions 16

Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?

Options:

A.

A VARIANT column is more secure than a string column

B.

A VARIANT column compresses data and a string column does not.

C.

A variant column can be used to create a data hierarchy and a string column cannot

D.

A VARIANT column will have a better query performance than a string column.

Buy Now
Questions 17

True or False: Snowpipe via REST API can only reference External Stages as source.

Options:

A.

True

B.

False

Buy Now
Questions 18

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 19

Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

Options:

A.

Materialized view

B.

Sequence

C.

Secure view

D.

Transient table

E.

Clustered table

Buy Now
Questions 20

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

Options:

A.

SYSADMIN

B.

ORGADMIN

C.

ACCOUNTADMIN

D.

SECURITYADMIN

Buy Now
Questions 21

How does Snowflake define i1s approach to Discretionary Access Control (DAC)?

Options:

A.

A defined level of access to an object

B.

An entity in which access can be granted

C.

Each object has an owner, who can in turn grail access to that object.

D.

Access privileges are assigned to roles. which are in turn assigned to use's

Buy Now
Questions 22

How are serverless features billed?

Options:

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

Buy Now
Questions 23

What step does Snowflake recommend when loading data from a stage?

Options:

A.

Use PURGE when using the COPY INTO

command.

B.

Use remove when using The copy into

command.

C.

Use the load HISTORY function to view the status of loaded files.

D.

Use the copy history function to update the status of loaded files.

Buy Now
command to automatically remove files from the stage after they are successfully loaded.

This helps maintain an efficient stage by removing files that are no longer needed.

Example:

COPY INTO my_table

FROM @my_stage

FILE_FORMAT = (TYPE = CSV)

PURGE = TRUE;

References:

    Snowflake Documentation: COPY INTO Command

    Snowflake Staging Best Practices

Questions 24

Which multi-cluster virtual warehouse setting will help process queued queries as quickly as possible?

Options:

A.

An economy scaling policy

B.

A standard scaling policy

C.

Maximized mode

D.

Auto-scale mode

Buy Now
Questions 25

Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?

Options:

A.

APPROXIMATE_SIMILARITY

B.

JAROWINKLER_SIMILARITY

C.

APPROXIMATE_JACCARD_INDEX

D.

MINHASH COMBINE

Buy Now
Questions 26

In Snowflake, what allows users to perform recursive queries?

Options:

A.

QUALIFY

B.

LATERAL

C.

PIVOT

D.

CONNECT BY

Buy Now
Questions 27

Which Query Profile operator is considered a DML operator?

Options:

A.

ExternalScan

B.

Flatten

C.

Merge

D.

Sort

Buy Now
Questions 28

When used with a select statement in the copy into command, what statement will unload data from a table as JSON?

Options:

A.

TO_OBJECT

B.

TO_JSON

C.

PARSE_JSON

D.

OBJECT CONSTRUCT

Buy Now
Questions 29

Which database objects can be shared with Secure Data Sharing? (Select TWO).

Options:

A.

Views

B.

Materialized views

C.

External stages

D.

External tables

E.

Dynamic tables

Buy Now
Questions 30

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

Options:

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.

Buy Now
Questions 31

Which table function will identify data that was loaded using COPY INTO

statements and also identify data loaded using Snowpipe?

Options:

A.

DATA_TRANSFER_HISTORY

B.

PIPE_USAGE_HISTORY

C.

VALIDATE_PIPE_LOAD

D.

COPY_HISTORY

Buy Now
commands and automated data loading through Snowpipe. This function provides visibility into load operations, making it valuable for monitoring data ingestion, ensuring data integrity, and troubleshooting loading processes.

Questions 32

Which governance feature is supported by all Snowflake editions?

Options:

A.

Object tags

B.

Masking policies

C.

Row access policies

D.

OBJECT_DEPENDENCIES View

Buy Now
Questions 33

A JSON document is stored in the source_colum of type VARIANT. The document has an array called elements. The array contains the name key that has a string value How can a Snowflake user extract the name from the first element?

Options:

A.

Source_column.element[1]:name

B.

Source_column.element[0]:name

C.

Source_column.element[1].name

D.

Source_column.element[0]:name

Buy Now
Questions 34

Which Snowflake object is supported by both database replication and replication groups?

Options:

A.

Pipes

B.

Users

C.

Stages

D.

Materialized views

Buy Now
Questions 35

How does the search optimization service improve query performance?

Options:

A.

By clustering the tables

B.

By creating a persistent data structure

C.

By using caching

D.

By optimizing the use of micro-partitions

Buy Now
Questions 36

What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO

command when loading data from a JSON file into a table?

Options:

A.

It flattens multiple arrays into a single array.

B.

It removes the outer array structure and loads separate rows of data

C.

It transforms a pivoted table into an array.

D.

It tokenizes each data string using the defined delimiters.

Buy Now
command is used when loading data from a JSON file into a table. This parameter removes the outer array structure from the JSON data and loads separate rows of data into the table.

    Understanding the STRIP_OUTER_ARRAY Parameter:

      JSON files often contain data in an array format where multiple records are nested within a single outer array.

      The STRIP_OUTER_ARRAY parameter helps in simplifying the loading process by removing this outer array, allowing each element within the array to be loaded as a separate row in the target table.

    How It Works:

      When the STRIP_OUTER_ARRAY parameter is set to TRUE, Snowflake treats each item within the outer array as an individual record.

      This eliminates the need for additional parsing or transformation steps that would otherwise be required to handle nested arrays.

    Example Usage:

FROM @my_stage/file.json

FILE_FORMAT = (TYPE = 'JSON' STRIP_OUTER_ARRAY = TRUE);

      In this example, the JSON file containing an array of objects is loaded into the table my_table.

      Each object within the array is loaded as a separate row, without the outer array structure.

    Benefits:

      Simplifies data loading: By removing the outer array, the data is directly loaded into the table without additional manipulation.

      Enhances performance: Streamlines the loading process, reducing the complexity and potential errors in handling nested JSON structures.

References:

    Snowflake Documentation: COPY INTO

Snowflake Documentation: JSON File Format Options

Questions 37

Which Snowflake database object can be shared with other accounts?

Options:

A.

Tasks

B.

Pipes

C.

Secure User-Defined Functions (UDFs)

D.

Stored Procedures

Buy Now
Questions 38

Which task is supported by the use of Access History in Snowflake?

Options:

A.

Data backups

B.

Cost monitoring

C.

Compliance auditing

D.

Performance optimization

Buy Now
Questions 39

If a JOIN operation is based on two columns which both contain NULL values, what SQL function will return results?

Options:

A.

An NVL function used to change the NULL values to another value

B.

An equal_null function

C.

A NULLIF function

D.

An I FNULL function used to change the NULL values to another value

Buy Now
Questions 40

Which function unloads data from a relational table to JSON?

Options:

A.

TRUNC

B.

TRUNC(ID_NUMBER, 5)

C.

ID_NUMBER*100

D.

TO_CHAR

Buy Now
Questions 41

Which privilege is required on a virtual warehouse to abort any existing executing queries?

Options:

A.

USAGE

B.

OPERATE

C.

MODIFY

D.

MONITOR

Buy Now
Questions 42

What does a Query Profile metric that shows excessive spillage indicate?

Options:

A.

Poor query optimization

B.

Expired temporary tables

C.

Improper virtual warehouse sizing

D.

Improper Common Table Expressions (CTEs)

Buy Now
Questions 43

Which Snowflake feature enables loading data from cloud storage as soon as files are available in a stage?

Options:

A.

C0PY_INT0 command

B.

Data replication

C.

Snowpipe

D.

Direct share

Buy Now
Questions 44

A user creates a stage using the following command?

What will be the outcome?

Options:

A.

A stage with a directory table set to automatically refresh will be created

B.

A stage with a directory table that has metadata that must be manually refreshed will be created.

C.

An error will be received stating that the storage location for the stage must be identified when creating a stage with a directory table.

D.

The command will fail to run because the name of the directory table is not specified.

Buy Now
Questions 45

When a Snowflake user loads CSV data from a stage, which copy into

command guideline should they follow?

Options:

A.

The CSV field delimiter must be a comma character (*,"),

B.

The number of columns in each row should be consistent.

C.

The data file in the stage must be in a compressed format.

D.

The data file must have the same number of columns as the target table.

Buy Now
Questions 46

When do Snowflake object owners lose their ability to make grant decisions?

Options:

A.

When the object owner has been granted a database role

B.

When the object owner has been granted an account role

C.

When the object is part of a managed access schema

D.

When the object is part of a regular schema

Buy Now
Questions 47

How does the authorization associated with a pre-signed URL work tor an unstructured file?

Options:

A.

Anyone who has the URL can access the referenced file for the life of the token.

B.

Only the user who generates the URL can use the URL to access the referenced file.

C.

Only the users who have roles with sufficient privileges on the URL can access the referenced file.

D.

The role specified in the GET REST API call must have sufficient privileges on the stage to access the referenced file using the URL.

Buy Now
Questions 48

Which clause is used to define a function that may return different values for different rows?

Options:

A.

IMMUTABLE

B.

RETURNS

C.

COMMENT

D.

VOLATILE

Buy Now
Questions 49

What are characteristics of Snowflake directory tables? (Select TWO).

Options:

A.

Directory tables are separate database objects.

B.

Directory tables can only be used with an external stage.

C.

Directory tables contain copies of staged files in binary format.

D.

Directory tables store file-level metadata about the data files in a stage.

E.

A directory table can be added to a stage when the stage is created, or later.

Buy Now
Questions 50

Which object can be shared using Secure Data Sharing?

Options:

A.

Secure view

B.

Materialized view

C.

Externa! function

D.

User-Defined Function (UDF)

Buy Now
Questions 51

Which common query issues can be identified by the Query Profile? (Select TWO).

Options:

A.

Insufficient credit quota

B.

Inefficient query pruning

C.

Excessive query pruning

D.

Exploding joins

E.

Credit usage that exceeds a set threshold

Buy Now
Questions 52

Which key access control concept does Snowflake descibe as a defined level of access to an object?

Options:

A.

Grant

B.

Privilege

C.

Role

D.

Session

Buy Now
Questions 53

Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?

Options:

A.

ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';

B.

ALTER USER jsmith SET ENCRYPTED_KEY=’MIIBIjANBgkqh...';

C.

ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';

D.

ALTER USER jsmith SET RSA_PUBLIC_KEY-MIIBIjANBgkqh...';

Buy Now
Questions 54

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

Options:

A.

ACCOUNTADMIN

B.

USERADMIN

C.

PUBLIC

D.

SYSADMIN

E.

Any role that has the global ATTACH POLICY privilege

Buy Now
Questions 55

To use the overwrite option on insert, which privilege must be granted to the role?

Options:

A.

truncate

B.

DELETE

C.

UPDATE

D.

SELECT

Buy Now
Questions 56

What action should be taken if a large number of concurrent queries are queued in a virtual warehouse?

Options:

A.

Scale-up by resizing the warehouse.

B.

Scale-out with a multi-cluster warehouse.

C.

Disable auto-suspend on the warehouse.

D.

Enable auto-resume on the warehouse.

Buy Now
Questions 57

Which roles can make grant decisions to objects within a managed access schema? (Select TWO)

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSTEMADMIN

D.

ORGADMIN

E.

USERADMIN

Buy Now
Questions 58

Which privilege grants the ability to set a column-level security masking policy on a table or view column?

Options:

A.

APPLY

B.

CREATE

C.

SET

D.

MODIFY

Buy Now
Questions 59

A network policy applied at the user level takes precedence over a network policy applied to what Snowflake object?

Options:

A.

A role

B.

An account

C.

A database

D.

An organization

Buy Now
Questions 60

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 61

Which is a best practice recommendation when planning to load data into a table?

Options:

A.

Use the largest size virtual warehouse allowed to maximize the available threads for uploading files.

B.

Dedicate separate virtual warehouses for loading operations and querying operations.

C.

Use different stages to store files, identifying data source identifiers.

D.

Upload files that are equal to or larger than 100 GB each.

Buy Now
Questions 62

What are the recommended alternative data types in Snowflake for unsupported large object data types such as BLOB and CLOB? (Select TWO).

Options:

A.

VARIANT

B.

ARRAY

C.

BINARY

D.

OBJECT

E.

VARCHAR

Buy Now
Questions 63

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 64

How often are encryption keys automatically rotated by Snowflake?

Options:

A.

30 Days

B.

60 Days

C.

90 Days

D.

365 Days

Buy Now
Questions 65

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

Options:

A.

True

B.

False

Buy Now
Questions 66

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 67

What Snowflake role must be granted for a user to create and manage accounts?

Options:

A.

ACCOUNTADMIN

B.

ORGADMIN

C.

SECURITYADMIN

D.

SYSADMIN

Buy Now
Questions 68

What data is stored in the Snowflake storage layer? (Select TWO).

Options:

A.

Snowflake parameters

B.

Micro-partitions

C.

Query history

D.

Persisted query results

E.

Standard and secure view results

Buy Now
Questions 69

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 70

Will data cached in a warehouse be lost when the warehouse is resized?

Options:

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

Buy Now
Questions 71

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 72

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

Buy Now
Questions 73

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 74

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

Buy Now
Questions 75

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 76

What is the default File Format used in the COPY command if one is not specified?

Options:

A.

CSV

B.

JSON

C.

Parquet

D.

XML

Buy Now
Questions 77

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

Options:

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.

Buy Now
Questions 78

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

Options:

A.

ORC

B.

XML

C.

Avro

D.

Parquet

E.

JSON

Buy Now
Questions 79

True or False: Fail-safe can be disabled within a Snowflake account.

Options:

A.

True

B.

False

Buy Now
Questions 80

What is the minimum Snowflake edition required to create a materialized view?

Options:

A.

Standard Edition

B.

Enterprise Edition

C.

Business Critical Edition

D.

Virtual Private Snowflake Edition

Buy Now
Questions 81

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

Options:

A.

True

B.

False

Buy Now
Questions 82

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 83

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

Options:

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

Buy Now
Questions 84

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

Buy Now
Questions 85

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 86

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

Options:

A.

Variant

B.

Object

C.

Geometry

D.

Geography

Buy Now
Questions 87

Where would a Snowflake user find information about query activity from 90 days ago?

Options:

A.

account__usage . query history view

B.

account__usage.query__history__archive View

C.

information__schema . cruery_history view

D.

information__schema - query history_by_ses s i on view

Buy Now
Questions 88

Which command is used to unload data from a Snowflake table into a file in a stage?

Options:

A.

COPY INTO

B.

GET

C.

WRITE

D.

EXTRACT INTO

Buy Now
Questions 89

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 90

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;

Buy Now
Questions 91

What is a key feature of Snowflake architecture?

Options:

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

Buy Now
Questions 92

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 93

True or False: A Virtual Warehouse can be resized while suspended.

Options:

A.

True

B.

False

Buy Now
Questions 94

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 95

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 96

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

Buy Now
Questions 97

Which of the following compute resources or features are managed by Snowflake? (Select TWO).

Options:

A.

Execute a COPY command

B.

Updating data

C.

Snowpipe

D.

AUTOMATIC__CLUSTERING

E.

Scaling up a warehouse

Buy Now
Questions 98

Which stage type can be altered and dropped?

Options:

A.

Database stage

B.

External stage

C.

Table stage

D.

User stage

Buy Now
Questions 99

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 100

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

Buy Now
Questions 101

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option

What does the STRIP_OUTER_ARRAY file format do?

Options:

A.

It removes the last element of the outer array.

B.

It removes the outer array structure and loads the records into separate table rows,

C.

It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

D.

It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Buy Now
Questions 102

Which of the following describes how clustering keys work in Snowflake?

Options:

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

Buy Now
Questions 103

What information is found within the Statistic output in the Query Profile Overview?

Options:

A.

Operator tree

B.

Table pruning

C.

Most expensive nodes

D.

Nodes by execution time

Buy Now
Questions 104

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

Buy Now
Questions 105

What transformations are supported when loading data into a table using the COPY INTO

command? (Select TWO).

Options:

A.

Column reordering

B.

Column omission

C.

JOIN function

D.

FLATTEN function

E.

GROUP BY function

Buy Now
Questions 106

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

Options:

A.

DATA_RETENTION_TIME_IN_DAYS

B.

MAX_DATA_EXTENSION_TIME_IN_DAYS

C.

MIN_DATA_RETENTION_TIME_IN_DAYS

D.

MAX CONCURRENCY LEVEL

Buy Now
Questions 107

How can a dropped internal stage be restored?

Options:

A.

Enable Time Travel.

B.

Clone the dropped stage.

C.

Execute the UNDROP command.

D.

Recreate the dropped stage.

Buy Now
Questions 108

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.

Buy Now
Questions 109

At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

Options:

A.

Account

B.

Database

C.

Schema

D.

Table

Buy Now
Questions 110

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

Buy Now
Questions 111

Which Snowflake object does not consume any storage costs?

Options:

A.

Secure view

B.

Materialized view

C.

Temporary table

D.

Transient table

Buy Now
Questions 112

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

Buy Now
Questions 113

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

Buy Now
Questions 114

Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?

Options:

A.

USAGE_VIEWER

B.

GOVERNANCE_VIEWER

C.

OBJECT_VIEWER

D.

SECURITY_VIEWER

Buy Now
Questions 115

Which views are included in the DATA SHARING USAGE schema? (Select TWO).

Options:

A.

ACCESS_HISTORY

B.

DATA_TRANSFER_HISTORY

C.

WAREHOUSE_METERING_HISTORY

D.

MONETIZED_USAGE_DAILY

E.

LISTING TELEMETRY DAILY

Buy Now
Questions 116

A permanent table and temporary table have the same name, TBL1, in a schema.

What will happen if a user executes select * from TBL1 ;?

Options:

A.

The temporary table will take precedence over the permanent table.

B.

The permanent table will take precedence over the temporary table.

C.

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

D.

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

Buy Now
Questions 117

Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

Options:

A.

Access history

B.

Data classification

C.

Dynamic Data Masking

D.

Object tagging

Buy Now
Questions 118

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

Buy Now
Questions 119

What does the LATERAL modifier for the FLATTEN function do?

Options:

A.

Casts the values of the flattened data

B.

Extracts the path of the flattened data

C.

Joins information outside the object with the flattened data

D.

Retrieves a single instance of a repeating element in the flattened data

Buy Now
Questions 120

What is a characteristic of materialized views in Snowflake?

Options:

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.

Buy Now
Questions 121

What is the relationship between a Query Profile and a virtual warehouse?

Options:

A.

A Query Profile can help users right-size virtual warehouses.

B.

A Query Profile defines the hardware specifications of the virtual warehouse.

C.

A Query Profile can help determine the number of virtual warehouses available.

D.

A Query Profile automatically scales the virtual warehouse based on the query complexity.

Buy Now
Questions 122

Which Snowflake command can be used to unload the result of a query to a single file?

Options:

A.

Use COPY INTO followed by a GET command to download the file.

B.

Use COPY INTO followed by a put command to download the file.

C.

Use COPY INTO with SINGLE = TRUE followed by a GET command to download the file.

D.

Use COPY INTO with SINGLE = TRUE followed by a PUT command to download the file.

Buy Now
Questions 123

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

Buy Now
Questions 124

A user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?

Options:

A.

File URL

B.

Staged URL

C.

Scoped URL

D.

Pre-signed URL

Buy Now
Questions 125

How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

Options:

A.

Review the granted privileges to the database object.

B.

Review the row access policy for the database object.

C.

Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.

D.

Query the REPLICATION USAGE HISTORY view in the ORGANIZATION USAGE schema.

Buy Now
Questions 126

What will prevent unauthorized access to a Snowflake account from an unknown source?

Options:

A.

Network policy

B.

End-to-end encryption

C.

Multi-Factor Authentication (MFA)

D.

Role-Based Access Control (RBAC)

Buy Now
Questions 127

Which Snowflake view is used to support compliance auditing?

Options:

A.

ACCESS_HISTORY

B.

COPY_HISTORY

C.

QUERY_HISTORY

D.

ROW ACCESS POLICIES

Buy Now
Questions 128

What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?

Options:

A.

Data Replication

B.

Secure Data Sharing

C.

Data Exchange

D.

Snowflake Marketplace

Buy Now
Questions 129

Which privilege must be granted by one role to another role, and cannot be revoked?

Options:

A.

MONITOR

B.

OPERATE

C.

OWNERSHIP

D.

ALL

Buy Now
Questions 130

What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?

Options:

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.

Buy Now
Questions 131

Who can grant object privileges in a regular schema?

Options:

A.

Object owner

B.

Schema owner

C.

Database owner

D.

SYSADMIN

Buy Now
Questions 132

Which Snowflake database object can be used to track data changes made to table data?

Options:

A.

Tag

B.

Task

C.

Stream

D.

Stored procedure

Buy Now
Questions 133

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

Buy Now
Questions 134

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

Buy Now
Questions 135

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

Options:

A.

FOR

B.

LOOP

C.

REPEAT

D.

WHILE

Buy Now
Questions 136

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

Buy Now
Questions 137

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

Buy Now
Questions 138

What is the primary purpose of a directory table in Snowflake?

Options:

A.

To store actual data from external stages

B.

To automatically expire file URLs for security

C.

To manage user privileges and access control

D.

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

Buy Now
Questions 139

Which command is used to start configuring Snowflake for Single Sign-On (SSO)?

Options:

A.

CREATE SESSION POLICY

B.

CREATE NETWORK RULE

C.

CREATE SECURITY INTEGRATION

D.

CREATE PASSWORD POLICY

Buy Now
Questions 140

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

Buy Now
Questions 141

How should clustering be used to optimize the performance of queries that run on a very large table?

Options:

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.

Buy Now
Questions 142

What activities can a user with the ORGADMIN role perform? (Select TWO).

Options:

A.

Create an account for an organization.

B.

Edit the account data for an organization.

C.

Delete the account data for an organization.

D.

View usage information for all accounts in an organization.

E.

Select all the data in tables for all accounts in an organization.

Buy Now
Questions 143

Which commands can only be executed using SnowSQL? (Select TWO).

Options:

A.

COPY INTO

B.

GET

C.

LIST

D.

PUT

E.

REMOVE

Buy Now
Questions 144

What happens when a Snowflake user changes the data retention period at the schema level?

Options:

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.

Buy Now
Questions 145

Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 146

What does the worksheet and database explorer feature in Snowsight allow users to do?

Options:

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.

Buy Now
Questions 147

Which Snowflake layer is associated with virtual warehouses?

Options:

A.

Cloud services

B.

Query processing

C.

Elastic memory

D.

Database storage

Buy Now
Questions 148

For Directory tables, what stage allows for automatic refreshing of metadata?

Options:

A.

User stage

B.

Table stage

C.

Named internal stage

D.

Named external stage

Buy Now
Questions 149

Which command should be used to unload all the rows from a table into one or more files in a named stage?

Options:

A.

COPY INTO

B.

GET

C.

INSERT INTO

D.

PUT

Buy Now
Questions 150

What is the MINIMUM permission needed to access a file URL from an external stage?

Options:

A.

MODIFY

B.

READ

C.

SELECT

D.

USAGE

Buy Now
Questions 151

Which view can be used to determine if a table has frequent row updates or deletes?

Options:

A.

TABLES

B.

TABLE_STORAGE_METRICS

C.

STORAGE_DAILY_HISTORY

D.

STORAGE USAGE

Buy Now
Questions 152

What is the only supported character set for loading and unloading data from all supported file formats?

Options:

A.

UTF-8

B.

UTF-16

C.

ISO-8859-1

D.

WINDOWS-1253

Buy Now
Questions 153

Which role has the ability to create a share from a shared database by default?

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Buy Now
Questions 154

By default, how long is the standard retention period for Time Travel across all Snowflake accounts?

Options:

A.

0 days

B.

1 day

C.

7 days

D.

14 days

Buy Now
Questions 155

What type of function returns one value for each Invocation?

Options:

A.

Aggregate

B.

Scalar

C.

Table

D.

Window

Buy Now
Questions 156

There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?

Options:

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.

Buy Now
Questions 157

A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY.

What should they do?

Options:

A.

Use the SECURITYADMIN role.

B.

Use the SYSADMIN role.

C.

Use the USERADMIN role.

D.

Contact Snowflake Support.

Buy Now
Questions 158

What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Buy Now
Questions 159

What is the Fail-safe retention period for transient and temporary tables?

Options:

A.

0 days

B.

1 day

C.

7 days

D.

90 days

Buy Now
Questions 160

What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?

Options:

A.

Temporary table

B.

External table

C.

Secure view

D.

Materialized view

Buy Now
Questions 161

What does the TableScan operator represent in the Query Profile?

Options:

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

Buy Now
Questions 162

Which activities are included in the Cloud Services layer? {Select TWO).

Options:

A.

Data storage

B.

Dynamic data masking

C.

Partition scanning

D.

User authentication

E.

Infrastructure management

Buy Now
Questions 163

Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?

Options:

A.

Caching

B.

Cluster depth

C.

Query pruning

D.

Retrieval optimization

Buy Now
Questions 164

Which URL provides access to files in Snowflake without authorization?

Options:

A.

File URL

B.

Scoped URL

C.

Pre-signed URL

D.

Scoped file URL

Buy Now
Questions 165

How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?

Options:

A.

60 minutes

B.

24 hours

C.

14 days

D.

30 days

Buy Now
Questions 166

The effects of query pruning can be observed by evaluating which statistics? (Select TWO).

Options:

A.

Partitions scanned

B.

Partitions total

C.

Bytes scanned

D.

Bytes read from result

E.

Bytes written

Buy Now
Questions 167

What information does the Query Profile provide?

Options:

A.

Graphical representation of the data model

B.

Statistics for each component of the processing plan

C.

Detailed Information about I he database schema

D.

Real-time monitoring of the database operations

Buy Now
Questions 168

If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?

Options:

A.

60

B.

91

C.

120

D.

121

Buy Now
Questions 169

When using the ALLOW_CLI£NT_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

Questions 170

What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?

Options:

A.

BINARY_FORMAT

B.

ESCAPE_UNENCLOSED_FIELD

C.

FIELD_OPTIONALLY_ENCLOSED_BY

D.

SKIP BYTE ORDER MARK

Buy Now
Questions 171

How are network policies defined in Snowflake?

Options:

A.

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

B.

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

C.

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

D.

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

to Snowflake.

Buy Now
Questions 172

What happens when a network policy includes values that appear in both the allowed and blocked IP address list?

Options:

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

Buy Now
Questions 173

Which command can be used to list all the file formats for which a user has access privileges?

Options:

A.

LIST

B.

ALTER FILE FORMAT

C.

DESCRIBE FILE FORMAT

D.

SHOW FILE FORMATS

Buy Now
Questions 174

Which Snowflow object does not consume and storage costs?

Options:

A.

Secure view

B.

Materialized view

C.

Temporary table

D.

Transient table

Buy Now
Questions 175

How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?

Options:

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.

Buy Now
Questions 176

What are the benefits of the replication feature in Snowflake? (Select TWO).

Options:

A.

Disaster recovery

B.

Time Travel

C.

Fail-safe

D.

Database failover and fallback

E.

Data security

Buy Now
Questions 177

Which file function generates a SnowFlake-hosted URL that must be authenticated when used?

Options:

A.

GET_STATE_LOCATION

B.

GET_PRESENT_URL

C.

BUILD_SCOPED_FILE_URL

D.

BUILD_STAGE_FILE_URL

Buy Now
Questions 178

While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).

Options:

A.

BINARY

B.

GEOGRAPHY

C.

GEOMETRY

D.

OBJECT

E.

VARIANT

Buy Now
Questions 179

What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?

Options:

A.

1

B.

5

C.

10

D.

100

Buy Now
Questions 180

What are valid sub-clauses to the OVER clause for a window function? (Select TWO).

Options:

A.

GROUP BY

B.

LIMIT

C.

ORDER BY

D.

PARTITION BY

E.

UNION ALL

Buy Now
Questions 181

What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

Options:

A.

View

B.

Secure view

C.

Materialized view

D.

External table

Buy Now
Questions 182

What are characteristics of transient tables in Snowflake? (Select TWO).

Options:

A.

Transient tables have a Fail-safe period of 7 days.

B.

Transient tables can be cloned to permanent tables.

C.

Transient tables persist until they are explicitly dropped.

D.

Transient tables can be altered to make them permanent tables.

E.

Transient tables have Time Travel retention periods of 0 or 1 day.

Buy Now
Questions 183

How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 184

Which function will provide the proxy information needed to protect Snowsight?

Options:

A.

SYSTEMADMIN_TAG

B.

SYSTEM$GET_PRIVATELINK

C.

SYSTEMSALLONTLIST

D.

SYSTEMAUTHORIZE

Buy Now
Questions 185

The is the minimum Fail-safe retention time period for transient tables?

Options:

A.

1 day

B.

7 days

C.

12 hours

D.

0 days

Buy Now
Questions 186

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

Buy Now
Questions 187

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

Options:

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;

Buy Now
Questions 188

What is the minimum Snowflake edition required to use Dynamic Data Masking?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPC)

Buy Now
Questions 189

Which of the following describes a Snowflake stored procedure?

Options:

A.

They can be created as secure and hide the underlying metadata from the user.

B.

They can only access tables from a single database.

C.

They can contain only a single SQL statement.

D.

They can be created to run with a caller's rights or an owner's rights.

Buy Now
Questions 190

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 191

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 192

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

Options:

A.

VIEWS_HISTORY

B.

OBJECT_HISTORY

C.

ACCESS_HISTORY

D.

LOGIN_HISTORY

Buy Now
Questions 193

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

Options:

A.

Whether or not it is also a secure view

B.

How often the underlying base table is queried

C.

How often the base table changes

D.

Whether the materialized view has a cluster key defined

E.

How often the materialized view is queried

Buy Now
Questions 194

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