3 Months Free Update
3 Months Free Update
3 Months Free Update
How can a user improve the performance of a single large complex query in Snowflake?
What is the difference between a stored procedure and a User-Defined Function (UDF)?
If a Snowflake user decides a table should be clustered, what should be used as the cluster key?
A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?
Which feature allows a user the ability to control the organization of data in a micro-partition?
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
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?
Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?
How often are the Account and Table master keys automatically rotated by Snowflake?
When unloading data to an external stage, what is the MAXIMUM file size supported?
Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?
What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?
What are valid sub-clauses to the OVER clause for a window function? (Select TWO).
Which SQL command can be used to verify the privileges that are granted to a role?
Which command should be used to unload all the rows from a table into one or more files in a named stage?
When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?
What is the only supported character set for loading and unloading data from all supported file formats?
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?
What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?
The effects of query pruning can be observed by evaluating which statistics? (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?
How can a user get the MOST detailed information about individual table storage details in Snowflake?
What is the Fail-safe retention period for transient and temporary tables?
What is the MINIMUM permission needed to access a file URL from an external stage?
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?
Which view can be used to determine if a table has frequent row updates or deletes?
What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?
How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?
Which function should be used to insert JSON format string data inot a VARIANT field?
When using the ALLOW_CLI£NT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
What happens when a network policy includes values that appear in both the allowed and blocked IP address list?
What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?
By default, how long is the standard retention period for Time Travel across all Snowflake accounts?
Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?
Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).
What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?
Which role has the ability to create a share from a shared database by default?
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
Which of the following compute resources or features are managed by Snowflake? (Select TWO).
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
What is the default File Format used in the COPY command if one is not specified?
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
Which command can be used to stage local files from which Snowflake interface?
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
Which of the following significantly improves the performance of selective point lookup queries on a table?
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?
In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
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 statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)
What COPY INTO SQL command should be used to unload data into multiple files?
True or False: Snowpipe via REST API can only reference External Stages as source.
What happens to historical data when the retention period for an object ends?
What is the default file size when unloading data from Snowflake using the COPY command?
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates
How can this worksheet be shared?
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)
What are supported file formats for unloading data from Snowflake? (Choose three.)
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
Which file formats are supported for unloading data from Snowflake? (Choose two.)
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
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 types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)
Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?
Which privilege is required on a virtual warehouse to abort any existing executing queries?
What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?
What is the default access of a securable object until other access is granted?
What are potential impacts of storing non-native values like dates and timestamps in a variant column in Snowflake?
What happens to the privileges granted to Snowflake system-defined roles?
Which of the following SQL statements will list the version of the drivers currently being used?
What do temporary and transient tables have m common in Snowflake? (Select TWO).
Which Snowflake table type persists until it is explicitly dropped. is available for all users with relevant privileges (across sessions). and has no Fail-safe period?
Given the statement template below, which database objects can be added to a share?(Select TWO).
GRANT
Which semi-structured file format is a compressed, efficient, columnar data representation?
Which system_defined, read-only view display information on column lineage that specifies how data flows from source to target in a SQL write operation?
A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 2< hour mark?
While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?
A)
B)
C)
D)
Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?
Which function returns the URL of a stage using the stage name as the input?
To use the overwrite option on insert, which privilege must be granted to the role?
Snowflake users can create a resource monitor at which levels? (Select TWO).
What type of account can be used to share data with a consumer who does have a Snowflake account?
How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?
Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?
What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?
How can performance be optimized for a query that returns a small amount of data from a very large base table?
Which metadata table will store the storage utilization information even for dropped tables?
What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'
Which Snowflake table objects can be shared with other accounts? (Select TWO).
How can a Snowflake user validate data that is unloaded using the COPY INTO
A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.
Which CREATE object statement will automatically assign the TABLE_A tag to a target object?
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 column named "Data" contains VARIANT data and stores values as follows:
How will Snowflake extract the employee's name from the column data?
Which data types can be used in Snowflake to store semi-structured data? (Select TWO)
What will prevent unauthorized access to a Snowflake account from an unknown source?
Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?
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).
Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?
Which Snowflake database object can be used to track data changes made to table data?
Which Snowflake role can manage any object grant globally, including modifying and revoking grants?
When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
A user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?
Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).
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?
What tasks can an account administrator perform in the Data Exchange? (Select TWO).
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?