Snowflake Test-19

Welcome to your Snowflake Test-19

Name

Phone

Q1. Which system functions are available in Snowflake to view/monitor the clustering metadata for a table? (Choose two.)

Select 2 option(s):

SYSTEM$CLUSTERING

SYSTEM$CLUSTERING_STATUS

SYSTEM$CLUSTERING_DEPTH

SYSTEM$CLUSTERING_INFORMATION

SYSTEM$CLUSTERING_METADATA

Q2. Which of the following services are NOT provided by the Cloud Services Layer? (Choose two.)

Select 2 option(s):

Query Execution.

Authentication.

Storage.

Metadata Management.

Infrastructure Management.

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

Select 1 option(s):

Select 1 option(s):

XML

CSV

JSON

Q4. Which of the following is a data tokenization integration partner?

Select 1 option(s):

Tableau

DBeaver

SAP

Protegrity

Q5. When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?

Select 1 option(s):

(14,8)

(10,4)

(12,2)

(15,9)

Q6. A user has unloaded data from Snowflake to a stage.

Which SQL command should be used to validate which data was loaded into the stage?

Select 1 option(s):

verify @file_stage

list @file_stage

view @file_stage

show @file_stage

Q7. How long is the Fail-safe period for temporary and transient tables?

Select 1 option(s):

90 days

7 days

31 days

There is no Fail-safe period for these tables.

1 day

Q8. Which roles can create shares and resource monitors?

Select 1 option(s):

SYSADMIN

SECURITYADMIN

USERADMIN

ACCOUNTADMIN

Q9. How many predecessor tasks can a child task have?

Select 1 option(s):

1000

All the parents that we establish.

100

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

Select 1 option(s):

Cluster keys

Fail-safe

Time Travel

Cloning

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

Select 1 option(s):

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

It removes the last element of the outer array.

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

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

Q12. What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

Select 1 option(s):

24 hours

7 days

48 hours

30 days

Q13. The fail-safe retention period is how many days?

Select 1 option(s):

7 days

45 days

1 day

90 days

Q14. As a best practice, clustering keys should only be defined on tables of which minimum size?

Select 1 option(s):

Multi-Kilobyte (KB) Range

Multi-Gigabyte (GB) Range

Multi-Terabyte (TB) Range

Multi-Megabyte (MB) Range

Q15. How many shares can be consumed by a single Data Consumer?

Select 1 option(s):

Unlimited

100, but can be increased by contacting support

Q16. Which of the following commands are valid options for the VALIDATION_MODE parameter within the Snowflake COPY_INTO command? (Choose two.)

Select 2 option(s):

RETURN_ERROR_SUM

RETURN_FIRST_n_ERRORS

RETURN_n_ROWS

RETURN_ALL_ERRORS

Q17. Which feature is only available in the Enterprise or higher editions of Snowflake?

Select 1 option(s):

Multi-factor Authentication (MFA)

SOC 2 type II certification

Column-level security

Object-level access control

Q18. Which of the following file formats is not supported by Snowflake?

Select 1 option(s):

XML

ORC

XLSX

Avro

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

Select 1 option(s):

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

Yes, because the new compute resource will no longer have access to the cache encryption key.

No, because the size of the cache is independent from the warehouse size.

Yes, because the compute resource is replaced in its entirety with a new compute resource.

Q20. What is common between Fivetran, Informatica, Stitch, and Talend?

Select 1 option(s):

They are Snowflake Security partners.

They are Snowflake programming interfaces partners.

They are Snowflake Business Intelligence partners.

They are Snowflake Data Integration partners.

Q21. What is the default value for the Time Travel functionality?

Select 1 option(s):

90 days.

1 day.

30 days.

It’s disabled by default.

Q22. According to Snowflake best practice recommendations, which system-defined roles should be used to create custom roles? (Choose two.)

Select 2 option(s):

ACCOUNTADMIN

ORGADMIN

SECURITYADMIN

USERADMIN

SYSADMIN

Q23. Users with the ACCOUNTADMIN role can execute which of the following commands on existing users?

