Snowflake Test-18

Welcome to your Snowflake Test-18

Name

Phone

Q1. Which of the following is true of Snowpipe via REST API? (Choose two.)

Select 2 option(s):

Snowpipe removes files after they have been loaded

Snowflake automatically manages the compute required to execute the Pipe‘s COPY INTO commands

Snowpipe keeps track of which files it has loaded

All COPY INTO options are available during pipe creation

You can only use it on Internal Stages

Q2. Which columns are available in the output of a Snowflake directory table? (Choose two.)

Select 2 option(s):

STAGE_NAME

CATALOG_NAME

RELATIVE_PATH

LAST_MODIFIED

FILE_NAME

Q3. Which of the following roles are NOT System-Defined Roles in Snowflake? (Choose two.)

Select 2 option(s):

STORAGEADMIN

SYSADMIN

SECURITYADMIN

VIEWER

USERADMIN

Q4. Which of the following Snowflake features provide continuous data protection automatically? (Choose two.)

Select 2 option(s):

Incremental backups

Zero-copy clones

Fail-safe

Time Travel

Internal stages

Q5. What is the recommended Snowflake data type to store semi-structured data like JSON?

Select 1 option(s):

LOB

VARIANT

RAW

VARCHAR

Q6. Which of the following roles is recommended to be used to create and manage users and roles?

Select 1 option(s):

SECURITYADMIN

PUBLIC

SYSADMIN

ACCOUNTADMIN

Q7. A query executed a couple of hours ago, which spent more than 5 minutes to run, is executed again, and it returned the results in less than a second. What might have happened?

Select 1 option(s):

Snowflake used the persisted query results from the metadata cache. Snowflake used the persisted query results from the metadata cache.

Snowflake used the persisted query results from the query result cache.

Snowflake used the persisted query results from the warehouse cache.

A new Snowflake version has been released in the last two hours, improving the speed of the service.

Q8. Which of the following commands are not blocking operations? (Choose two.)

Select 2 option(s):

DELETE

MERGE

COPY

INSERT

UPDATE

Q9. Where can we see the amount of storage used by Snowflake‘s Fail-Safe functionality in the User Interface?

Select 1 option(s):

In the Account & Fail-Safe section.

In the Account & Billing section.

In the Account & Sessions section.

In the Account & Usage section.

Q10. How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with the shorteset delay possible?

Select 1 option(s):

Configure the warehouse to a size larger than generally required

Use the economy warehouse scaling policy

Use the standard warehouse scaling policy

Set the minimum and maximum clusters to autoscale

Q11. How can a Snowflake user configure a virtual warehouse to support over 100 users if their company has Enterprise Edition?

Select 1 option(s):

Use a larger warehouse.

Set the auto-scale to 100.

Add additional warehouses and configure them as a cluster.

Use a multi-cluster warehouse.

Q12. What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?

Select 1 option(s):

ACCOUNTADMIN

SYSADMIN

SECURITYADMIN

ORGADMIN

Q13. Account-level storage usage can be monitored via:

Select 1 option(s):

The Information Schema -> ACCOUNT_USAGE_HISTORY View

The Snowflake Web Interface (UI) in the Account -> Billing & Usage section

The Snowflake Web Interface (UI) in the Databases section

The Account Usage Schema -> ACCOUNT_USAGE_METRICS View

Q14. Which of the following statements will return the required information?

Select 1 option(s):

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
FROM ACCOUNT_USAGE.USERS;

SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user())

SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.LOGIN_HISTORY;

SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.ACCESS_HISTORY;

Q15. Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

Select 1 option(s):

To accommodate a more complex workload

To accommodate more queries

To accommodate more users

To accommodate fluctuations in workload

Q16. What does a Query Profile provide in Snowflake?

Select 1 option(s):

A pre-computed data set derived from a query specification and stored for later use.

A graphical representation of the main components of the processing plan for a query.

A collapsible panel in the operator tree pane that lists nodes by execution time in descending order for a query.

A multi-step query that displays each processing step in the same panel.

Q17. Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

Select 1 option(s):

Scaling up

Scaling max

Scaling out

Scaling rhythmically

Q18. Which of the following connectors are available in the Downloads section of the Snowflake Web Interface (UI)? (Choose two.)

Select 2 option(s):

JDBC Driver

HIVE

SnowSQL

ODBC Driver

Q19. What types of views are available in Snowflake? (Choose three.)

