Snowflake Test-21

Welcome to your Snowflake Test-21

Name

Phone

Q1. For how long are we billed if our warehouse runs for 48 seconds?

Select 1 option(s):

We are not going to be billed if the query scans less than 10 micro-partitions.

1 minute.

We are not going to be billed as the warehouse hasn’t run for 1 minute.

48 seconds.

Q2. How does a Snowflake user reference a directory table created on stage mystage in a SQL query?

Select 1 option(s):

Q3. The information schema provides storage information for which of the following objects? (Choose two.)

Select 2 option(s):

Users

Roles

Resource monitors

Pipes

Databases

Q4. What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Choose two.)

Select 2 option(s):

The use of warehouse indexing

The ability to resize warehouses

The use of warehouse auto scaling

Use of multi-clustered warehouses

The ability to scale up warehouses

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

Select 1 option(s):

SINGLE=FALSE

SINGLE=TRUE

MULTIPLE=FALSE

MULTIPLE=TRUE

Q6. What action can a Resource Monitor not take when it hits the limit?

Select 1 option(s):

Notify & Suspend Immediately.

Notify & Increase the limit.

Notify.

Notify & Suspend.

Q7. Which command can be added to the COPY command to make it load all files, whether or not the load status of the files is known?

Select 1 option(s):

FORCE = TRUE

FORCE = FALSE

LOAD_UNCERTAIN_FILES = FALSE

LOAD_UNCERTAIN_FILES = TRUE

Q8. Which database objects can be shared using Snowflake Secure Data Sharing?

Select 1 option(s):

Tables, External tables, Secure views.

Tables, External tables, Secure views, Secure materialized views.

Tables, External tables.

Tables.

Tables, External tables, Secure views, Secure materialized views, Secure UDFs.

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

Select 1 option(s):

Access history

Object tagging

Data classification

Dynamic Data Masking

Q10. Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

Select 2 option(s):

Data is live, ready-to-query, and can be personalized.

Data is not available for copying or moving to an individual Snowflake account.

Data is available without copying or moving.

Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

Data needs to be loaded into a cloud provider as a consumer account.

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

Select 2 option(s):

Whether or not it is also a secure view

Whether the materialized view has a cluster key defined

How often the underlying base table is queried

How often the base table changes

How often the materialized view is queried

Q12. In the Snowflake access control model, which entity owns an object by default?

Select 1 option(s):

The user who created the object

The role used to create the object

Ownership depends on the type of object

The SYSADMIN role

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

Select 1 option(s):

Enterprise

Virtual Private Snowflake (VPC)

Standard

Business Critical

Q14. Which statement is true about running tasks in Snowflake?

Select 1 option(s):

A task can be executed using a SELECT statement to run a predefined SQL command.

A task can be called using a CALL statement to run a set of predefined SQL commands.

A task allows a user to execute a set of SQL commands on a predefined schedule.

A task allows a user to execute a single SQL statement/command using a predefined schedule.

Q15. Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

Select 2 option(s):

Secure User-Defined Functions (UDFs)

Streams

Files

Sequences

External tables

Q16. How many credits will consume a medium-size warehouse with 2 clusters running in auto-scaled mode for 3 hours, considering that the first cluster runs continuously and the second one runs for 30 minutes in the second hour?

Select 1 option(s):

Q17. Using COPY INTO command, to which locations is not possible to unload data from a table?

Select 1 option(s):

Named external stage that references an external location (Amazon S3, Google Cloud Storage, or Microsoft Azure).

Named internal stage (or table/user stage).

An external location like Amazon S3 or Azure.

Local Drive.

Q18. Which Query Profile result indicates that a warehouse is sized too small?

Select 1 option(s):

Bytes are spilling to external storage.

The number of processed rows is very high.

The number of partitions scanned is the same as partitions total.

There are a lot of filter nodes.

Q19. How is the data storage cost computed for Snowflake?

Select 1 option(s):

Based on the average daily amount of uncompressed data stored.

Based on the average daily amount of compressed data stored.

Based on the amount of compressed data stored on the last day of the month.

Based on the amount of uncompressed data stored on the last day of the month.

Q20. You have the following data in a variant column from the table “myTable”. How can you query the favorite technology that Gonzalo uses?

{
“name“: “Chris Snow“,
“favouriteTechnology“: Snowflake,
“hobbies“:[
{“name“: “soccer“},
{“name“: “music“},
{“name“: “hiking“}
]}

Select 1 option(s):

Q21. A sales table FCT_SALES has 100 million records.

The following query was executed:
SELECT COUNT (1) FROM FCT_SALES;
How did Snowflake fulfill this query?

Select 1 option(s):

