Dumpsbuddy logo
How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?
What tasks can an account administrator perform in the Data Exchange? (Select TWO).
A user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?
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 metadata table will store the storage utilization information even for dropped tables?
Which commands are restricted in owner's rights stored procedures? (Select TWO).
Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?
What will prevent unauthorized access to a Snowflake account from an unknown source?
Which privilege must be granted by one role to another role, and cannot be revoked?
Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).
Which Snowflake role can manage any object grant globally, including modifying and revoking grants?
What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
Which file formats are supported for unloading data from Snowflake? (Choose two.)
What are supported file formats for unloading data from Snowflake? (Choose 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?
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
What is the maximum Time Travel retention period for a temporary Snowflake table?
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in 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 command should be used to load data from a file, located in an external stage, into a table in Snowflake?
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
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?
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?
Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed
When the user returns, how much billable compute time will have been consumed?
What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
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?
Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?
How should clustering be used to optimize the performance of queries that run on a very large table?
Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)
True or False: Snowpipe via REST API can only reference External Stages as source.
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
Which of the following statements describe features of Snowflake data caching? (Choose two.)
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
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?
Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),
What are valid sub-clauses to the OVER clause for a window function? (Select TWO).
A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?
Which command should be used to unload all the rows from a table into one or more files in a named stage?
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?
When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?
Which function is used to convert rows in a relational table to a single VARIANT column?
What does the worksheet and database explorer feature in Snowsight allow users to do?
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?
When unloading data, which file format preserves the data values for floating-point number columns?
Which file function generates a SnowFlake-hosted URL that must be authenticated when used?
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 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 common query problems are identified by the Query Profile? (Select TWO.)
The VALIDATE table function has which parameter as an input argument for a Snowflake user?
How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?
Which view can be used to determine if a table has frequent row updates or deletes?
What is the only supported character set for loading and unloading data from all supported file formats?
How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?
By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?
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?
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?
A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY.
What should they do?
The effects of query pruning can be observed by evaluating which statistics? (Select TWO).
By default, how long is the standard retention period for Time Travel across all Snowflake accounts?
Which function should be used to insert JSON format string data inot a VARIANT field?
What happens when a network policy includes values that appear in both the allowed and blocked IP address list?
What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?
What is the MINIMUM permission needed to access a file URL from an external stage?
While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).
Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?
Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?
How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?
Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).
Which SQL command can be used to verify the privileges that are granted to a role?
What does Snowflake recommend regarding database object ownership? (Select TWO).
For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?
Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?
Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)
Which SQL command can be used to see the CREATE definition of a masking policy?
When unloading data to an external stage, what is the MAXIMUM file size supported?
Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
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?
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
If a Snowflake user decides a table should be clustered, what should be used as the cluster key?
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?
How can a Snowflake user optimize query performance in Snowflake? (Select TWO).
Which user object property requires contacting Snowflake Support in order to set a value for it?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?
Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?
Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?
What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?
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?
How does Snowflake handle the bulk unloading of data into single or multiple files?
What privilege should a user be granted to change permissions for new objects in a managed access schema?
User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?
Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).
Which of the following is the Snowflake Account_Usage.Metering_History view used for?
Which of the following can be used when unloading data from Snowflake? (Choose two.)
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
Which command is used to unload data from a Snowflake table into a file in a stage?
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (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?
Which of the following compute resources or features are managed by Snowflake? (Select TWO).
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?
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
What is the default File Format used in the COPY command if one is not specified?
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?
True or False: Reader Accounts are able to extract data from shared data objects for use outside of 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).
What feature can be used to reorganize a very large table on one or more columns?
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
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 indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
When unloading to a stage, which of the following is a recommended practice or approach?
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
Which feature is only available in the Enterprise or higher editions of Snowflake?
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
What are the default Time Travel and Fail-safe retention periods for transient tables?
User-level network policies can be created by which of the following roles? (Select TWO).
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small 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?
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?
A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
What impact does dropping a column from a table have on the micro-partitions of that table?
Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?
What Snowflake feature or service is used to prevent third parties from reading data while it is at rest or in transit?
Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?
Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?
What is the MINIMUM Snowflake edition that users storing protected information in Snowflake should use for regulatory compliance?
A Snowflake user wants to design a series of transformations that need to be executed in a specific order on a given schedule.
Which of the snowflake objects should be used?
Which command should be used to drop files from an internal or external stage?
What command will return a list of files that have been unloaded to a user stage?
Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?
Which Snowflake feature or service is primarily used for managing and monitoring data and user activities?
Which command will allow users to query data from files in cloud storage without ingesting the data?
What is the expiration period tor a file URL used to access unstructured data in cloud storage?
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
When cloning a schema, which Snowflake object will not be included in the clone?
What persistent data structures are used by the search optimization service to improve the performance of point lookups?
Which Snowflake tool provides detailed execution statistics of a query with no cost to the user?
Which Snowsight feature can be used to perform data manipulations and transformations using a programming language?
Which strategy is recommended to improve the performance of a large, complex query?
The ORDERS table contains 12,000 rows.
Which query will return 10 rows that are randomly sampled from the table every time the query is run?
Which function will return the URL for an external stage by using the stage name as the input?
When unloading data with the COPY into
Which command can be used to list all network policies available in an account?
Which Snowflake feature can be used to identify tables, views, and columns that contain sensitive information by assigning and querying metadata?
What are the main differences between the account usage views and the information schema views? (Select TWO).
What type of account can be used to share data with a consumer who does have a Snowflake account?
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 objects are required to unload data into cloud data storage? (Select TWO).
When creating a custom role that will be allowed to create warehouses and databases, which system-defined role does Snowflake recommend also be assigned to the custom role?
Snowflake's access control framework combines which models for securing data? (Select TWO).
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?
A user executed a SELECT query in Snowsight which returned a 1 GB result set. The user then downloads the files.
What will occur?
When unloading data: which file formal will keep floating-point number column data without truncating it?
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?
Which virtual warehouse consideration can help lower compute resource credit consumption?
Which privilege grants the ability to set a column-level security masking policy on a table or view column?
Which query types will have significant performance improvement when run using the search optimization service? (Select TWO)
Use of which file function allows a user to share unstructured data from an internal stage with an external reporting tool that does not have access to Snowflake">
Which access control entity in Snowflake can be created as part of a hierarchy within an account?
What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?
TESTED 05 Dec 2025
