Snowflake Test-26

Welcome to your Snowflake Test-26

Name

Phone

Q1. How does Snowflake handle the bulk unloading of data into single or multiple files?

Select 1 option(s):

It uses COPY INTO to copy the data from a table into one or more files in an external stage only.

It uses the PUT command to download the data by default.

It assigns each unloaded data file a unique name.

It uses COPY INTO for bulk unloading where the default option is SINGLE = TRUE.

Q2. What is the default period of time the Warehouse Activity section provides a graph of Snowsight activity?

Select 1 option(s):

2 hours

2 weeks

1 week

1 month

Q3. How many resource monitors can be applied to a single virtual warehouse?

Select 1 option(s):

One

Zero

Eight

Unlimited

Q4. How often are encryption keys automatically rotated by Snowflake?

Select 1 option(s):

365 Days

30 Days

90 Days

60 Days

Q5. What common query issues can be identified using the Query Profile? (Choose two.)

Select 2 option(s):

Data masking

Exploding joins

Unions

Data classification

Inefficient pruning

Q6. Snowflake strongly recommends that all users with what type of role be required to use Multi-Factor Authentication (MFA)?

Select 1 option(s):

ACCOUNTADMIN

USERADMIN

SECURITYADMIN

SYSADMIN

Q7. What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?

Select 1 option(s):

1 Gigabyte (GB)

1 Terabyte (TB)

1 Kilobyte (KB)

1 Megabyte (MB)

Q8. Which use case will always cause an exploding join in Snowflake?

Select 1 option(s):

A query that has requested too many columns of data.

A query that is using a UNION without an ALL.

A query that has not specified join criteria for tables.

A query that has more than 10 left outer joins.

Q9. What happens when the size of a virtual warehouse is changed?

Select 1 option(s):

Queries that are running on the current warehouse configuration are aborted and have to be resubmitted by the user.

Queries that are running on the current warehouse configuration are aborted and are automatically resubmitted.

Queries that are running on the current warehouse configuration are moved to the new configuration and finished there.

Queries that are running on the current warehouse configuration are not impacted.

Q10. Which command should a Snowflake user execute to load data into a table?

Select 1 option(s):

copy into mytable file_format = (format_name);

copy into mytable purge_mode = TRUE;

copy into mytable validation = ‘RETURN_ERRORS’;

copy into mytable from @my_int_stage;

Q11. A Snowflake user is writing a User-Defined Function (UDF) with some unqualified object names.

Select 1 option(s):

How will those object names be resolved during execution?

Snowflake will first check the current schema, and then the schema the previous query used.

Snowflake will first check the current schema, and then the PUBLIC schema of the current database.

Snowflake will only check the schema the UDF belongs to.

Snowflake will resolve them according to the SEARCH_PATH parameter.

Q12. What Snowflake function should be used to unload relational data to JSON?

Select 1 option(s):

BUILD_STAGE_FILE_URL()

PARSE_JSON()

TO_VARIANT()

OBJECT_CONSTRUCT()

Q13. What unit of storage supports efficient query processing in Snowflake?

Select 1 option(s):

Block storage

Blobs

JSON

Micro-partitions

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

Select 1 option(s):

STORAGE_USAGE

STORAGE_DAILY_HISTORY

TABLE_STORAGE_METRICS

TABLES

Q15. How are URLs that access unstructured data in external stages retrieved?

Select 1 option(s):

By creating an external function

From the Snowsight navigation menu

By using the INFORMATION_USAGE schema

By querying a directory table

Q16. A Snowflake user wants to share data with someone who does not have a Snowflake account.

How can the Snowflake user share the data?

Select 1 option(s):

Create a reader account.

Use the Snowflake Marketplace.

Create a consumer account.

Use a Snowflake share.

Q17. The following SQL statements have been executed:

What will the output be of the last select statement?

Select 1 option(s):

Q18. A Snowflake user has been granted the CREATE DATA EXCHANGE LISTING privilege with their role.

Which tasks can this user now perform on the Data Exchange? (Choose two.)

Select 2 option(s):

Rename listings

Modify incoming listing access requests

Modify listings properties

Submit listings for approval/publishing

Delete provider profiles

Q19. Which Snowflake object can be accessed in the FROM clause of a query, returning a set of rows having one or more columns?

Select 1 option(s):

A User-Defined Table Function (UDTF)

A stored procedure

A Scalar User Defined Function (UDF)

A task

Q20. Which data types are valid in Snowflake? (Choose two.)

Select 2 option(s):

CLOB