Query against the most-recently created micro-partition

Query against the metadata cache

Query against a virtual warehouse cache

Query against the result set cache

Q22. Which of the following file formats are supported by Snowflake? (Choose three.)

Select 3 option(s):

XLSX.

HTML.

TXT.

CSV.

XML.

Avro.

Q23. A warehouse ran for 62 seconds, and it was suspended. After some time, it ran for another 20 seconds. For how many seconds will you be billed?

Select 1 option(s):

20 seconds.

62 seconds.

92 seconds.

122 seconds.

Q24. A user has unloaded data from a Snowflake table to an external stage.

Which command can be used to verify if data has been uploaded to the external stage named my_stage?

Select 1 option(s):

show @my_stage

view @my_stage

list @my_stage

display @my_stage

Q25. Snowflake‘s approach to access control combines aspects of two different models. One model remarks, “each object has an owner, who can in turn grant access to that object“. What is the name of this model?

Select 1 option(s):

Discretionary Access Control (DAC)

Role-based Access Control (RBAC)

Account ownership model.

Object ownership model.

Q26. When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of queries is always queuing in the warehouse.

According to recommended best practice, what should be done to reduce the queue volume? (Choose two.)

Select 2 option(s):

Stop and start the warehouse to clear the queued queries.

Use multi-clustered warehousing to scale out warehouse capacity.

Migrate some queries to a new warehouse to reduce load.

Limit user access to the warehouse so fewer queries are run against it.

Scale up the warehouse size to allow queries to execute faster.

Q27. Which command will you run to list all users and roles to which a role has been granted?

Select 1 option(s):

SHOW USERS OF ROLE

SHOW GRANTS TO ROLE

SHOW GRANTS IN ROLE

SHOW GRANTS OF ROLE

Q28. What is the abbreviated form to get all the files in the stage for the current user?

Select 1 option(s):

LS @usr;

SHOW @%;

LIST @~;

LS @~;

Q29. In which Snowflake edition is Tri-Secret Secure option available?

Select 1 option(s):

Business Critical or higher.

Standard or higher.

Enterprise or higher.

Tri-Secret Secure option is not available.

Q30. If you want a dedicated virtual warehouse, which is the lowest Snowflake edition you should opt for?

Select 1 option(s):

Enterprise.

Business Critical.

Virtual Private Snowflake.

Standard.

Q31. What is the MAXIMUM number of days that Snowflake resets the 24-hour retention period for a query result every time the result is used?

Select 1 option(s):

1 day

31 days

60 days

10 days

Q32. What is a limitation of a Materialized View?

Select 1 option(s):

A Materialized View cannot be joined with other tables

A Materialized View can only reference up to two tables

A Materialized View cannot be defined with a JOIN

A Materialized View cannot support any aggregate functions

Q33. What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Select 1 option(s):

Adobe

Data Robot

Power BI

Informatica

Q34. What can be used to view warehouse usage over time? (Choose two.)

Select 2 option(s):

The SHOW WAREHOUSES command

The WAREHOUSE_METERING_HISTORY view

The LOAD HISTORY view

The query history view

The billing and usage tab in the Snowflake web UI

Q35. What option will you specify to delete the stage files after a successful load into a Snowflake table with the COPY INTO command?

Select 1 option(s):

REMOVE = TRUE

DELETE = TRUE

TRUNCATE = TRUE

PURGE = TRUE

Q36. What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

Select 1 option(s):

Standard Edition

Virtual Private Snowflake (VPS)

Enterprise Edition

Business Critical Edition

Q37. Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Select 1 option(s):

Cloud services layer

Cloud infrastructure layer

Storage layer

Compute layer

Q38. In (at least), how many availability zones does Snowflake replicate your data to?

Select 1 option(s):

Two.

One.

Three.

It depends of the Snowflake Edition.

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

Select 2 option(s):

Internal stage

Table

Schema

View

Role

User

Q40. A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed
When the user returns, how much billable compute time will have been consumed?

Select 1 option(s):

10 minutes

24 minutes

4 minutes

14 minutes

Q41. Where can a user find and review the failed logins of a specific user for the past 30 days?

Select 1 option(s):

The USERS view in ACCOUNT_USAGE

The SESSIONS view in ACCOUNT_USAGE

The LOGIN_HISTORY view in ACCOUNT_USAGE

The ACCESS_HISTORY view in ACCOUNT_USAGE

Q42. A task went into a loop. How long will the task run before Snowflake finishes it?

Select 1 option(s):

60 minutes.

15 minutes.

30 minutes.

4 hours.

Q43. Which Snowflake tool would be BEST to troubleshoot network connectivity?