Select 1 option(s):

Can SHOW users, DEFINE a given user or ALTER, DROP, or MODIFY a user

Can SHOW users DESCRIBE a given user, or ALTER or DROP a user

Can SHOW users, INDEX a given user, or ALTER or DELETE a user

Can DEFINE users, DESCRIBE a given user, or ALTER or DELETE a user

Q24. What parameter controls if the Virtual Warehouse starts immediately after the CREATE WAREHOUSE statement?

Select 1 option(s):

START_AFTER_CREATE = TRUE/FALSE

START_TIME = CURRENT_DATE()

INITIALLY_SUSPENDED = TRUE/FALSE

START_THE = 60 // (seconds from now)

Q25. Which cache can also be referred to as SSD or local cache?

Select 1 option(s):

Results cache.

Warehouse cache.

Metadata cache.

Standard cache.

Q26. What privileges are required to create a task?

Select 1 option(s):

Tasks are created at the Application level and can only be created by the Account Admin role.

The GLOBAL privilege CREATE TASK is required to create a new task.

The role must have access to the target schema and the CREATE TASK privilege on the schema itself.

Many Snowflake DDLs are metadata operations only, and CREATE TASK DDL can be executed without virtual warehouse requirement or task specific grants.

Q27. What are types of partners in the Snowflake ecosystem? (Choose two.)

Select 2 option(s):

Standard Partners.

Solution Partners.

Private Partners.

Personalized Partners.

Technology Partners.

Q28. What is the minimum Snowflake edition that provides multi-cluster warehouses?

Select 1 option(s):

Enterprise

Standard

Premier

Business Critical Edition

Q29. Which of the following describes external functions in Snowflake?

Select 1 option(s):

They contain their own SQL code.

They can return multiple rows for each row received.

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

They call code that is stored inside of Snowflake.

Q30. What happens to the incoming queries when a warehouse does not have enough resources to process them?

Select 1 option(s):

Queries are queued and executed when the warehouse has resources.

Queries are aborted.

Snowflake adds more clusters.

Snowflake resizes the warehouse.

Q31. What type of query benefits the MOST from search optimization?

Select 1 option(s):

A query that filters on semi-structured data types

A query that uses equality predicates or predicates that use IN

A query that includes analytical expressions

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

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

Select 1 option(s):

GET

INSERT

PUT

COPY

Q33. How many warehouses do you need to run to have Snowpipe constantly running?

Select 1 option(s):

You don’t need any warehouse as Snowpipe is a serverless feature.

100

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

Select 1 option(s):

Q35. What is a characteristic of data micro-partitioning in Snowflake?

Select 1 option(s):

Micro-partitioning may introduce data skew

Micro-partitioning can be disabled within a Snowflake account

Micro-partitioning happens when the data is loaded

Micro-partitioning requires the definition of a partitioning schema

Q36. Which of the following accurately represents how a table fits into Snowflake‘s logical container hierarchy?

Select 1 option(s):

Database -> Table -> Schema -> Account

Account -> Schema -> Database -> Table

Database -> Schema -> Table -> Account

Account -> Database -> Schema -> Table

Q37. What SQL command would be used to view all roles that were granted to USER1?

Select 1 option(s):

show grants user USER1;

show grants on user USER1;

show grants to user USER1;

describe user USER1;

Q38. Which of the following are options when creating a Virtual Warehouse? (Choose two.)

Select 2 option(s):

Auto-enable

Local SSD size

Auto-suspend

Auto-resume

User count

Q39. By default, the COPY INTO statement will separate table data into a set of output files to take advantage of which Snowflake feature?

Select 1 option(s):

Query acceleration

Parallel processing

Query plan caching

Time Travel

Q40. Which data types in Snowflake are synonymous for FLOAT? (Choose two.)

Select 2 option(s):

REAL

DOUBLE

NUMERIC

DECIMAL

NUMBER

Q41. Which property helps us control the credits consumed by a multi-cluster warehouse?

Select 1 option(s):

Maximum Clusters (MAX_CLUSTERS)

