Dumpsbuddy logo
If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
Which command is used to unload files from an internal or external stage to a local file system?
Network policies can be applied to which of the following Snowflake objects? (Choose two.)
What file formats does Snowflake support for loading semi-structured data? (Choose three.)
How can a data provider ensure that a data consumer is going to have access to the required objects?
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?
Which file format will keep floating-point numbers from being truncated when data is unloaded?
What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?
When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).
Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
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?
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)
When unloading data to an external stage, what is the MAXIMUM file size supported?
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 Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
A user with which privileges can create or manage other users in a Snowflake account? (Select TWO).
How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?
How should clustering be used to optimize the performance of queries that run on a very large table?
Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)
NO: 504
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?
What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?
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?
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?
Which statements describe benefits of Snowflake's separation of compute and storage? (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?
Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?
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?
Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).
Which commands are restricted in owner's rights stored procedures? (Select TWO).
Which metadata table will store the storage utilization information even for dropped tables?
What are the least privileges needed to view and modify resource monitors? (Select TWO).
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?
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?
What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?
How can a Snowflake user validate data that is unloaded using the COPY INTO
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
What is the default File Format used in the COPY command if one is not specified?
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 feature is only available in the Enterprise or higher editions of Snowflake?
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option
What does the STRIP_OUTER_ARRAY file format do?
Which semi-structured file formats are supported when unloading data from a table? (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?
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
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?
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?
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 Snowflake table that is loaded using a Kafka connector has a schema consisting of which two variant columns? (Select TWO).
How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''
What are the default Time Travel and Fail-safe retention periods for transient tables?
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?
What optional properties can a Snowflake user set when creating a virtual warehouse? (Select TWO).
Which multi-duster virtual warehouse setting will help process queued queries as quickly as possible?
Which JSON paths are considered to be equivalent in Snowflake? (Select TWO).
How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?
How does Snowflake recommend defining a clustering key on a high-cardinality column that includes a 15 digit ID numbered column ID_NUMER?
Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?
Which MINIMUM set of privileges is required to temporarily bypass an active network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY?
Which statements reflect valid commands when using secondary roles? (Select TWO).
Which transformation techniques are supported for bulk loading data into Snowflake using the copy into <title> command? (Select TWO)
In the Data Exchange, who can get or request data from the listings? (Select TWO).
When used with the UNLOAD command, which parameter specifies the destination of unloaded data?
Which file function provides a URL with access to a file on a stage without the need for authentication and authorization?
Which privilege is needed for a SnowFlake user to see the definition of a secure view?
Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?
How does the Access_History view enhance overall data governance pertaining to read and write operations? (Select TWO).
A clustering key was defined on a table, but It is no longer needed. How can the key be removed?
ALTER TABLE
