marks4sure logo
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
What feature can be used to reorganize a very large table on one or more columns?
Which command is used to unload data from a Snowflake table into a file in a stage?
Where would a Snowflake user find information about query activity from 90 days ago?
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
Which kind of Snowflake table stores file-level metadata for each file in a stage?
What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
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 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?
If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?
Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
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).
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
When unloading to a stage, which of the following is a recommended practice or approach?
What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)
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 features are available with the Snowflake Enterprise edition? (Choose two.)
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
What does Snowflake recommend regarding database object ownership? (Select TWO).
How often are the Account and Table master keys automatically rotated by Snowflake?
What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
How can a data provider ensure that a data consumer is going to have access to the required objects?
For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
How many network policies can be assigned to an account or specific user at a time?
Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).
Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?
Snowflake's access control framework combines which models for securing data? (Select TWO).
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?
For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?
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 Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
Which snowflake objects will incur both storage and cloud compute charges? (Select 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?
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?
The following JSON is stored in a VARIANT column called src of the CAR_SALES table:
A user needs to extract the dealership information from the JSON.
How can this be accomplished?
The Snowflake Search Optimization Services supports improved performance of which kind of query?
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?
Which command is used to remove files from either external cloud storage or an internal staged
When a Snowflake user loads CSV data from a stage, which copy into <title> command guideline should they follow?
The customer table in the T1 database is accidentally dropped.
Which privileges are required to restore this table? {Select TWO).
Which function should be used to find the query ID of the second query executed in a current session?
What would cause different results to be returned when running the same query twice?
Which type of workload traditionally benefits from the use of the query acceleration service?
What are potential impacts of storing non-native values like dates and timestamps in a variant column in Snowflake?
Which multi-duster virtual warehouse setting will help process queued queries as quickly as possible?
Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?
Which Snowflake data governance feature can support auditing when a user query reads column data?
How can staged files be removed during data loading once the files have loaded successfully?
Which common query problems are identified by the Query Profile? (Select TWO.)
A Snowflake user accidentally deleted a table. The table no longer exists, but the session is within the data retention period. How can the table be restored using the LEAST amount of operational overhead?
What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?
What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?
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 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 function should be used to insert JSON format string data inot a VARIANT field?
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 is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?
What is the only supported character set for loading and unloading data from all supported file formats?
How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?
Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?
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 statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).
What is the MINIMUM permission needed to access a file URL from an external stage?
How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?
How can a user get the MOST detailed information about individual table storage details in Snowflake?
What will prevent unauthorized access to a Snowflake account from an unknown source?
What happens when a network policy includes values that appear in both the allowed and blocked IP address list?
Which command should be used to unload all the rows from a table into one or more files in a named stage?
By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?
What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'
Which transformation techniques are supported for bulk loading data into Snowflake using the copy into <title> command? (Select TWO)
Which security models are used in Snowflake to manage access control? (Select TWO).
Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?
In the Data Exchange, who can get or request data from the listings? (Select TWO).
What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?
Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?
When unloading data with the COPY into
What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?
What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).
Which data protection feature should only be used when all other data recovery options have been attempted?
Which Snowflake function and command combination should be used to convert rows in a relational table to a single VARIANT column, and unload the rows Into a file in JSON format? (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 command can be used to unload data into an external named stage in Snowflake?
Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?
Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).
Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?
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?
What does the worksheet and database explorer feature in Snowsight allow users to do?
What are valid sub-clauses to the OVER clause for a window function? (Select TWO).
Which function will provide the proxy information needed to protect Snowsight?
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?
What transformations are supported when loading data into a table using the COPY INTO <title> command? (Select TWO).
A column named "Data" contains VARIANT data and stores values as follows:
How will Snowflake extract the employee's name from the column data?
What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
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 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?
A user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?
Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?
A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?
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 solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?
When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
What are the least privileges needed to view and modify resource monitors? (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?
Which commands are restricted in owner's rights stored procedures? (Select TWO).
What tasks can an account administrator perform in the Data Exchange? (Select TWO).
Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
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 is the default File Format used in the COPY command if one is not specified?
Which of the following compute resources or features are managed by Snowflake? (Select TWO).
UESTION NO: 241
What SQL command would be used to view all roles that were granted to user.1?
TESTED 19 Apr 2025