What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
Which statement about billing applies to Snowflake credits?
What is a limitation of a Materialized View?
What Snowflake role must be granted for a user to create and manage accounts?
Which of the following can be executed/called with Snowpipe?
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
What happens when a cloned table is replicated to a secondary database? (Select TWO)
Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account.
A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
What can be used to view warehouse usage over time? (Select Two).
What happens when a virtual warehouse is resized?
What data is stored in the Snowflake storage layer? (Select TWO).
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
What happens when an external or an internal stage is dropped? (Select TWO).
What is a best practice after creating a custom role?
Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)
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?
Which of the following is the Snowflake Account_Usage.Metering_History view used for?
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
True or False: Snowpipe via REST API can only reference External Stages as source.
For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?
Using variables in Snowflake is denoted by using which SQL character?
What is true about sharing data in Snowflake? (Choose two.)
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
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?
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)
Which command can be used to load data files into a Snowflake stage?
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
Which services does the Snowflake Cloud Services layer manage? (Choose two.)
Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?
The following JSON is stored in a VARIANT column called src of the CAR_SALES table:
A user needs to extract the dealership information from the JSON.
How can this be accomplished?
The PUT command: (Choose two.)
Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?
Which of the following objects is not covered by Time Travel?
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
Which of the following commands are not blocking operations?
Choose 2 answers
True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers
What are the three things customers want most from their enterprise data warehouse solution?
Choose 3 answers
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
Snowflake provides a mechanism for its customers to override its clustering algorithms. This method is:
True or False: It is possible to load data into Snowflake without creating a named File Format object.
Which of the following are common use cases for zero-copy cloning?
Choose 3 answers
True or False: During data unloading, only JSON and CSV files can be compressed.
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
What are ways to create and manage data shares in Snowflake? (Select TWO)
True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.
True or False: Loading data into Snowflake requires that source data files be no larger than 16M
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
How long is Snowpipe data load history retained?
Which of the following objects can be shared through secure data sharing?
TESTED 10 Dec 2023
Hi this is Romona Kearns from Holland and I would like to tell you that I passed my exam with the use of exams4sure dumps. I got same questions in my exam that I prepared from your test engine software. I will recommend your site to all my friends for sure.
Our all material is important and it will be handy for you. If you have short time for exam so, we are sure with the use of it you will pass it easily with good marks. If you will not pass so, you could feel free to claim your refund. We will give 100% money back guarantee if our customers will not satisfy with our products.