Select 3 option(s):

Materialized View

External View

Table View

Regular

Secure View

Private View

Q20. If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

Select 1 option(s):

128

Q21. What is the Snowflake multi-clustering feature for virtual warehouses used for?

Select 1 option(s):

To improve concurrency for users and queries

To improve data loading from very large data sets

To improve the data unloading process to the cloud

To speed up slow or stalled queries

Q22. How does a scoped URL expire?

Select 1 option(s):

The length of time is specified in the expiration_time argument.

When the persisted query result period ends.

When the data cache clears.

The encoded URL access is permanent.

Q23. A Snowflake query took 40 minutes to run. The results indicate that ‘Bytes spilled to local storage’ was a large number.

What is the issue and how can it be resolved?

Select 1 option(s):

The Snowflake console has timed-out. Contact Snowflake Support.

The warehouse is too large. Decrease the size of the warehouse to reduce the spillage.

The warehouse is too small. Increase the size of the warehouse to reduce the spillage.

The warehouse consists of a single cluster. Use a multi-cluster warehouse to reduce the spillage.

Q24. Which Snowflake object stores a generated identity and access management (IAM) entity for your external cloud storage, along with an optional set of allowed or blocked storage locations (Amazon S3, Google Cloud Storage, or Microsoft Azure)?

Select 1 option(s):

Storage Schema.

User Stage.

Storage Integration.

Security Integration.

Q25. Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflake?

Select 1 option(s):

SESSIONS

QUERY_HISTORY

ACCESS_HISTORY

LOGIN_HISTORY

Q26. What are the available Snowflake scaling modes for configuring multi-cluster virtual warehouses? (Choose two.)

Select 2 option(s):

Standard

Economy

Auto-Scale

Maximized

Scale-Out

Q27. What object will you use to schedule a merge statement in Snowflake so that it runs every hour?

Select 1 option(s):

Pipe.

Table.

Stream

Task.

Q28. What is the use of the OVERWRITE=TRUE option in the PUT command?

Select 1 option(s):

It is not possible to use OVERWRITE=TRUE option with PUT command.

It specifies whether Snowflake overwrites an existing file with the same name during upload.

It specified whether Snowflake overwrites the encryption key you used to upload the files.

It specified whether Snowflake should overwrite the gzip compress algorithm with another one that you provide.

Q29. Which of the following statements is true of zero-copy cloning?

Select 1 option(s):

At the instance/instant a clone is created, all micro-partitions in the original table and the clone are fully shared

All zero-copy clone objects inherit the privileges of their original objects

Zero-copy clones increase storage costs as cloning the table requires storing its data twice

Zero-copy cloning is licensed as an additional Snowflake feature

Q30. What is common between AWS Quicksight, PowerBI, and Tableau?

Select 1 option(s):

They are Snowflake Security & Governance Partners.

They are Snowflake Data Integration Partners.

They are Snowflake Business Intelligence Partners.

They are Snowflake Machine Learning Partners.

Q31. To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

Select 1 option(s):

Configure the Maximum Clusters setting to Auto-Scale

Set the Minimum Clusters and Maximum Clusters settings to the same value

Set the Minimum Clusters and Maximum Clusters settings to the different values

Set the Warehouse type to Auto

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

Select 1 option(s):

PUBLIC

ORGADMIN

SYSADMIN

USERADMIN

Q34. How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

Select 1 option(s):

The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer‘s account

The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

Q34. Which of the following sentences is an example of scaling up for a Snowflake virtual Warehouse?

Select 1 option(s):

Adding a new virtual warehouse of the same size.

Request more data storage to our Cloud Provider.

Change from Economy Scaling Policy to Standard.

Changing the size of a warehouse from L to XL.

Q35. Which of the following terms best describes Snowflake‘s database architecture?

Select 1 option(s):

Shared disk

Multi-cluster, shared data

Cloud-native shared memory

Columnar shared nothing

Q36. What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Select 1 option(s):

Enterprise

Business Critical Edition

Standard

Premier

Q37. The three main Snowflake layers are…

Select 1 option(s):

Extraction, Load, Transformation.

Database, Virtual Warehouse, Metadata.

Centralized Storage, Compute & Cloud Services.

Staging, Data Warehouse, Dimensional.

Q38. Which Snowflake partner specializes in data catalog solutions?

Select 1 option(s):

Alation

dbt

Tableau

DataRobot

