Question1: What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));
Question2: How would a user run a multi-cluster warehouse in maximized mode?
Question3: 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?
Question4: How does Snowflake define i1s approach to Discretionary Access Control (DAC)?
Question5: Which command is used to unload data from a Snowflake table into a file in a stage?
Question6: How does the search optimization service help Snowflake users improve query performance?
Question7: What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Select TWO).
Question8: At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
Question9: What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
Question10: What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
Question11: What happens when a cloned table is replicated to a secondary database? (Select TWO)
Question12: What is a feature of column-level security in Snowflake?
Question13: What is the purpose of the Snowflake SPLIT TO_TABLE function?
Question14: How many resource monitors can be assigned at the account level?
Question15: What will happen if a Snowflake user increases the size of a suspended virtual warehouse?
Question16: Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
Question17: 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?
Question18: What action can a user take to address query concurrency issues?
Question19: Which statement accurately describes a characteristic of a materialized view?
Question20: What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
Question21: How often are the Account and Table master keys automatically rotated by Snowflake?
Question22: In which hierarchy is tag inheritance possible?
Question23: When cloning a database, what is cloned with the database? (Choose two.)
Question24: Which type of join will list a I rows in the specified table, even if those rows have no match in the other table?
Question25: When unloading to a stage, which of the following is a recommended practice or approach?
Question26: Which semi-structured file format is a compressed, efficient, columnar data representation?
Question27: 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?
Question28: Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
Question29: How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?
Question30: Which function is used to convert rows in a relational table to a single VARIANT column?
Question31: Why would a Snowflake user decide to use a materialized view instead of a regular view?
Question32: Using variables in Snowflake is denoted by using which SQL character?
Question33: How long can a data consumer who has a pre-signed URL access data files using Snowflake?
Question34: Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?
Question35: How long is the Fail-safe period for temporary and transient tables?
Question36: Which pages are included in the Activity area of Snowsight? (Select TWO).
Question37: What happens when a virtual warehouse is resized?
Question38: Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?
Question39: Which statement about billing applies to Snowflake credits?
Question40: The Snowflake Cloud Data Platform is described as having which of the following architectures?
Question41: What is a directory table in Snowflake?
Question42: Who can create network policies within Snowflake? (Select TWO).
Question43: If a virtual warehouse is suspended, what happens to the warehouse cache?
Question44: Which Snowflow object does not consume and storage costs?
Question45: A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
Question46: In a Snowflake role hierarchy, what is the top-level role?
Question47: The fail-safe retention period is how many days?
Question48: Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?
Question49: 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?
Question50: What role is required to use Partner Connect?
Question51: True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
Question52: Which types of subqueries does Snowflake support? (Select TWO).
Question53: Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
Question54: What factors impact storage costs in Snowflake? (Select TWO).
Question55: What is the Fail-safe retention period for transient and temporary tables?
Question56: How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?
Question57: In the Data Exchange, who can get or request data from the listings? (Select TWO).
Question58: What is the minimum Snowflake edition required to create a materialized view?
Question59: Which Snowflake partner specializes in data catalog solutions?
Question60: Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
Question61: Which Snowflake technique can be used to improve the performance of a query?
Question62: Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?
Question63: When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
Question64: What impacts the credit consumption of maintaining a materialized view? (Choose two.)
Question65: A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?
Question66: 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?
Question67: How can a Snowflake user traverse semi-structured data?
Question68: Which statement describes Snowflake tables?
Question69: Which SQL command can be used to verify the privileges that are granted to a role?
Question70: Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
Question71: Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
Question72: Which feature of Snowflake's Continuous Data Protection (CDP) has associated costs?
Question73: How does the Snowflake search optimization service improve query performance?
Question74: Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?
Question75: By default, which role can create resource monitors?
Question76: What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?
Question77: A Snowflake user needs to share unstructured data from an internal stage to a reporting tool that does not have Snowflake access.
Which file function should be used?
Question78: What is true about sharing data in Snowflake? (Choose two.)
Question79: What is the MINIMUM permission needed to access a file URL from an external stage?
Question80: Which data types optimally store semi-structured data? (Select TWO).
Question81: What is the default access of a securable object until other access is granted?
Question82: Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
Question83: 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?
Question84: Which statement MOST accurately describes clustering in Snowflake?
Question85: When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
Question86: What feature can be used to reorganize a very large table on one or more columns?
Question87: 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?
Question88: A column named "Data" contains VARIANT data and stores values as follows:
How will Snowflake extract the employee's name from the column data?
Question89: Which Snowflake object contains all the information required to share a database?
Question90: What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?
Question91: To use the overwrite option on insert, which privilege must be granted to the role?
Question92: 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).
Question93: Which SQL statement will require a virtual warehouse to run?
Question94: In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
Question95: Which statements reflect valid commands when using secondary roles? (Select TWO).
Question96: What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
Question97: Which parameter prevents streams on tables from becoming stale?
Question98: Which DDL/DML operation is allowed on an inbound data share?
Question99: What type of account can be used to share data with a consumer who does have a Snowflake account?
Question100: A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?
Question101: What are characteristic of Snowsight worksheet? (Select TWO.)
Question102: In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?
Question103: 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?
Question104: 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?
Question105: Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
Question106: What is the default file size when unloading data from Snowflake using the COPY command?
Question107: A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?
Question108: Where would a Snowflake user find information about query activity from 90 days ago?
Question109: Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).
Question110: When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
Question111: Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).
Question112: Snowflake users can create a resource monitor at which levels? (Select TWO).
Question113: What activities can a user with the ORGADMIN role perform? (Select TWO).
Question114: How can a user get the MOST detailed information about individual table storage details in Snowflake?
Question115: How can a Snowflake user access a JSON object, given the following table? (Select TWO).
Question116: What is the only supported character set for loading and unloading data from all supported file formats?
Question117: Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
Question118: How can a data provider ensure that a data consumer is going to have access to the required objects?
Question119: Which object type is granted permissions for reading a table?
Question120: Which minimum Snowflake edition allows for a dedicated metadata store?
Question121: Which file formats are supported for unloading data from Snowflake? (Choose two.)
Question122: 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?
Question123: How often are encryption keys automatically rotated by Snowflake?
Question124: A user with which privileges can create or manage other users in a Snowflake account? (Select TWO).
Question125: Which Snowflake layer is always leveraged when accessing a query from the result cache?
Question126: 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?
Question127: A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?
Question128: 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?
Question129: How does Snowflake handle the data retention period for a table if a stream has not been consumed?
Question130: What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
Question131: Which command can be used to stage local files from which Snowflake interface?
Question132: 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?
Question133: Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?
Question134: Which of the following significantly improves the performance of selective point lookup queries on a table?
Question135: Which Snowflake objects can be restored using Time Travel? (Select VNO).
Question136: The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
Question137: The property mins_to_bypass_network_policy is set at which level?
Question138: Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
Question139: Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
Question140: Which metadata table will store the storage utilization information even for dropped tables?
Question141: Which type of loop requires a BREAK statement to stop executing?
Question142: A Snowflake account has activated federated authentication.
What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?
Question143: What SQL command would be used to view all roles that were granted to user.1?
Question144: What is the MAXIMUM size limit for a record of a VARIANT data type?
Question145: Which items are considered schema objects in Snowflake? (Select TWO).
Question146: What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
Question147: Which statement accurately describes Snowflake's architecture?
Question148: What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology mat is not listed in Snowflake partner ecosystem?
Question149: What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
Question150: What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
Question151: What is the minimum Snowflake edition required for row level security?
Question152: What causes objects in a data share to become unavailable to a consumer account?
Question153: Which virtual warehouse consideration can help lower compute resource credit consumption?
Question154: 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?
Question155: Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
Question156: What does Snowflake's search optimization service support?
Question157: What does a masking policy consist of in Snowflake?
Question158: Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?
Question159: A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?
Question160: Which file format will keep floating-point numbers from being truncated when data is unloaded?
Question161: Which function returns the URL of a stage using the stage name as the input?
Question162: What does a Notify & Suspend action for a resource monitor do?
Question163: What happens when a Snowflake user changes the data retention period at the schema level?
Question164: What are benefits of using Snowpark with Snowflake? (Select TWO).
Question165: Who can grant object privileges in a regular schema?
Question166: Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?
Question167: What is the difference between a stored procedure and a User-Defined Function (UDF)?
Question168: What data is stored in the Snowflake storage layer? (Select TWO).
Question169: How is unstructured data retrieved from data storage?
Question170: What can a Snowflake user do with the information included in the details section of a Query Profile?
Question171: Authorization to execute CREATE <object> statements comes only from which role?
Question172: Which URL provides access to files in Snowflake without authorization?
Question173: Which Snowflake privilege is required on a pipe object to pause or resume pipes?
Question174: Which role has the ability to create a share from a shared database by default?
Question175: In Snowflake, the use of federated authentication enables which Single Sign-On (SSO) workflow activities?
(Select TWO).
Question176: Which use case does the search optimization service support?
Question177: Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
Question178: Which function should be used to find the query ID of the second query executed in a current session?
Question179: What are the least privileges needed to view and modify resource monitors? (Select TWO).
Question180: 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?
Question181: Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?
Question182: 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?
Question183: Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
Question184: A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?
Question185: For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?
Question186: What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
Question187: What happens when an external or an internal stage is dropped? (Select TWO).
Question188: Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Question189: What is the primary purpose of a directory table in Snowflake?
Question190: Which operation can be performed on Snowflake external tables?
Question191: What happens when a network policy includes values that appear in both the allowed and blocked IP address list?
Question192: Which file function generates a SnowFlake-hosted URL that must be authenticated when used?
Question193: Which of the following describes a Snowflake stored procedure?
Question194: Which Snowflake architectural layer is responsible for a query execution plan?
Question195: Which of the following statements apply to Snowflake in terms of security? (Choose two.)
Question196: Which user preferences can be set for a user profile in Snowsight? (Select TWO).
Question197: Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).
Question198: The following settings are configured:
For how many days will the data be retained at the object level?
Question199: Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
Question200: How can performance be optimized for a query that returns a small amount of data from a very large base table?
Question201: What is a responsibility of Snowflake's virtual warehouses?
Question202: What are value types that a VARIANT column can store? (Select TWO)
Question203: If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
Question204: A user is preparing to load data from an external stage
Which practice will provide the MOST efficient loading performance?
Question205: Which copy INTO command outputs the data into one file?
Question206: Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?
Question207: Which privilege is needed for a SnowFlake user to see the definition of a secure view?
Question208: Which services does the Snowflake Cloud Services layer manage? (Select TWO).
Question209: How are network policies defined in Snowflake?
Question210: Which Snowflake feature can be used to find sensitive data in a table or column?
Question211: Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
Question212: Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).
Question213: Which Snowflake URL type is used by directory tables?
Question214: Which typos of charts does Snowsight support? (Select TWO).
Question215: 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?
Question216: While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).
Question217: What are the main differences between the account usage views and the information schema views? (Select TWO).
Question218: What type of function returns one value for each Invocation?
Question219: The effects of query pruning can be observed by evaluating which statistics? (Select TWO).
Question220: Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)
Question221: What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'
Question222: Which of the following statements describe features of Snowflake data caching? (Choose two.)
Question223: A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?
Question224: What value provides information about disk usage for operations where intermediate results do not fit in memory in a Query Profile?
Question225: True or False: Fail-safe can be disabled within a Snowflake account.
Question226: What are potential impacts of storing non-native values like dates and timestamps in a variant column in Snowflake?
Question227: A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.
What table type should be used?
Question228: What will prevent unauthorized access to a Snowflake account from an unknown source?
Question229: Which common query problems are identified by the Query Profile? (Select TWO.)
Question230: 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?
Question231: Which Snowflake object does not consume any storage costs?
Question232: When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
Question233: A clustering key was defined on a table, but It is no longer needed. How can the key be removed?
Question234: How many network policies can be assigned to an account or specific user at a time?
Question235: Which data type can be used to store geospatial data in Snowflake?
Question236: A materialized view should be created when which of the following occurs? (Choose two.)
Question237: During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
Question238: Which command should be used to unload all the rows from a table into one or more files in a named stage?
Question239: What COPY INTO SQL command should be used to unload data into multiple files?
Question240: What does the LATERAL modifier for the FLATTEN function do?
Question241: In the Snowflake access control model, which entity owns an object by default?
Question242: Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).
Question243: The is the minimum Fail-safe retention time period for transient tables?
Question244: Which of the following can be used when unloading data from Snowflake? (Choose two.)
Question245: What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?
Question246: What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?
Question247: Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
Question248: Which of the following are benefits of micro-partitioning? (Select TWO)
Question249: Which statement about billing applies to Snowflake credits?
Question250: 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?
Question251: For Directory tables, what stage allows for automatic refreshing of metadata?
Question252: What can be used to view warehouse usage over time? (Select Two).
Question253: Which Snowflake tool is recommended for data batch processing?
Question254: Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
Question255: What is the default File Format used in the COPY command if one is not specified?
Question256: Snowflake's access control framework combines which models for securing data? (Select TWO).
Question257: Which data types can be used in Snowflake to store semi-structured data? (Select TWO)
Question258: At what levels can a resource monitor be configured? (Select TWO).
Question259: Which feature allows a user the ability to control the organization of data in a micro-partition?
Question260: What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).
Question261: When is the result set cache no longer available? (Select TWO)
Question262: If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?
Question263: How can a Snowflake user optimize query performance in Snowflake? (Select TWO).
Question264: Which activities are managed by Slowflake's Cloud Services layer? (Select TWO).
Question265: How can a user get the MOST detailed information about individual table storage details in Snowflake?
Question266: What are common issues found by using the Query Profile? (Choose two.)
Question267: Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?
Question268: 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?
Question269: If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?
Question270: How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?
Question271: What affects whether the query results cache can be used?
Question272: What is a limitation of a Materialized View?
Question273: A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?
Question274: Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
Question275: Which roles can make grant decisions to objects within a managed access schema? (Select TWO)
Question276: Which objects together comprise a namespace in Snowflake? (Select TWO).
Question277: Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
Question278: How does a scoped URL expire?
Question279: How can a user improve the performance of a single large complex query in Snowflake?
Question280: The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?
Question281: How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
Question282: What is the recommended compressed file size range for continuous data loads using Snowpipe?
Question283: Which commands can only be executed using SnowSQL? (Select TWO).
Question284: Which Snowflake edition enables data sharing only through Snowflake Support?
Question285: What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)
Question286: 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?
Question287: Which governance feature is supported by all Snowflake editions?
Question288: When does a materialized view get suspended in Snowflake?
Question289: How does Snowflake describe its unique architecture?
Question290: User-level network policies can be created by which of the following roles? (Select TWO).
Question291: What is the purpose of an External Function?
Question292: What happens to historical data when the retention period for an object ends?
Question293: Which views are included in the data_sharing_usage schema? (Select TWO).
Question294: Which Snowflake role can manage any object grant globally, including modifying and revoking grants?