JSON

BLOB

Variant

Geography

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

Select 1 option(s):

8 hours

1 hour

4 hours

2 hours

Q22. Which file function provides a URL with access to a file on a stage without the need for authentication and authorization?

Select 1 option(s):

GET_RELATIVE_PATH

GET_PRESIGNED_URL

BUILD_SCOPED_FILE_URL

BUILD_STAGE_FILE_URL

Q23. What is used to extract the content of PDF files stored in Snowflake stages?

Select 1 option(s):

Window function

HyperLogLog (HLL) function

FLATTEN function

Java User-Defined Function (UDF)

Q24. What is a characteristic of a role in Snowflake?

Select 1 option(s):

Privileges granted to system roles by Snowflake can be revoked.

Roles cannot be granted to other roles.

System-defined roles can be dropped.

Privileges on securable objects can be granted and revoked to a role.

Q25. Which function should be used to find the query ID of the second query executed in a current session?

Select 1 option(s):

Q26. Which clustering indicator will show if a large table in Snowflake will benefit from explicitly defining a clustering key?

Select 1 option(s):

Total partition count

Ratio

Depth

Percentage

Q27. When should a stored procedure be created with caller‘s rights?

Select 1 option(s):

When the caller needs to run a statement that could not execute outside of the stored procedure

When the stored procedure needs to operate on objects that the caller does not have privileges on

When the stored procedure needs to run with the privileges of the role that called the stored procedure

When the caller needs to be prevented from viewing the source code of the stored procedure

Q28. A Query Profile shows a UnionAll operator with an extra Aggregate operator on top.

What does this signify?

Select 1 option(s):

Queries that are too large to fit in memory

Inefficient pruning

Exploding joins

UNION without ALL

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

Select 1 option(s):

24 hours

14 days

60 minutes

30 days

Q30. Other than ownership what privileges does a user need to view and modify resource monitors in Snowflake? (Choose two.)

Select 2 option(s):

CREATE

DROP

MODIFY

ALTER

MONITOR

Q31. A Snowflake user has a query that is running for a long time. When the user opens the query profiler, it indicates that a lot of data is spilling to disk.

What is causing this to happen?

Select 1 option(s):

Clustering has not been applied to the table so the table is not optimized.

The warehouse memory is not sufficient to hold the intermediate query results.

The result cache is almost full and is unable to hold the results.

The cloud storage staging area is not sufficient to hold the data results.

Q32. 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?

Select 1 option(s):

READ

OWNERSHIP

USAGE

WRITE

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

Select 1 option(s):

100

Q34. What technique does Snowflake recommend for determining which virtual warehouse size to select?

Select 1 option(s):

Use the default size Snowflake chooses

Experiment by running the same queries against warehouses of different sizes

Always start with an X-Small and increase the size if the query does not complete in 2 minutes

Use X-Large or above for tables larger than 1 GB

Q35. Which statement describes when a virtual warehouse can be resized?

Select 1 option(s):

A resize will affect running, queued, and new queries.

A resize can only be completed when the warehouse is in an auto-resume status.

A resize must be completed when the warehouse is suspended.

A resize can be completed at any time.

Q36. What is to be expected when sharing worksheets in Snowsight?

Select 1 option(s):

Snowsight offers different sharing permissions at the worksheet, folder, and dashboard level.

Snowsight allows users to view and refresh results but not to edit shared worksheets.

To run a shared worksheet, a user must be granted the role used for the worksheet session context.

Worksheets can be shared with users that are internal or external to any organization.

Q37. How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?

Select 1 option(s):

Use the COPY command.

Use the INSERT command.

Use an external table.

Use Snowpipe.

Q38. How does the Snowflake search optimization service improve query performance?

Select 1 option(s):

It improves the performance of range searches.

It defines different clustering keys on the same source table.

It improves the performance of equality searches.

It improves the performance of all queries running against a given table.

Q39. Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? (Choose two.)

Select 2 option(s):

SQL

Ruby

Javascript

PERL

Q40. Which statements reflect valid commands when using secondary roles? (Choose two.)

Select 2 option(s):

USE SECONDARY ROLES SUSPEND

USE SECONDARY ROLES NONE

USE SECONDARY ROLES ALL

USE SECONDARY ROLES RESUME

USE SECONDARY ROLES ADD

Q41. By default, which role has privileges to create tables and views in an account?

Select 1 option(s):

SECURITYADMIN

USERADMIN

SYSADMIN

PUBLIC

Q42. For the ALLOWED_VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

Select 1 option(s):