Q39. When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

Select 1 option(s):

The REFRESH parameter is set to TRUE

Previoulsy loaded files will be purged

The Pipe load history is reset to empty

Previously loaded files will be ignored

Q40. What is the maximum row size in Snowflake?

Select 1 option(s):

500MB

50MB

8KB

16MB

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

Select 1 option(s):

Task

Masking policy

External table

Stored procedure

Q42. A user has a standard multi-cluster warehouse auto-scaling policy in place.

Which condition will trigger a cluster to shut-down?

Select 1 option(s):

When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

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

Select 1 option(s):

1000-1500 MB

100-250 MB

10-50 MB

300-500 MB

Q44. Queries in Snowflake are getting queued on the warehouses and delaying the ETL processes of the company. What are the possible solution options you can think of, considering we have the Snowflake Enterprise edition? (Choose two.)

Select 2 option(s):

Use a multi-cluster warehouse.

Upgrade Snowflake edition

Set auto-resize parameter to TRUE.

Contact Snowflake support to increase the size of the warehouse.

Resize the warehouse.

Q45. What is the minimum Snowflake edition that provides data sharing?

Select 1 option(s):

Premier

Business Critical Edition

Standard

Enterprise

Q46. Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose two.)

Select 2 option(s):

Compute and storage can be scaled together.

Growth of storage and compute are tightly coupled.

Use of storage avoids disk spilling.

Storage expands without the requirement to add more compute.

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

Q47. Which Snowflake object returns a set of rows instead of a single, scalar value, and can be accessed in the FROM clause of a query?

Select 1 option(s):

There is no object in Snowflake with the ability to return a set of rows

Stored procedure

UDF

UDTF

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

Select 2 option(s):

Virtual Private Snowflake

Enterprise Edition

Custom Edition

Business Critical Edition

Standard Edition

Q49. Which of these features is NOT supported by Snowflake?

Select 1 option(s):

Manage the data that 3rd party applications upload to the marketplace.

Manage roles.

Manage users.

Monitor usage and cost.

Q50. Which of the following statements is true of Snowflake?

Select 1 option(s):

It was built as an on-premises solution and then ported to the cloud

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

It was built specifically for the cloud

It was built for Hadoop Architecture

Q51. Which properties of a Resource Monitor can be modified?

Select 1 option(s):

Credit Quota, Monitor Level, Schedule, Actions.

Monitor Level, Schedule, Actions.

Credit Quota, Schedule, Actions.

Schedule, Actions.

Credit Quota, Monitor Level, Schedule.

Q52. What actions can the resource monitor associated with a Warehouse take when it reaches (or is about to) hit the limit? (Choose three.)

Select 3 option(s):

Delete the Snowflake account.

Suspend the Warehouse.

Open a Snowflake support case

Execute DROP WAREHOUSE statement.

Send a notification alert.

Kill the query that is running.

Q53. How many resource monitors can be assigned at the account level?

Select 1 option(s):

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

Select 1 option(s):

LOGIN_HISTORY

ACCESS_HISTORY

OBJECT_HISTORY

VIEWS_HISTORY

Q55. What are the responsibilities of Snowflake‘s Cloud Service layer? (Choose three.)

Select 3 option(s):

Virtual warehouse caching

Metadata management

Authentication

Physical storage of micro-partitions

Query execution

Query parsing and optimization

Q56. Which certifications are compliant with Snowflake? (Choose three.)

Select 3 option(s):

FedRAMP.

PCI-DSS.

ISO 9000.

SC-900.

HIPAA.

Q57. Which statements are NOT correct about micro-partitions in Snowflake? (Choose two.)

Select 2 option(s):

Contiguous units of storage.

Non-contiguous units of storage.

50 and 500MB of compressed data.

50 and 500MB of uncompressed data.

Organized in a columnar way.

Q58. Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

Select 2 option(s):

The VALIDATION_MODE option will validate data to be loaded by the COPY statement while completing the load and will return the rows that could not be loaded without error

The VALIDATION_MODE parameter supports COPY statements that load data from external stages only

VALIDATION_MODE=RETURN_ALL_ERRORS is a parameter of the COPY command

The VALIDATION_MODE parameter supports COPY statements that transform data during a load

The VALIDATION_MODE option will validate data to be loaded by the COPY statement without completing the load and will return possible errors

Q59. What is the main function of Business Intelligence tools (e.g., Tableau or Quicksight)?

