3 Months Free Update
3 Months Free Update
3 Months Free Update
A user with which privileges can create or manage other users in a Snowflake account? (Select TWO).
For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?
Which view can be used to determine if a table has frequent row updates or deletes?
What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
What file formats does Snowflake support for loading semi-structured data? (Choose three.)
Which role has the ability to create a share from a shared database by default?
What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?
Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?
Which statement accurately describes a characteristic of a materialized view?
Which Snowflake edition enables data sharing only through Snowflake Support?
Which privilege is required on a virtual warehouse to abort any existing executing queries?
Which feature of Snowflake's Continuous Data Protection (CDP) has associated costs?
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?
Network policies can be applied to which of the following Snowflake objects? (Choose 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?
What is the difference between a stored procedure and a User-Defined Function (UDF)?
When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).
Which stream type can be used for tracking the records in external tables?
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
Which kind of Snowflake table stores file-level metadata for each file in a stage?
If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?
What can a Snowflake user do with the information included in the details section of a Query Profile?
Which function should be used to insert JSON format string data inot a VARIANT field?
Which function will provide the proxy information needed to protect Snowsight?
What metadata does Snowflake store for rows in micro-partitions? (Select TWO).
Which command should be used to unload all the rows from a table into one or more files in a named stage?
Which SQL command can be used to verify the privileges that are granted to a role?
Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?
Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).
What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
What transformations are supported when loading data into a table using the COPY INTO <table> command? (Select TWO).
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?
Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
What will prevent unauthorized access to a Snowflake account from an unknown source?
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 Snowflake data types can be used to build nested hierarchical data? (Select TWO)
User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.
What will happen if User2 tries to access the query history?
What will happen if a Snowflake user increases the size of a suspended virtual warehouse?
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
What are the benefits of the replication feature in Snowflake? (Select TWO).
Which common query problems are identified by the Query Profile? (Select TWO.)
What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?
The VALIDATE table function has which parameter as an input argument for a Snowflake user?
A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names.
How will those object names be resolved during execution?
A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?
How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?
Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?
Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?
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?
What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?
Which command can be used to list all the file formats for which a user has access privileges?
If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?
How do Snowflake data providers share data that resides in different databases?
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?
A JSON document is stored in the source_colum of type VARIANT. The document has an array called elements. The array contains the name key that has a string value How can a Snowflake user extract the name from the first element?
Which Snowflake data governance feature can support auditing when a user query reads column data?
When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).
Which semi-structured file format is a compressed, efficient, columnar data representation?
What should be considered when deciding to use a secure view? (Select TWO).
Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?
What is the default access of a securable object until other access is granted?
What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?
The following settings are configured:
For how many days will the data be retained at the object level?
Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?
A user wants to access stored in a stage without authenticating into Snowflake.
Which type of URL should be used?
Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?
Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?
What type of account can be used to share data with a consumer who does have a Snowflake account?
Which key access control concept does Snowflake descibe as a defined level of access to an object?
A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.
How can this be achieved?
What are the least privileges needed to view and modify resource monitors? (Select TWO).
Which metadata table will store the storage utilization information even for dropped tables?
What happens when a Snowflake user changes the data retention period at the schema level?
Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
Which Snowflake command can be used to unload the result of a query to a single file?
What information is found within the Statistic output in the Query Profile Overview?
How can a Snowflake user validate data that is unloaded using the COPY INTO
Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?
Which privilege must be granted by one role to another role, and cannot be revoked?
What is the relationship between a Query Profile and a virtual warehouse?
A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?
When unloading to a stage, which of the following is a recommended practice or approach?
Which semi-structured file formats are supported when unloading data from a table? (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?
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
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).
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
What is the default File Format used in the COPY command if one is not specified?
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 are ways to create and manage data shares in Snowflake? (Select TWO)
Where would a Snowflake user find information about query activity from 90 days ago?
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?
What are supported file formats for unloading data from Snowflake? (Choose three.)
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));
Which Snowflake layer is always leveraged when accessing a query from the result cache?
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
A user is preparing to load data from an external stage
Which practice will provide the MOST efficient loading performance?
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
Which of the following significantly improves the performance of selective point lookup queries on a table?
Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),
A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?
Which of the following are best practices for loading data into Snowflake? (Choose three.)
What are the responsibilities of Snowflake's Cloud Service layer? (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?
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)
What COPY INTO SQL command should be used to unload data into multiple files?
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
The Snowflake Search Optimization Services supports improved performance of which kind of query?