Question1: Which common query problems are identified by the Query Profile? (Select TWO.)
Question2: Which command can be used to list all network policies available in an account?
Question3: What does Snowflake recommend when planning virtual warehouse usage for a data load?
Question4: What does a table with a clustering depth of 1 mean in Snowflake?
Question5: A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently.
What should the user do?
Question6: Which Snowflake privilege is required on a pipe object to pause or resume pipes?
Question7: Which statement describes pruning?
Question8: While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?
Question9: Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
Question10: Which activities are managed by Slowflake's Cloud Services layer? (Select TWO).
Question11: The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?
Question12: True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
Question13: Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
Question14: What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?
Question15: 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?
Question16: What persistent data structures are used by the search optimization service to improve the performance of point lookups?
Question17: Which account usage view can be used to identify the masking policy assigned to an object?
Question18: A Snowflake account administrator has set the resource monitors as shown in the diagram, with actions defined for each resource monitor as "Notify & Suspend Immediately".
What is the MAXIMUM limit of credits that Warehouse 2 can consume?
Question19: Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
Question20: What virtual warehouse configuration should be used when processing a large number of complex queries?
Question21: Which views are included in the DATA SHARING USAGE schema? (Select TWO).
Question22: True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
Question23: Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).
Question24: Which file function provides a URL with access to a file on a stage without the need for authentication and authorization?
Question25: Which Snowflake URL type is used by directory tables?
Question26: Which of the following statements apply to Snowflake in terms of security? (Choose two.)
Question27: Which Snowflake function will parse a JSON-null into a SQL-null?
Question28: How do secure views compare to non-secure views in Snowflake?
Question29: How can a Snowflake user automate virtual warehouse operations for optimal credit consumption? (Select TWO).
Question30: What would cause different results to be returned when running the same query twice?
Question31: What kind of authentication do Snowpipe REST endpoints use?
Question32: Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?
Question33: Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?
Question34: Which use case does the search optimization service support?
Question35: Which Snowflake objects use storage? (Select TWO).
Question36: 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).
Question37: 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?
Question38: 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?
Question39: Which statistics on a Query Profile reflect the efficiency of the query pruning? (Select TWO).
Question40: What feature can be used to reorganize a very large table on one or more columns?
Question41: How many resource monitors can be assigned at the account level?
Question42: Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
Question43: 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?
Question44: What transformations are supported when loading data into a table using the COPY INTO <table> command?
(Select TWO).
Question45: In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
Question46: When should a multi-cluster warehouse be used in auto-scaling mode?
Question47: Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
Question48: In a managed access schema, only the schema owner or a role with what privilege can help centralize privilege management?
Question49: When loading data into Snowflake, how should the data be organized?
Question50: Which object can be used with Secure Data Sharing?
Question51: What are key characteristics of virtual warehouses in Snowflake? (Select TWO).
Question52: How can a Snowflake user traverse semi-structured data?
Question53: Which Snowflow object does not consume and storage costs?
Question54: How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?
Question55: If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
Question56: Which Snowflake feature is used for both querying and restoring data?
Question57: What is the default character set used when loading CSV files into Snowflake?
Question58: What metadata does Snowflake store for rows in micro-partitions? (Select TWO).
Question59: By default, which role can create resource monitors?
Question60: What is the name of the SnowSQLfile that can store connection information?
Question61: For Directory tables, what stage allows for automatic refreshing of metadata?
Question62: Multiple business units within a company use a single Snowflake account.
What features should be used if the company needs to separate costs by business unit? (Select TWO).
Question63: Which Snowflake table supports unstructured data?
Question64: A network policy applied at the user level takes precedence over a network policy applied to what Snowflake object?
Question65: Which Snowflake feature or service is primarily used for managing and monitoring data and user activities?
Question66: 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>;
Question67: The customer table in the Tl database is accidentally dropped.
Which privileges are required to restore this table? (Select TWO).
Question68: What is the MINIMUM permission needed to access a file URL from an external stage?
Question69: A materialized view should be created when which of the following occurs? (Choose two.)
Question70: Which of the following statements describes a schema in Snowflake?
Question71: What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
Question72: Which categories are included in the execution time summary in a Query Profile? (Select TWO).
Question73: A JSON object is loaded into a column named data using a Snowflake variant datatype. The root node of the object is BIKE. The child attribute for this root node is BIKEID.
Which statement will allow the user to access BIKEID?
Question74: Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory?
(Select TWO).
Question75: Which drivers or connectors are supported by Snowflake? (Select TWO)
Question76: Which activities are included in the Cloud Services layer? {Select TWO).
Question77: What is the purpose of the Snowflake SPLIT TO_TABLE function?
Question78: Which table function will identify data that was loaded using COPY INTO <table> statements and also identify data loaded using Snowpipe?
Question79: Which command can be performed on a Snowflake secure view?
Question80: What is a directory table in Snowflake?
Question81: Snowflake's access control framework combines which models for securing data? (Select TWO).
Question82: What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?
Question83: True or False: Fail-safe can be disabled within a Snowflake account.
Question84: Who can create network policies within Snowflake? (Select TWO).
Question85: 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?
Question86: 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?
Question87: How long is the Fail-safe period for temporary and transient tables?
Question88: What is the MINIMUM Snowflake edition required it a user needs to replicate both virtual warehouses and roles?
Question89: When used with the UNLOAD command, which parameter specifies the destination of unloaded data?
Question90: Which security models are used in Snowflake to manage access control? (Select TWO).
Question91: Use of which virtual warehouse or warehouse configuration will Improve the performance of workloads that have large memory requirements, such as Machine Learning .....amlng using a stored procedure?
Question92: What is the MINIMUM Snowflake edition required to use the query acceleration service?
Question93: In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?
Question94: What is the MINIMUM role required to set the value for the parameter
ENABLE_ACCOUNT_DATABASE_REPLICATION?
Question95: Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
Question96: What happens when an external or an internal stage is dropped? (Select TWO).
Question97: A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?
Question98: What is the MAXIMUM size limit for a record of a VARIANT data type?
Question99: What is a fundamental characteristic of Snowflake micro-partitions?
Question100: How does Snowflake handle the bulk unloading of data into single or multiple files?
Question101: Which data types are supported by Snowflake when using semi-structured data? (Choose two.)
Question102: The fail-safe retention period is how many days?
Question103: How does the authorization associated with a pre-signed URL work tor an unstructured file?
Question104: What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?
Question105: How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?
Question106: 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">
Question107: Which of the following objects can be shared through secure data sharing?
Question108: Snowflake's hierarchical key mode includes which keys? (Select TWO).
Question109: What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
Question110: Which command is used to remove files from either external cloud storage or an internal staged
Question111: A column named "Data" contains VARIANT data and stores values as follows:
How will Snowflake extract the employee's name from the column data?
Question112: Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
Question113: How would you determine the size of the virtual warehouse used for a task?
Question114: Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?
Question115: Which Snowflake governance feature allows users to assign metadata labels to improve data governance and database access control?
Question116: For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?
Question117: What are ways to create and manage data shares in Snowflake? (Select TWO)
Question118: What is the difference between a stored procedure and a User-Defined Function (UDF)?
Question119: Which table function is used to perform additional processing on the results of a previously-run query?
Question120: What best practice recommendations will help prevent timeouts when using the PUT command to load large data sets? (Select TWO).
Question121: How long can a data consumer who has a pre-signed URL access data files using Snowflake?
Question122: In Snowflake, the use of federated authentication enables which Single Sign-On (SSO) workflow activities?
(Select TWO).
Question123: A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?
Question124: Which data type can store more than one type of data structure?
Question125: How can a dropped internal stage be restored?
Question126: For which use cases is running a virtual warehouse required? (Select TWO).
Question127: Which type of join will list a I rows in the specified table, even if those rows have no match in the other table?
Question128: Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).
Question129: Which Snowsight feature can be used to perform data manipulations and transformations using a programming language?
Question130: What are the least privileges needed to view and modify resource monitors? (Select TWO).
Question131: How would a user run a multi-cluster warehouse in maximized mode?
Question132: What will happen if a Snowflake user increases the size of a suspended virtual warehouse?
Question133: What can a Snowflake user do with the information included in the details section of a Query Profile?
Question134: Which items are considered schema objects in Snowflake? (Select TWO).
Question135: A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?
Question136: 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?
Question137: Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?
Question138: Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
Question139: How many network policies can be assigned to an account or specific user at a time?
Question140: What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
Question141: What should be considered when deciding to use a secure view? (Select TWO).
Question142: Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?
Question143: When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
Question144: What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
Question145: Which object can be shared using Secure Data Sharing?
Question146: How long does Snowflake retain information in the ACCESS HISTORY view?
Question147: Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?
Question148: What data is stored in the Snowflake storage layer? (Select TWO).
Question149: How can a Snowflake user validate data that is unloaded using the COPY INTO <location> command?
Question150: How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?
Question151: How are serverless features billed?
Question152: 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?
Question153: What type of account can be used to share data with a consumer who does have a Snowflake account?
Question154: What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?
Question155: 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?
Question156: In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Select TWO).
Question157: Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)
Question158: 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?
Question159: What value provides information about disk usage for operations where intermediate results do not fit in memory in a Query Profile?
Question160: Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?
Question161: Which JSON paths are considered to be equivalent in Snowflake? (Select TWO).
Question162: Which configuration of the function PARSE_JSON (<expr>) will retrieve a valid SQL HULL value?
Question163: Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Question164: Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)
Question165: Authorization to execute CREATE <object> statements comes only from which role?
Question166: Which statement accurately describes a characteristic of a materialized view?
Question167: Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?
Question168: Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
Question169: How are network policies defined in Snowflake?
Question170: When used with a select statement in the copy into <location> command, what statement will unload data from a table as JSON?
Question171: What happens to historical data when the retention period for an object ends?
Question172: User-level network policies can be created by which of the following roles? (Select TWO).
Question173: Which virtual warehouse configuration requires the maximum number of clusters to be equal to the minimum number of clusters?
Question174: Which command removes a role from another role or a user in Snowflak?
Question175: Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)
Question176: 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 in the future?
Question177: If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?
Question178: What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?
Question179: When do Snowflake object owners lose their ability to make grant decisions?
Question180: Which data protection feature should only be used when all other data recovery options have been attempted?
Question181: Which Snowflake database object can be used to track data changes made to table data?
Question182: Which common query issues can be identified by the Query Profile? (Select TWO).
Question183: What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?
Question184: How can a 5 GB table be downloaded into a single file MOST efficiently?
Question185: When a Snowflake user loads CSV data from a stage, which copy into <table> command guideline should they follow?
Question186: How can a user change which columns are referenced in a view?
Question187: A directory table that references an external stage is being refreshed manually.
What will happen to any scheduled automatic-refresh operations occurring at the same time as the manual- refresh operations?
Question188: What does the LATERAL modifier for the FLATTEN function do?
Question189: What is the purpose of the use of the VALIDATE command?
Question190: Which features make up Snowflake's column level security? (Select TWO).
Question191: What is the MINIMUM Snowflake edition required to add masking policies to selectively mask plain-text data in a table or in view columns at query time?
Question192: What activities can a user with the ORGADMIN role perform? (Select TWO).
Question193: Which clause is used to define a function that may return different values for different rows?
Question194: What privileges are required to activate a network policy for an individual user within a Snowflake account?
Question195: What is the recommended file sizing for data loading using Snowpipe?
Question196: What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
Question197: Which transformation is supported by a COPY INTO <table> command?
Question198: Which Snowflake command can be used to unload the result of a query to a single file?
Question199: How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?
Question200: When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).
Question201: During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
Question202: What is one of the characteristics of data shares?
Question203: 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).
Question204: Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?
Question205: When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
Question206: 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?
Question207: Which function should be used to insert JSON format string data inot a VARIANT field?
Question208: When does Snowflake automatically encrypt data that is loaded into Snowflake? (Select TWO}.
Question209: 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?
Question210: Which Snowflake view is used to support compliance auditing?
Question211: Will data cached in a warehouse be lost when the warehouse is resized?
Question212: When unloading data with the COPY into <location> command, what is the purpose of the PARTITION BY
<expression> parameter option?
Question213: What is the impact of selecting one Snowflake edition over another? (Select TWO).
Question214: Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
Question215: How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?
Question216: Which data types optimally store semi-structured data? (Select TWO).
Question217: Which functions can be used to automatically detect and generate a file's metadata schema and column definitions, when loading semi-structured data into Snowflake from 9? (Select TWO).
Question218: A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Question219: What is the purpose of multi-cluster virtual warehouses?
Question220: A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
Question221: Which features are included in Snowsight? (Select TWO)
Question222: How would a user execute a series of SQL statements using a task?
Question223: What affects whether the query results cache can be used?
Question224: Which services does the Snowflake Cloud Services layer manage? (Choose two.)
Question225: Where can a user find and review the failed logins of a specific user for the past 30 days?
Question226: What causes objects in a data share to become unavailable to a consumer account?
Question227: What function, combined with the copy command, should be used to unload data from a relational table into a JSON file?
Question228: What does the TableScan operator represent in the Query Profile?
Question229: Which metadata table will store the storage utilization information even for dropped tables?
Question230: Which URL provides access to files in Snowflake without authorization?
Question231: Which type of charts are supported by Snowsight? {Select TWO)
Question232: Which REST API can be used with unstructured data?
Question233: How does Snowflake recommend defining a clustering key on a high-cardinality column that includes a 15 digit ID numbered column. ID_NUMBER?
Question234: Which command sets the Virtual Warehouse for a session?
Question235: Which statement describes how Snowflake supports reader accounts?
Question236: Which kind of Snowflake table stores file-level metadata for each file in a stage?
Question237: What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?
Question238: Which commands are restricted in owner's rights stored procedures? (Select TWO).
Question239: Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
Question240: How should the SPLIT_TO_TABLE (<string>, <delimiter>) function be called?
Question241: What actions can be performed by a consumer account on a shared database? (Select TWO).
Question242: What is the default access of a securable object until other access is granted?
Question243: Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?
Question244: Which command can be used to stage local files from which Snowflake interface?
Question245: What is the MAXIMUM data retention period of transient databases when using the Snowflake Enterprise edition?
Question246: How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?
Question247: What happens when a suspended virtual warehouse is resized in Snowflake?
Question248: How do Snowflake data providers share data that resides in different databases?
Question249: What object does Snowflake recommend using when planning to unload similarly-formatted data on a regular basis?
Question250: What is used to diagnose and troubleshoot network connections to Snowflake?
Question251: Which feature allows a user the ability to control the organization of data in a micro-partition?
Question252: How does Snowflake handle the data retention period for a table if a stream has not been consumed?
Question253: Which Snowflake architectural layer is responsible for a query execution plan?
Question254: Which steps will help optimize query performance? (Select TWO).
Question255: Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).
Question256: Where does Snowflake store the data output from a query that was executed in the past 24 hours?
Question257: A user wants to access stored in a stage without authenticating into Snowflake.
Which type of URL should be used?
Question258: Based on a review of a Query Profile, which scenarios will benefit the MOST from the use of a data clustering key? (Select TWO.)
Question259: What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
Question260: Which privilege is required for a user to be able to view a resource monitor?
Question261: When unloading data to an external stage, what is the MAXIMUM file size supported?
Question262: What happens to the privileges granted to Snowflake system-defined roles?
Question263: What can be used to process unstructured data?
Question264: What impacts the credit consumption of maintaining a materialized view? (Choose two.)
Question265: Which of the following describes how clustering keys work in Snowflake?
Question266: Which pages are included in the Activity area of Snowsight? (Select TWO).
Question267: 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).
Question268: What does SnowCD help Snowflake users to do?
Question269: 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?
Question270: 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?
Question271: Which Snowflake objects can be restored using Time Travel? (Select VNO).
Question272: How does Snowflake reorganize data when it is loaded? (Select TWO).
Question273: What happens when a virtual warehouse is resized?
Question274: Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?
Question275: Which access control entity in Snowflake can be created as part of a hierarchy within an account?
Question276: Which Snowflake layer is associated with virtual warehouses?
Question277: What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Select TWO).
Question278: What are characteristic of Snowsight worksheet? (Select TWO.)
Question279: Which of the following describes the Snowflake Cloud Services layer?
Question280: A Snowflake table that is loaded using a Kafka connector has a schema consisting of which two variant columns? (Select TWO).
Question281: 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?
Question282: Which Query Profile metrics will provide information that can be used to improve query performance?
(Select TWO).
Question283: A user with which privileges can create or manage other users in a Snowflake account? (Select TWO).
Question284: What is the MOST performant file format for loading data in Snowflake?
Question285: 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?
Question286: What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
Question287: Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
Question288: What is the minimum Snowflake edition required to use Dynamic Data Masking?
Question289: What is a best practice after creating a custom role?
Question290: The property mins_to_bypass_network_policy is set at which level?
Question291: Which user object property requires contacting Snowflake Support in order to set a value for it?
Question292: Which Snowflake object contains all the information required to share a database?
Question293: Which role has the ability to create and manage users and roles?
Question294: Which task is supported by the use of Access History in Snowflake?
Question295: Which SQL command can be used to see the CREATE definition of a masking policy?
Question296: How can a user improve the performance of a single large complex query in Snowflake?
Question297: Which privilege is required on a virtual warehouse to abort any existing executing queries?
Question298: What do temporary and transient tables have m common in Snowflake? (Select TWO).
Question299: Which user preferences can be set for a user profile in Snowsight? (Select TWO).
Question300: Which objects will incur storage costs associated with Fail-safe?
Question301: When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
Question302: How is Single Sign-On (SSO) authentication used in Snowflake?
Question303: A clustering key was defined on a table, but It is no longer needed. How can the key be removed?
Question304: Which Snowflake storage object can be used to store data beyond a single session and will not incur Fail-safe costs?
Question305: Network policies can be applied to which of the following Snowflake objects? (Choose two.)
Question306: Which Snowflake feature can be used to find sensitive data in a table or column?
Question307: Which languages require that User-Defined Function (UDF) handlers be written inline? (Select TWO).
Question308: Which objects together comprise a namespace in Snowflake? (Select TWO).
Question309: At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
Question310: When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?
Question311: What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)
Question312: What happens to historical data when the retention period for an object ends?
Question313: Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
Question314: What role is required to use Partner Connect?
Question315: Which data types can be used in Snowflake to store semi-structured data? (Select TWO)
Question316: Which SQL command can be used to verify the privileges that are granted to a role?
Question317: What is the MAXIMUM Time Travel retention period for a transient table?
Question318: What is the maximum Time Travel retention period for a temporary Snowflake table?
Question319: What is the consequence of disabling auto-suspend for a Snowflake virtual warehouse?
Question320: Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?
Question321: Which services does the Snowflake Cloud Services layer manage? (Select TWO).
Question322: Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)
Question323: If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?
Question324: What can a user win a reader account do in Snowflake?
Question325: When will Snowflake charge credits for the use of the Cloud Services layer?
Question326: 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?
Question327: What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
Question328: Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
Question329: Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
Question330: True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
Question331: Which is a best practice recommendation when planning to load data into a table?
Question332: Which function should be used to find the query ID of the second query executed in a current session?
Question333: A Snowflake user wants to design a series of transformations that need to be executed in a specific order, on a given schedule.
What Snowflake objects should be used?
Question334: Which of the following are characteristics of security in Snowflake?
Question335: Which governance feature is supported by all Snowflake editions?
Question336: What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?
Question337: What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?
Question338: What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
Question339: Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
Question340: Using variables in Snowflake is denoted by using which SQL character?
Question341: Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
Question342: What can the Snowflake SCIM API be used to manage? (Select TWO).
Question343: When unloading data, which file format preserves the data values for floating-point number columns?
Question344: Which function is used to convert rows in a relational table to a single VARIANT column?
Question345: 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?
Question346: How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?
Question347: What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'
Question348: Which function will provide the proxy information needed to protect Snowsight?
Question349: Which of the following accurately describes shares?
Question350: Which type of workload traditionally benefits from the use of the query acceleration service?
Question351: Which privilege is required to use the search optimization service in Snowflake?
Question352: In which hierarchy is tag inheritance possible?
Question353: Which of the following describes a Snowflake stored procedure?
Question354: Which query types will have significant performance improvement when run using the search optimization service? (Select TWO)