256

Q43. A Snowflake user wants to share transactional data with retail suppliers. However, some of the suppliers do not use Snowflake.

According to best practice, what should the Snowflake user do? (Choose two.)

Select 2 option(s):

Create an ETL pipeline that uses select and inserts statements from the source to the target supplier accounts.

Provide each non-Snowflake supplier with their own reader account.

Extract the shared transactional data to an external stage and use cloud storage utilities to reload the suppliers‘ regions.

Use a data share for suppliers in the same cloud region and a replicated proxy share for other cloud deployments.

Q44. Which operation will produce an error in Snowflake?

Select 1 option(s):

Inserting a value to FOREIGN KEY column that does not match a value in the column referenced

Inserting a NULL into a column with a NOT NULL constraint

Inserting duplicate values into a column with a UNIQUE constraint

Inserting duplicate values into a PRIMARY KEY column

Q45. Two users share a virtual warehouse named WH_DEV_01. When one of the users loads data, the other one experiences performance issues while querying data.

How does Snowflake recommend resolving this issue?

Select 1 option(s):

Create separate warehouses for each user

Scale up the existing warehouse

Create separate warehouses for each workload

Stop loading and querying data at the same time

Q46. User A cloned a schema and overwrote a schema that User B was working on. User B no longer has access to their version of the tables. However, this all occurred within the Time Travel retention period defined at the database level.

How should the missing tables be restored?

Select 1 option(s):

Use an UNDROP TABLE statement.

Use a CREATE TABLE AS SELECT statement

Rename the cloned schema and use an UNDROP SCHEMA statement.

Q47. What happens when a database is cloned?

Select 1 option(s):

It replicates all granted privileges on the corresponding source objects.

It replicates all granted privileges on the corresponding child objects.

It replicates all granted privileges on the corresponding child schema objects.

It does not retain any privileges granted on the source object.

Q48. What is the default compression type when unloading data from Snowflake?

Select 1 option(s):

bzip2

Brotli

gzip

Zstandard

Q49. Which Data Definition Language (DDL) commands are supported by Snowflake to manage tags? (Choose two.)

Select 2 option(s):

ALTER TAG

DROP TAG

DESCRIBE TAG

GRANT TAG

GRANT ... TO TAG

Q50. What is a characteristic of the Snowflake query profiler?

Select 1 option(s):

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

It can be used by third-party software using the query profiler API.

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

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

Q51. What does Snowflake recommend regarding database object ownership? (Choose two.)

Select 2 option(s):

Create objects with SECURITYADMIN to ease granting of privileges later.

Create objects with a custom role and grant this role to SYSADMIN.

Create objects with ACCOUNTADMIN and do not reassign ownership.

Use only managed access schemas for objects owned by ACCOUNTADMIN.

Create objects with SYSADMIN.

Q52. How do managed access schemas help with data governance?

Select 1 option(s):

They require the use of masking and row access policies across every table and view in the schema.

They provide centralized privilege management with the schema owner.

They enforce identical privileges across all tables and views in a schema.

They log all operations and enable fine-grained auditing.

Q53. Which object type is granted permissions for reading a table?

Select 1 option(s):

Attribute

User

Role

Schema

Q54. When unloading data, which file format preserves the data values for floating-point number columns?

Select 1 option(s):

CSV

JSON

Parquet

Avro

Q55. What ensures that a user with the role SECURITYADMIN can activate a network policy for an individual user?

Select 1 option(s):

Ownership privilege on both the user and the network policy

A role that has been granted the EXECUTE TASK privilege

A role that has been granted the global ATTACH POLICY privilege

Ownership privilege on only the role that created the network policy

Q56. What is the compressed size limit for semi-structured data loaded into a VARIANT data type using the COPY command?

Select 1 option(s):

8 MB

32 MB

16 MB

64 MB

Q57. When executing a COPY INTO command, performance can be negatively affected by using which optional parameter on a large number of files?

Select 1 option(s):

VALIDATION_MODE

FILES

PATTERN

FILE_FORMAT

Q58. How are micro-partitions typically generated in Snowflake?

Select 1 option(s):

ORDER BY < >;

PARTITION BY < >;

Automatically

GROUP BY < >;

Q59. Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Choose two.)

Select 2 option(s):

Row access policies

Secure views

Multi-cluster virtual warehouses

Search optimization service

Automatic clustering

Q60. How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?

Select 1 option(s):

QUERY_HISTORY

ACCESS_HISTORY

LOAD_HISTORY

REST_EVENT_HISTORY