What is the only supported character set for loading and unloading data from all supported file formats?
There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?
Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?
If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?
How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?
Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?
Which function should be used to insert JSON format string data inot a VARIANT field?
When unloading data, which file format preserves the data values for floating-point number columns?
What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?
When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?
The effects of query pruning can be observed by evaluating which statistics? (Select TWO).
Which view can be used to determine if a table has frequent row updates or deletes?
Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?
Which command can be used to list all the file formats for which a user has access privileges?
How long can a data consumer who has a pre-signed URL access data files using Snowflake?
Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
What column type does a Kafka connector store formatted information in a single column?
Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.
How does Snowflake recommend resolving this issue?
What file formats does Snowflake support for loading semi-structured data? (Choose three.)
Which command is used to unload files from an internal or external stage to a local file system?
Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?
What privilege should a user be granted to change permissions for new objects in a managed access schema?
Which of the following is the Snowflake Account_Usage.Metering_History view used for?
Which task privilege does a Snowflake role need in order to suspend or resume a task?
A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?
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 is the recommended way to change the existing file format type in my format from CSV to JSON?
Which user object property requires contacting Snowflake Support in order to set a value for it?
Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?
A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables. Which set operator should be used?
Which of the following can be used when unloading data from Snowflake? (Choose two.)
What is the difference between a stored procedure and a User-Defined Function (UDF)?
How can a data provider ensure that a data consumer is going to have access to the required objects?
When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
Which of the following compute resources or features are managed by Snowflake? (Select TWO).
When unloading to a stage, which of the following is a recommended practice or approach?
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
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?
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).
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?
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)
Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)
Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?
Where can a user find and review the failed logins of a specific user for the past 30 days?
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
Which of the following are best practices for loading data into Snowflake? (Choose three.)
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
What are supported file formats for unloading data from Snowflake? (Choose three.)
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
Which file formats are supported for unloading data from Snowflake? (Choose two.)
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates
How can this worksheet be shared?
Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?
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?
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
Which data types are supported by Snowflake when using semi-structured data? (Choose two.)
A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?
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 command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?