Select 1 option(s):

Create charts from Snowflake data to give more business insights.

Extract data from other source systems and move them into Snowflake stages.

Carry out Machine Learning analysis.

Transform data from other source systems and move them into Snowflake stages.

Q60. Which of the following view types are available in Snowflake? (Choose two.)

Select 2 option(s):

Embedded view

Layered view

Secure view

Materialized view

External view

Snowflake Test-18

Q1. Which of the following is true of Snowpipe via REST API? (Choose two.)

Q2. Which columns are available in the output of a Snowflake directory table? (Choose two.)

Q3. Which of the following roles are NOT System-Defined Roles in Snowflake? (Choose two.)

Q4. Which of the following Snowflake features provide continuous data protection automatically? (Choose two.)

Q5. What is the recommended Snowflake data type to store semi-structured data like JSON?

Q6. Which of the following roles is recommended to be used to create and manage users and roles?

Q7. A query executed a couple of hours ago, which spent more than 5 minutes to run, is executed again, and it returned the results in less than a second. What might have happened?

Q8. Which of the following commands are not blocking operations? (Choose two.)

Q9. Where can we see the amount of storage used by Snowflake‘s Fail-Safe functionality in the User Interface?

Q10. How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with the shorteset delay possible?

Q11. How can a Snowflake user configure a virtual warehouse to support over 100 users if their company has Enterprise Edition?

Q12. What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?

Q13. Account-level storage usage can be monitored via:

Q14. Which of the following statements will return the required information?

Q15. Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

Q16. What does a Query Profile provide in Snowflake?

Q17. Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

Q18. Which of the following connectors are available in the Downloads section of the Snowflake Web Interface (UI)? (Choose two.)

Q19. What types of views are available in Snowflake? (Choose three.)

Q20. If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

Q21. What is the Snowflake multi-clustering feature for virtual warehouses used for?

Q22. How does a scoped URL expire?

Q23. A Snowflake query took 40 minutes to run. The results indicate that ‘Bytes spilled to local storage’ was a large number.

Q24. Which Snowflake object stores a generated identity and access management (IAM) entity for your external cloud storage, along with an optional set of allowed or blocked storage locations (Amazon S3, Google Cloud Storage, or Microsoft Azure)?

Q25. Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflake?

Q26. What are the available Snowflake scaling modes for configuring multi-cluster virtual warehouses? (Choose two.)

Q27. What object will you use to schedule a merge statement in Snowflake so that it runs every hour?

Q28. What is the use of the OVERWRITE=TRUE option in the PUT command?

Q29. Which of the following statements is true of zero-copy cloning?

Q30. What is common between AWS Quicksight, PowerBI, and Tableau?

Q31. To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

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

Q34. How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

Q34. Which of the following sentences is an example of scaling up for a Snowflake virtual Warehouse?

Q35. Which of the following terms best describes Snowflake‘s database architecture?

Q36. What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Q37. The three main Snowflake layers are…

Q38. Which Snowflake partner specializes in data catalog solutions?

Q39. When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

Q40. What is the maximum row size in Snowflake?

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

Q42. A user has a standard multi-cluster warehouse auto-scaling policy in place.

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

Q44. Queries in Snowflake are getting queued on the warehouses and delaying the ETL processes of the company. What are the possible solution options you can think of, considering we have the Snowflake Enterprise edition? (Choose two.)

Q45. What is the minimum Snowflake edition that provides data sharing?

Q46. Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose two.)

Q47. Which Snowflake object returns a set of rows instead of a single, scalar value, and can be accessed in the FROM clause of a query?

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

Q49. Which of these features is NOT supported by Snowflake?

Q50. Which of the following statements is true of Snowflake?

Q51. Which properties of a Resource Monitor can be modified?

Q52. What actions can the resource monitor associated with a Warehouse take when it reaches (or is about to) hit the limit? (Choose three.)

Q53. How many resource monitors can be assigned at the account level?

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

Q55. What are the responsibilities of Snowflake‘s Cloud Service layer? (Choose three.)

Q56. Which certifications are compliant with Snowflake? (Choose three.)

Q57. Which statements are NOT correct about micro-partitions in Snowflake? (Choose two.)

Q58. Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

Q59. What is the main function of Business Intelligence tools (e.g., Tableau or Quicksight)?

Q60. Which of the following view types are available in Snowflake? (Choose two.)

Contact Us