Which of the following can be used when unloading data from Snowflake? (Choose two.)
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
What is used to diagnose and troubleshoot network connections to Snowflake?
Network policies can be applied to which of the following Snowflake objects? (Choose two.)
Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?
How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?
Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?
A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share
Based on this configuration what is true of the reader account?
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
What file formats does Snowflake support for loading semi-structured data? (Choose three.)
Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).
How can a Snowflake user optimize query performance in Snowflake? (Select TWO).
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
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?
How long can a data consumer who has a pre-signed URL access data files using Snowflake?
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?
Which Snowflake edition enables data sharing only through Snowflake Support?
Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)
In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?
Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)
What happens to historical data when the retention period for an object ends?
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
What COPY INTO SQL command should be used to unload data into multiple files?
What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)
A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.
What action should be taken to address this situation?
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
What is the maximum Time Travel retention period for a temporary Snowflake table?
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
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?
What are supported file formats for unloading data from Snowflake? (Choose three.)
Which of the following are best practices for loading data into Snowflake? (Choose three.)
What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?
Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
Which Snowflake role can manage any object grant globally, including modifying and revoking grants?
What are key characteristics of virtual warehouses in Snowflake? (Select TWO).
Which Snowflake command can be used to unload the result of a query to a single file?
Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?
A user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?
How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?
While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?
What metadata does Snowflake store for rows in micro-partitions? (Select TWO).
When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
Which privilege must be granted by one role to another role, and cannot be revoked?
A Snowflake account has activated federated authentication.
What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?
Which Snowflake table objects can be shared with other accounts? (Select TWO).
What tasks can an account administrator perform in the Data Exchange? (Select TWO).
Which commands are restricted in owner's rights stored procedures? (Select TWO).
How can a Snowflake user validate data that is unloaded using the COPY INTO
What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'
How should clustering be used to optimize the performance of queries that run on a very large table?
What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
Which command is used to unload data from a Snowflake table into a file in a stage?
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
What Snowflake role must be granted for a user to create and manage accounts?
A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?
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?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the staged?
What is the default File Format used in the COPY command if one is not specified?
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Where would a Snowflake user find information about query activity from 90 days ago?
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
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?
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
User-level network policies can be created by which of the following roles? (Select TWO).
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?