Maximum Credits (MAX_CREDITS)

Auto scale (AUTO_SCALE)

Scaling policy (SCALING_POLICY)

Q42. Which of the following statements are true about Schemas in Snowflake? (Choose two.)

Select 2 option(s):

Each Schema is contained within a Warehouse

A Schema is a logical grouping of Database Objects

A Database may contain one or more Schemas

In managed schemas, the object owner manages all privilege grants, including future grants, on objects in the schema.

A Schema may contain one or more Databases

Q43. What is the most granular object that the Time Travel retention period can be defined on?

Select 1 option(s):

Schema

Table

Database

Account

Q44. What privilege does a user need in order to receive or request data from the Snowflake Marketplace?

Select 1 option(s):

IMPORT SHARE

CREATE DATA EXCHANGE LISTING

CREATE SHARE

IMPORTED PRIVILEGES

Q45. Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

Select 2 option(s):

Information Schema -> TABLE_HISTORY

SHOW STORAGE BY TABLE;

Information Schema -> TABLE_STORAGE_METRICS

SHOW TABLES;

Information Schema -> TABLE_FUNCTION

Q46. Which character identifies a table stage?

Select 1 option(s):

“/@”

“%”

“@%”

“@”

Q47. The Snowflake Cloud Data Platform is described as having which of the following architectures?

Select 1 option(s):

Shared-disk

Serverless query engine

Shared-nothing

Multi-cluster shared data

Q48. How is enhanced authentication achieved in Snowflake? (Choose two.)

Select 2 option(s):

Masking policies

Snowflake-managed keys

Object level access control

Multi-Factor Authentication (MFA)

Federated authentication and Single Sign-On (SSO)

Q49. Which command can we use to restore a deleted table on Snowflake?

Select 1 option(s):

UNDROP TABLE

REBUILD TABLE

RESTORE TABLE

REPLACE TABLE

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

Select 1 option(s):

GET

COPY

PUT

SELECT

Q51. By definition, a secure view is exposed only to users with what privilege?

Select 1 option(s):

USAGE

IMPORT SHARE

REFERENCES

OWNERSHIP

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

Select 2 option(s):

A user cannot specify a default warehouse when using the ODBC driver.

Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

The default virtual warehouse size can be changed at any time.

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

Select 2 option(s):

JSON

ORC

Avro

Delimited (CSV, TSV, etc.)

XML

Q54. Which privileges are required for a user to restore an object? (Choose two.)

Select 2 option(s):

UNDROP

MODIFY

UPDATE

CREATE

OWNERSHIP

Q55. Which Snowflake objects are automatically created by default every time you create a database? (Choose two.)

Select 2 option(s):

The METADATA_SCHEMA.

The ANALYTICS_SCHEMA.

The PUBLIC schema.

The DEFAULT_SCHEMA.

The INFORMATION_SCHEMA.

Q56. Which of the following are not types of streams in Snowflake? (Choose two.)

Select 2 option(s):

Update-only.

Merge-only.

Standard.

Append-only.

Insert-only.

Q57. What is the lowest Snowflake edition that offers Time Travel up to 90 days?

Select 1 option(s):

Business Critical Edition

Premier Edition

Standard Edition

Enterprise Edition

Q58. What statements about Fail-Safe are false? (Choose two.)

Select 2 option(s):

There is no difference between Time-Travel and Fail-Safe.

Fail-Safe provides a non-configurable 90-day period.

Fail-Safe ensures that historical data is protected in the event of a system failure or other catastrophic events.

Fail-Safe provides a non-configurable 7-day period.

The data retention period for a permanent table with 30 days of Time-Travel is 37 days.

Q59. What statement is true about Snowflake’s unique architecture?

Select 1 option(s):

One Node Private Data.

One Node Shared Data.

Multi-Cluster Shared Data.

Multi-Cluster Private Data.

Q60. In which different ways can we query historical data? (Choose three.)

Select 3 option(s):

By user.

By query statement ID.

By offset.

By timestamp.

By session.

By backup.