Question1: True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
Question2: What are potential impacts of storing non-native values like dates and timestamps in a variant column in Snowflake?
Question3: What compute resource is used when loading data using Snowpipe?
Question4: Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?
Question5: What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
Question6: What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?
Question7: 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?
Question8: What are the main differences between the account usage views and the information schema views? (Select TWO).
Question9: What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO <table> command when loading data from a JSON file into a table?
Question10: In the Data Exchange, who can get or request data from the listings? (Select TWO).
Question11: What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?
Question12: Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?
Question13: Which JSON paths are considered to be equivalent in Snowflake? (Select TWO).
Question14: What happens when a table or schema with a standard retention period is dropped?
Question15: 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?
Question16: Which activities are included in the Cloud Sen/ices layer? (Select TWO).
Question17: Which stage type can be altered and dropped?
Question18: Which file formats are supported for unloading data from Snowflake? (Choose two.)
Question19: What are valid values for the FIELD_OPTIONALLY_ENCLOSED_BY option in the copy into <location> command used during data unloading? (Select TWO).
Question20: Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
Question21: Which data types does Snowflake support when querying semi-structured data? (Select TWO)
Question22: For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?
Question23: A user wants to upload a file to an internal Snowflake stage using a put command.
Which tools and or connectors could be used to execute this command? (Select TWO).
Question24: Which Snowflake layer is associated with virtual warehouses?
Question25: Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
Question26: What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
Question27: Who can create and manage reader accounts? (Select TWO).
Question28: Which privilege is required to use the search optimization service in Snowflake?
Question29: User-level network policies can be created by which of the following roles? (Select TWO).
Question30: Which type of URL gives permanent access to files in cloud storage?
Question31: Which Snowflake data governance feature supports resource usage monitoring?
Question32: Which Snowflake command can be used to unload the result of a query to a single file?
Question33: How does the search optimization service improve query performance?
Question34: Which operation can be performed on Snowflake external tables?
Question35: Which of the following compute resources or features are managed by Snowflake? (Select TWO).
Question36: Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
Question37: When unloading data to an external stage, what is the MAXIMUM file size supported?
Question38: Which function should be used to find the query ID of the second query executed in a current session?
Question39: Which security models are used in Snowflake to manage access control? (Select TWO).
Question40: A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?
Question41: What is the purpose of a Query Profile?
Question42: Secured Data Sharing is allowed for which Snowflake database objects? (Select TWO).
Question43: What can a user win a reader account do in Snowflake?
Question44: What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?
Question45: 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?
Question46: Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
Question47: What are ways to create and manage data shares in Snowflake? (Select TWO)
Question48: How many network policies can be assigned to an account or specific user at a time?
Question49: What do temporary and transient tables have m common in Snowflake? (Select TWO).
Question50: What would cause different results to be returned when running the same query twice?
Question51: 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?
Question52: Which of the following significantly improves the performance of selective point lookup queries on a table?
Question53: What does a table with a clustering depth of 1 mean in Snowflake?
Question54: Which activities are included in the Cloud Services layer? {Select TWO).
Question55: Which task is supported by the use of Access History in Snowflake?
Question56: The following settings are configured:
THE MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level.
THE DATA_RETENTION_TIME_IN_DAYS is set to 2 at the object level.
For how many days will the data be retained at the object level?
Question57: What step can reduce data spilling in Snowflake?
Question58: What SQL command would be used to view all roles that were granted to user.1?
Question59: What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
Question60: Which command removes a role from another role or a user in Snowflak?
Question61: Which function returns the URL of a stage using the stage name as the input?
Question62: Which roles can make grant decisions to objects within a managed access schema? (Select TWO)
Question63: 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">
Question64: Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
Question65: Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?
Question66: Which type of Snowflake virtual warehouse provides 16 times the memory for each node and is recommended for larger workloads like Machine Learning (ML) training?
Question67: What happens when a suspended virtual warehouse is resized in Snowflake?
Question68: Which data types optimally store semi-structured data? (Select TWO).
Question69: Which command should be used to unload all the rows from a table into one or more files in a named stage?
Question70: What are type predicates used for?
Question71: What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?
Question72: Which function determines the kind of value stored in a VARIANT column?
Question73: Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Question74: What actions will prevent leveraging of the ResultSet cache? (Choose two.)
Question75: What does Snowflake recommend regarding database object ownership? (Select TWO).
Question76: Which semi-structured file format is a compressed, efficient, columnar data representation?
Question77: Which of the following is a data tokenization integration partner?
Question78: Which of the following SQL statements will list the version of the drivers currently being used?
Question79: What Snowflake objects can contain custom application logic written in JavaScript? (Select TWO)
Question80: Given the statement template below, which database objects can be added to a share?(Select TWO).
GRANT <privilege> ON <object> <object_name> To SHARE <share_name>;
Question81: Which of the following statements describe features of Snowflake data caching? (Choose two.)
Question82: Which Snowflake native tool can be used to diagnose and troubleshoot network connections?
Question83: What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
Question84: How does Snowflake handle the bulk unloading of data into single or multiple files?
Question85: What information is found within the Statistic output in the Query Profile Overview?
Question86: Which Snowflake partner specializes in data catalog solutions?
Question87: Which of the following are benefits of micro-partitioning? (Select TWO)
Question88: What feature can be used to reorganize a very large table on one or more columns?
Question89: When will Snowflake charge credits for the use of the Cloud Services layer?
Question90: When used with the UNLOAD command, which parameter specifies the destination of unloaded data?
Question91: A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?
Question92: A user creates a stage using the following command:
What will be the outcome?
Question93: What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?
Question94: Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)
Question95: What type of query benefits the MOST from search optimization?
Question96: Which actions can be performed using a resource monitor in Snowflake? (Select TWO).
Question97: A Snowflake user needs to optimize the definition of a secure view, but the user cannot see the view.
Which of the LEAST-PRIVILEGED access or role that should be granted to the user to complete this task?
Question98: Which function will provide the proxy information needed to protect Snowsight?
Question99: What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'
Question100: Which objects will incur storage costs associated with Fail-safe?
Question101: Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).
Question102: Which Snowflake role can manage any object grant globally, including modifying and revoking grants?
Question103: What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?
Question104: How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?
Question105: Which file function generates a SnowFlake-hosted URL that must be authenticated when used?
Question106: 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?
Question107: 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?
Question108: Why is a federated environment used for user authentication in Snowflake?
Question109: What are the benefits of the replication feature in Snowflake? (Select TWO).
Question110: Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Question111: 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?
Question112: In which hierarchy is tag inheritance possible?
Question113: In Snowflake, what allows users to perform recursive queries?
Question114: What best practice recommendations will help prevent timeouts when using the PUT command to load large data sets? (Select TWO).
Question115: Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)
Question116: Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).
Question117: Snowflake's hierarchical key mode includes which keys? (Select TWO).
Question118: Which Snowflake feature is used for both querying and restoring data?
Question119: When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
Question120: Which statement describes pruning?
Question121: Which type of loop requires a BREAK statement to stop executing?
Question122: A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?
Question123: When unloading data with the COPY into <location> command, what is the purpose of the PARTITION BY
<expression> parameter option?
Question124: Which view can be used to determine if a table has frequent row updates or deletes?
Question125: How can a user improve the performance of a single large complex query in Snowflake?
Question126: By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?
Question127: What are key characteristics of virtual warehouses in Snowflake? (Select TWO).
Question128: A query is using more credits than expected. The Query Profile shows that a majority of the query execution is spent on remote disk I/O.
How can this be prevented m the future?
Question129: What takes the highest precedence in Snowflake file format options, when specified in multiple locations during data loading?
Question130: 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?
Question131: Which Snowflake feature enables loading data from cloud storage as soon as files ate available in a stage?
Question132: Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory?
(Select TWO).
Question133: A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Question134: How can a data provider ensure that a data consumer is going to have access to the required objects?
Question135: What does the TableScan operator represent in the Query Profile?
Question136: What is the MINIMUM permission needed to access a file URL from an external stage?
Question137: How can a row access policy be applied to a table or a view? (Choose two.)
Question138: When working with table MY_TABLE that contains 10 rows, which sampling query will always return exactly 5 rows?
Question139: Who can activate a network policy for users in a Snowflake account? (Select TWO)
Question140: Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
Question141: Which transformation is supported by a COPY INTO <table> command?
Question142: What activities can a user with the ORGADMIN role perform? (Select TWO).
Question143: A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user.
Which Snowflake do it the user's IP address does not match the user-level network policy rules?
Question144: What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
Question145: Which data type can be used for floating-point numbers without losing precision?
Question146: What Snowflake recommendation is designed to ensure that staged data is only loaded once"?
Question147: Which table function is used to perform additional processing on the results of a previously-run query?
Question148: Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
Question149: What is a directory table in Snowflake?
Question150: Which statement about billing applies to Snowflake credits?
Question151: Which function can be used to convert semi-structured data into rows and columns?
Question152: Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
Question153: The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
Question154: Using variables in Snowflake is denoted by using which SQL character?
Question155: Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
Question156: What happens when a cloned table is replicated to a secondary database? (Select TWO)
Question157: What is the MINIMUM Snowftake edition that supports database replication?
Question158: Which command should be used to load data incrementally based on column values that are specified in the source table or subquery?
Question159: What happens to historical data when the retention period for an object ends?
Question160: Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
Question161: A clustering key was defined on a table, but It is no longer needed. How can the key be removed?
Question162: Which Snowflake database object can be used to track data changes made to table data?
Question163: What will happen if a Snowflake user increases the size of a suspended virtual warehouse?
Question164: Which Snowflake object can be used to record DML changes made to a table?
Question165: Which categories are included in the execution time summary in a Query Profile? (Select TWO).
Question166: What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
Question167: A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?
Question168: What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?
Question169: Which service or tool is a Command Line Interface (CLI) client used for connecting to Snowflake to execute SQL queries?
Question170: What does a masking policy consist of in Snowflake?
Question171: What is the maximum Time Travel retention period for a temporary Snowflake table?
Question172: Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Question173: Which feature allows a user the ability to control the organization of data in a micro-partition?
Question174: If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?
Question175: The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
Question176: Which statement will trigger a stream to advance its offset?
Question177: What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)
Question178: How long is Snowpipe data load history retained?
Question179: Which use case does the search optimization service support?
Question180: True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
Question181: Which steps will help optimize query performance? (Select TWO).
Question182: What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?
Question183: Which command can be used to stage local files from which Snowflake interface?
Question184: What optional properties can a Snowflake user set when creating a virtual warehouse? (Select TWO).
Question185: What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
Question186: 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?
Question187: For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?
Question188: While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?
Question189: What is used to diagnose and troubleshoot network connections to Snowflake?
Question190: Using which object-level parameters will help limit query processing and concurrency slowdowns? (Select TWO).
Question191: What are the least privileges needed to view and modify resource monitors? (Select TWO).
Question192: How can a Snowsight user change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse?
Question193: What is the primary purpose of a directory table in Snowflake?
Question194: Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).
Question195: Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
Question196: Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).
Question197: Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
Question198: A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?
Question199: Which command can be performed on a Snowflake secure view?
Question200: What is the MINIMUM Snowflake edition required to use the query acceleration service?
Question201: What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
Question202: Which Snowflake function will parse a JSON-null into a SQL-null?
Question203: What metadata does Snowflake store for rows in micro-partitions? (Select TWO).
Question204: What is the MINIMUM size requirement when creating a Snowpark-optimized virtual warehouse?
Question205: What does Snowflake recommend as a best practice for using secure views?
Question206: Which privilege must be granted by one role to another role, and cannot be revoked?
Question207: What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
Question208: What action should be taken if a large number of concurrent queries are queued in a virtual warehouse?
Question209: What information is stored in the ACCESS_HlSTORY view?
Question210: Which table function will return the output of a previously-run command?
Question211: When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
Question212: Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Question213: What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
Question214: Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
Question215: A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?
Question216: What persistent data structures are used by the search optimization service to improve the performance of point lookups?
Question217: Which SQL command can be used to see the CREATE definition of a masking policy?
Question218: How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?
Question219: A stream object will advance its offset when it is used in which statement?
Question220: How can a Snowflake user validate data that is unloaded using the COPY INTO <location> command?
Question221: What does SnowCD help Snowflake users to do?
Question222: A Snowflake user has been granted the create data EXCHANGE listing privilege with their role.
Which tasks can this user now perform on the Data Exchange? (Select TWO).
Question223: Which copy INTO command outputs the data into one file?
Question224: Which privilege is required on a virtual warehouse to abort any existing executing queries?
Question225: The Snowflake Cloud Data Platform is described as having which of the following architectures?
Question226: What happens when an external or an internal stage is dropped? (Select TWO).
Question227: Which command can be used to list all network policies available in an account?
Question228: The Snowflake VARIANT data type imposes a 16 MB size limit on what?
Question229: How can performance be optimized for a query that returns a small amount of data from a very large base table?
Question230: What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
Question231: Which objects together comprise a namespace in Snowflake? (Select TWO).
Question232: Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
Question233: 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?
Question234: Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?
Question235: How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''
Question236: A column named "Data" contains VARIANT data and stores values as follows:
How will Snowflake extract the employee's name from the column data?
Question237: What is one of the characteristics of data shares?
Question238: Which of the following describes a Snowflake stored procedure?
Question239: Which of the following statements apply to Snowflake in terms of security? (Choose two.)
Question240: 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?
Question241: When cloning a schema, which Snowflake object will not be included in the clone?
Question242: What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake?
(Choose two.)
Question243: 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?
Question244: What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
Question245: Which multi-duster virtual warehouse setting will help process queued queries as quickly as possible?
Question246: Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?
Question247: How does Snowflake recommend defining a clustering key on a high-cardinality column that includes a 15 digit ID numbered column ID_NUMER?
Question248: Which statement is true about running tasks in Snowflake?
Question249: What is the expiration period tor a file URL used to access unstructured data in cloud storage?
Question250: 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?
Question251: What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
Question252: Snowflake's access control framework combines which models for securing data? (Select TWO).
Question253: 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?
Question254: Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?
Question255: 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?
Question256: The VALIDATE table function has which parameter as an input argument for a Snowflake user?
Question257: What type of account can be used to share data with a consumer who does have a Snowflake account?
Question258: 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?
Question259: Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
Question260: True or False: A Virtual Warehouse can be resized while suspended.
Question261: Which command will unload data from a table into an external stage?
Question262: How can the outer array structure of a semi-structured file be removed?
Question263: Which statement accurately describes how a virtual warehouse functions?
Question264: Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
Question265: Which virtual warehouse auto-suspend configurations will result in a warehouse that runs continually 24 hours a day, 7 days a week? (Select TWO).
Question266: Which function is used to unload a relational table into a JSON file*?
Question267: At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
Question268: Which Snowflake database object can be shared with other accounts?
Question269: Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?
Question270: 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?
Question271: What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?
Question272: Which typos of charts does Snowsight support? (Select TWO).
Question273: What impacts the credit consumption of maintaining a materialized view? (Choose two.)
Question274: How does Snowflake describe its unique architecture?
Question275: 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?
Question276: How can a Snowflake user access a JSON object, given the following table? (Select TWO).
Question277: When unloading data, which file format preserves the data values for floating-point number columns?
Question278: What data is stored in the Snowflake storage layer? (Select TWO).
Question279: What can the Snowflake SCIM API be used to manage? (Select TWO).
Question280: Which resource monitor setting will cancel all active queries in a virtual warehouse when the threshold is met?
Question281: Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).
Question282: While preparing to unload data in Snowflake, the file format option can be specified in which commands?
(Select TWO).
Question283: Which commands can only be executed using SnowSQL? (Select TWO).
Question284: What can a Snowflake user do with the information included in the details section of a Query Profile?
Question285: How can staged files be removed during data loading once the files have loaded successfully?
Question286: What is cached during a query on a virtual warehouse?
Question287: While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).
Question288: What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?
Question289: The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?
Question290: How can network and private connectivity security be managed in Snowflake?
Question291: 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?
Question292: Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?
Question293: What does a Notify & Suspend action for a resource monitor do?
Question294: Which function can be used with the copy into <location> statement to convent rows from a relational table to a single variant column, and to unload rows into a JSON file?
Question295: The customer table in the T1 database is accidentally dropped.
Which privileges are required to restore this table? {Select TWO).
Question296: In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
Question297: Which type of role can be granted to a share?
Question298: 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?
Question299: What is the purpose of an External Function?
Question300: What object does Snowflake recommend using when planning to unload similarly-formatted data on a regular basis?
Question301: What affects whether the query results cache can be used?
Question302: Which URL provides access to files in Snowflake without authorization?
Question303: Who can create network policies within Snowflake? (Select TWO).
Question304: Which REST API can be used with unstructured data?
Question305: 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?
Question306: Where is metadata management handled in Snowflake?
Question307: Which types of subqueries does Snowflake support? (Select TWO).
Question308: Which function is used to convert rows in a relational table to a single VARIANT column?
Question309: What are valid sub-clauses to the OVER clause for a window function? (Select TWO).
Question310: Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?
Question311: 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?
Question312: Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
Question313: Which command is used to upload data files from a local directory or folder on a client machine to an internal stage, for a specified table?
Question314: Which object can be used to query the data loading history for the last 365 days for a Snowflake account?
Question315: Which feature is only available in the Enterprise or higher editions of Snowflake?
Question316: Which privilege is needed for a SnowFlake user to see the definition of a secure view?
Question317: What is the MAXIMUM size limit for a record of a VARIANT data type?
Question318: Which of the following describes the Snowflake Cloud Services layer?
Question319: If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
Question320: Which Snowflake view is used to support compliance auditing?
Question321: Which items are considered schema objects in Snowflake? (Select TWO).
Question322: What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?
Question323: When using the ALLOW_CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
Question324: Which privilege is required for a user to be able to view a resource monitor?
Question325: What is the MINIMUM Snowflake edition that must be used in order to see the ACCESS_HISTORY view?
Question326: What is the recommended file sizing for data loading using Snowpipe?
Question327: How can a Snowflake user optimize query performance in Snowflake? (Select TWO).
Question328: Which transformation techniques are supported for bulk loading data into Snowflake using the copy into
<table> command? (Select TWO)
Question329: 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?
Question330: What kind of value does a User-Defined Function (UDF) return? (Select TWO).
Question331: What is the difference between a stored procedure and a User-Defined Function (UDF)?
Question332: What objects can be cloned within Snowflake? (Select TWO).
Question333: 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?
Question334: How does Snowflake handle the data retention period for a table if a stream has not been consumed?
Question335: By definition, a secure view is exposed only to users with what privilege?
Question336: When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
Question337: What is the default file size when unloading data from Snowflake using the COPY command?
Question338: How can a dropped internal stage be restored?
Question339: How long can a data consumer who has a pre-signed URL access data files using Snowflake?
Question340: Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?
Question341: Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?
Question342: In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Select TWO).
Question343: Which table function will identify data that was loaded using COPY INTO <table> statements and also identify data loaded using Snowpipe?
Question344: Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
Question345: In which use cases does Snowflake apply egress charges?
Question346: Which command can be used to list all the file formats for which a user has access privileges?
Question347: How does Snowflake define i1s approach to Discretionary Access Control (DAC)?
Question348: How can the Query Profile be used to troubleshoot a problematic query?
Question349: Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?
Question350: 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?
Question351: Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?
Question352: What kind of authentication do Snowpipe REST endpoints use?
Question353: 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?
Question354: 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?
Question355: Which Snowflow object does not consume and storage costs?
Question356: Which object can be used with Secure Data Sharing?
Question357: 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?
Question358: What does the worksheet and database explorer feature in Snowsight allow users to do?
Question359: Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?
Question360: Which command can be used to load data files into a Snowflake stage?
Question361: What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
Question362: Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflak?
Question363: What does the LATERAL modifier for the FLATTEN function do?
Question364: What is the default File Format used in the COPY command if one is not specified?
Question365: What happens when a database is cloned?
Question366: The is the minimum Fail-safe retention time period for transient tables?
Question367: How many days is load history for Snowpipe retained?
Question368: What COPY INTO SQL command should be used to unload data into multiple files?
Question369: When should a multi-cluster virtual warehouse be used in Snowflake?
Question370: When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).
Question371: Which metadata table will store the storage utilization information even for dropped tables?
Question372: Which data types can be used in Snowflake to store semi-structured data? (Select TWO)
Question373: Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)
Question374: What is the minimum Snowflake edition that has column-level security enabled?
Question375: Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
Question376: Which of the following statements describes a schema in Snowflake?