Select 1 option(s):

SnowSQL

SnowCD

SnowUI

SnowCLI

Q44. Which of the following accurately describes shares?

Select 1 option(s):

Access to a share cannot be revoked once granted

Tables, secure views, and secure UDFs can be shared

Data consumers can clone a new table from a share

Shares can be shared

Q45. Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?

Select 1 option(s):

Enterprise

Business Critical

Virtual Private Snowflake (VPS)

Standard

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

Select 2 option(s):

Time Travel

External stages

Tri-Secret Secure

Data encryption

Fail-safe

Q47. Which data types does Snowflake support when querying semi-structured data? (Choose two.)

Select 2 option(s):

BLOB

VARCHAR

VARIANT

ARRAY

XML

Q48. A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.

How can this be accomplished?

Select 1 option(s):

Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Contact Snowflake Support to have the data retrieved from Fail-safe storage.

Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

The transient table version cannot be retrieved after 24 hours.

Q49. What data type should be used to store JSON data natively in Snowflake?

Select 1 option(s):

JSON

Object

VARIANT

String

Q50. How can a producer share a table with a consumer located in a different region?

Select 1 option(s):

Create a script to replicate your data in the consumer account.

Replicate your account to another region and create a share from that region.

Unload all data to a stage and then deploy a pipeline to move data to the consumer‘s stage in other region.

This is not a problem; producers and consumers can be in different regions.

Q51. What would happen if we executed the following command?

CREATE OR REPLACE TABLE newTable
CLONE table1;

Select 1 option(s):

“newTable” is created, and Snowflake internally executes a pipe to copy all the data from “table1”

“newTable” is created, and Snowflake internally executes a batch job to copy all the data from “table1”

“newTable” is created with all the data from “table1”

Snowflake creates a new entry in the metadata store to keep track of the new clone. The existing micro-partitions of “table1” are mapped to the new table.

Q52. Why would a Snowflake user create a secure view instead of a standard view?

Select 1 option(s):

With a secure view, the underlying data is replicated to a separate storage layer with enhanced encryption.

The secure view is only available to end users with the corresponding SECURE_ACCESS property.

End users are unable to see the view definition, and internal optimizations differ with a secure view.

Secure views support additional functionality that is not supported for standard views, such as column masking and row level access policies.

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

Select 2 option(s):

A Snowflake account can both provide and consume shared data.

The Data Consumer pays only for compute resources to query the shared data.

The Data Consumer pays for data storage as well as for data computing.

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

Q54. What should be considered when deciding to use a Secure View? (Choose two.)

Select 2 option(s):

Secure views do not take advantage of the same internal optimizations as standard views.

It is not possible to create secure materialized views.

The view definition of a secure view is still visible to users by way of the information schema.

No details of the query execution plan will be available in the query profiler.

Once created there is no way to determine if a view is secure or not.

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

Select 1 option(s):

Clustering

Search Optimization Service

Zero-copy Cloning

Materialized Views

Q56. Which of the following commands cannot be executed from the Snowflake UI? (Choose two.)

Select 2 option(s):

LIST

GET.

PUT.

COPY INTO.

SHOW.

Q57. Which of the following roles or privileges are required to view the table function TASK_HISTORY? (Choose three.)

Select 3 option(s):

SYSADMIN.

ACCOUNTADMIN.

MONITOR EXECUTION privilege.

SECURITYADMIN.

Task owner (OWNERSHIP privilege)

Q58. What command will you execute if you want to disable the query cache?

Select 1 option(s):

ALTER SESSION SET USE_CACHED_RESULT = OFF;

ALTER SESSION SET USE_CACHED_RESULT = FALSE;

ALTER SESSION SET USE_CACHED_RESULT = ON;

ALTER SESSION SET USE_CACHED_RESULT = TRUE;

Q59. What are the main differences between the Virtual Private Snowflake (VPS) and Business Critical Editions? (Select TWO)

Select 2 option(s):

Snowflake VPS provides a completely separate Snowflake environment, isolated from all other Snowflake accounts, whereas it’s not included in the Business Critical Edition.

Snowflake VPS provides a direct proxy to virtual networks // on-premises data centers using AWS PrivateLink, whereas it’s not included in the Business Critical Edition.

Snowflake VPS provides a dedicated metadata store and pool of computing resources, whereas it’s not included in the Business Critical Edition.

Snowflake VPS provides customer-managed encryption keys through Tri-Secret secure, whereas it’s not included in the Business Critical Edition.

Q60. What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

Select 2 option(s):

The ACCOUNTADMIN role must be granted to only one user.

Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Assign the ACCOUNTADMIN role to at least two users, but as few as possible.