<< Prev Question Next Question >>

Question 238/305

Which command removes a role from another role or a user in Snowflak?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (305q)
Question 1: The property mins_to_bypass_network_policy is set at which l...
Question 2: What command is used to export or unload data from Snowflake...
Question 3: Which query profile statistics help determine if efficient p...
Question 4: Which statement MOST accurately describes clustering in Snow...
Question 5: Which of the following Snowflake features provide continuous...
Question 6: How can a Snowflake administrator determine which user has a...
Question 7: What will happen if a Snowflake user increases the size of a...
Question 8: In which hierarchy is tag inheritance possible?...
Question 9: When reviewing a query profile, what is a symptom that a que...
Question 10: Snowflake's access control framework combines which models f...
Question 11: For which use cases is running a virtual warehouse required?...
Question 12: From what stage can a Snowflake user omit the FROM clause wh...
Question 13: When is the result set cache no longer available? (Select TW...
Question 14: Which privilege is required to use the search optimization s...
Question 15: What Snowflake feature provides a data hub for secure data c...
Question 16: Which file format will keep floating-point numbers from bein...
Question 17: Which role has the ability to create a share from a shared d...
Question 18: What are characteristics of transient tables in Snowflake? (...
Question 19: How do Snowflake data providers share data that resides in d...
Question 20: Which is the MINIMUM required Snowflake edition that a user ...
Question 21: What is a directory table in Snowflake?...
Question 22: What is a characteristic of materialized views in Snowflake?...
Question 23: Which DDL/DML operation is allowed on an inbound data share?...
Question 24: For Directory tables, what stage allows for automatic refres...
Question 25: How does a scoped URL expire?
Question 26: How long is a query visible in the Query History page in the...
Question 27: Which statements are true concerning Snowflake's underlying ...
Question 28: Which data type can be used to store geospatial data in Snow...
Question 29: Which SQL command can be used to see the CREATE definition o...
Question 30: Which of the following activities consume virtual warehouse ...
Question 31: What computer language can be selected when creating User-De...
Question 32: Which of the following are best practices for loading data i...
Question 33: Snowflake users can create a resource monitor at which level...
Question 34: What is it called when a customer managed key is combined wi...
Question 35: When does a materialized view get suspended in Snowflake?...
Question 36: What is the MINIMUM permission needed to access a file URL f...
Question 37: Will data cached in a warehouse be lost when the warehouse i...
Question 38: What is the purpose of the STRIP NULL_VALUES file format opt...
Question 39: When referring to User-Defined Function (UDF) names in Snowf...
Question 40: How should a virtual warehouse be configured if a user wants...
Question 41: A user wants to access files stored in a stage without authe...
Question 42: When using the ALLOW_CLIENT_MFA_CACHING parameter, how long ...
Question 43: What is the difference between a stored procedure and a User...
Question 44: How are network policies defined in Snowflake?...
Question 45: What types of data listings are available in the Snowflake D...
Question 46: True or False: Fail-safe can be disabled within a Snowflake ...
Question 47: How does the Access_History view enhance overall data govern...
Question 48: What are key characteristics of virtual warehouses in Snowfl...
Question 49: How can an administrator check for updates (for example, SCI...
Question 50: What is the MINIMUM size of a table for which Snowflake reco...
Question 51: What is the minimum Snowflake edition required to create a m...
Question 52: A JSON document is stored in the source_colum of type VARIAN...
Question 53: By default, which role has access to the SYSTEM$GLOBAL_ACCOU...
Question 54: When loading data into Snowflake via Snowpipe what is the co...
Question 55: A Snowflake user is writing a User-Defined Function (UDF) th...
Question 56: Which feature is integrated to support Multi-Factor Authenti...
Question 57: What does Snowflake recommend regarding database object owne...
Question 58: Which statements are correct concerning the leveraging of th...
Question 59: What does a table with a clustering depth of 1 mean in Snowf...
Question 60: What is the MAXIMUM Time Travel retention period for a trans...
Question 61: Which data types are supported by Snowflake when using semi-...
Question 62: Which of the following describes the Snowflake Cloud Service...
Question 63: Which command should be used to download files from a Snowfl...
Question 64: A company's security audit requires generating a report list...
Question 65: A view is defined on a permanent table. A temporary table wi...
Question 66: Which URL type allows users to access unstructured data with...
Question 67: A JSON object is loaded into a column named data using a Sno...
Question 68: Which Snowflake privilege is required on a pipe object to pa...
Question 69: Where would a Snowflake user find information about query ac...
Question 70: What is the MAXIMUM size limit for a record of a VARIANT dat...
Question 71: In the Snowflake access control model, which entity owns an ...
Question 72: The Snowflake Search Optimization Services supports improved...
Question 73: Which Snowflake feature allows a user to substitute a random...
Question 74: True or False: Loading data into Snowflake requires that sou...
Question 75: Which parameter can be set at the account level to set the m...
Question 76: Where can a user find and review the failed logins of a spec...
Question 77: What is the name of the SnowSQLfile that can store connectio...
Question 78: Which cache type is used to cache data output from SQL queri...
Question 79: What is used to diagnose and troubleshoot network connection...
Question 80: Which objects together comprise a namespace in Snowflake? (S...
Question 81: Which Snowflake data governance feature can support auditing...
Question 82: What feature of Snowflake Continuous Data Protection can be ...
Question 83: How long does Snowflake retain information in the ACCESS HIS...
Question 84: Which Snowflake edition offers the highest level of security...
Question 85: What metadata does Snowflake store for rows in micro-partiti...
Question 86: Query parsing and compilation occurs in which architecture l...
Question 87: Which service or feature in Snowflake is used to improve the...
Question 88: A running virtual warehouse is suspended. What is the MINIMU...
Question 89: True or False: Reader Accounts are able to extract data from...
Question 90: How can a Snowflake user validate data that is unloaded usin...
Question 91: What is the recommended way to change the existing file form...
Question 92: The Snowflake Cloud Data Platform is described as having whi...
Question 93: How do secure views compare to non-secure views in Snowflake...
Question 94: Why would a Snowflake user decide to use a materialized view...
Question 95: How can a Snowflake user post-process the result of SHOW FIL...
Question 96: Which task is supported by the use of Access History in Snow...
Question 97: Which metadata table will store the storage utilization info...
Question 98: Which function unloads data from a relational table to JSON?...
Question 99: Which of the following statements describe features of Snowf...
Question 100: What statistical information in a Query Profile indicates th...
Question 101: Which statements reflect valid commands when using secondary...
Question 102: Which Snowflake function is maintained separately from the d...
Question 103: Which command should be used to load data from a file, locat...
Question 104: What is true about sharing data in Snowflake? (Choose two.)...
Question 105: Which command is used to unload files from an internal or ex...
Question 106: How can a Snowflake user traverse semi-structured data?...
Question 107: At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS paramet...
Question 108: Which of the following is an example of an operation that ca...
Question 109: Which command can be used to stage local files from which Sn...
Question 110: What internal stages are available in Snowflake? (Choose thr...
Question 111: What is a limitation of a Materialized View?...
Question 112: What is a responsibility of Snowflake's virtual warehouses?...
Question 113: User INQUISITIVE_PERSON has been granted the role DATA_SCIEN...
Question 114: What should be considered when deciding to use a secure view...
Question 115: Which common query problems are identified by the Query Prof...
Question 116: What does Snowflake recommend for a user assigned the ACCOUN...
Question 117: What objects in Snowflake are supported by Dynamic Data Mask...
Question 118: What information does the Query Profile provide?...
Question 119: Authorization to execute CREATE &lt;object&gt; statements co...
Question 120: What feature can be used to reorganize a very large table on...
Question 121: How can a data provider ensure that a data consumer is going...
Question 122: Which Snowflake feature provides increased login security fo...
Question 123: Which of the following is a valid source for an external sta...
Question 124: Which commands can only be executed using SnowSQL? (Select T...
Question 125: A Snowflake Administrator needs to ensure that sensitive cor...
Question 126: What happens to the shared objects for users in a consumer a...
Question 127: Which Snowflake object helps evaluate virtual warehouse perf...
Question 128: How does Snowflake handle the bulk unloading of data into si...
Question 129: What type of columns does Snowflake recommend to be used as ...
Question 130: If a multi-cluster warehouse is using an economy scaling pol...
Question 131: What are best practice recommendations for using the ACCOUNT...
Question 132: How often are encryption keys automatically rotated by Snowf...
Question 133: A sales table FCT_SALES has 100 million records. The followi...
Question 134: A user created a new worksheet within the Snowsight Ul and w...
Question 135: Which Snowflake feature is used for both querying and restor...
Question 136: Which of the following accurately describes shares?...
Question 137: What happens when a cloned table is replicated to a secondar...
Question 138: Which statement is true about running tasks in Snowflake?...
Question 139: When floating-point number columns are unloaded to CSV or JS...
Question 140: Which of the following indicates that it may be appropriate ...
Question 141: Which solution improves the performance of point lookup quer...
Question 142: A user has unloaded data from Snowflake to a stage Which SQL...
Question 143: In a Snowflake role hierarchy, what is the top-level role?...
Question 144: A Snowflake user wants to optimize performance for a query t...
Question 145: How does Snowflake define i1s approach to Discretionary Acce...
Question 146: Which query contains a Snowflake hosted file URL in a direct...
Question 147: What are advantages clones have over tables created with CRE...
Question 148: What does the TableScan operator represent in the Query Prof...
Question 149: Which of the following are handled by the cloud services lay...
Question 150: What technique does Snowflake use to limit the number of mic...
Question 151: How can a row access policy be applied to a table or a view?...
Question 152: Which of the following can be used when unloading data from ...
Question 153: When unloading data with the COPY into &lt;location&gt; comm...
Question 154: Regardless of which notation is used, what are consideration...
Question 155: What are the correct parameters for time travel and fail-saf...
Question 156: In which use cases does Snowflake apply egress charges?...
Question 157: Which statements reflect key functionalities of a Snowflake ...
Question 158: What are two ways to create and manage Data Shares in Snowfl...
Question 159: The Snowflake cloud services layer is responsible for which ...
Question 160: Which Snowflake feature records changes mace to a table so a...
Question 161: A user needs to create a materialized view in the schema MYD...
Question 162: Which Snowflake object can be accessed in he FROM clause of ...
Question 163: A user unloaded a Snowflake table called mytable to an inter...
Question 164: What are benefits of using Snowpark with Snowflake? (Select ...
Question 165: Which typos of charts does Snowsight support? (Select TWO)....
Question 166: What Snowflake role must be granted for a user to create and...
Question 167: A virtual warehouse is created using the following command: ...
Question 168: Which features could be used to improve the performance of q...
Question 169: How long is the Fail-safe period for temporary and transient...
Question 170: Which Snowflake data types can be used to build nested hiera...
Question 171: Which views are included in the DATA SHARING USAGE schema? (...
Question 172: Which types of subqueries does Snowflake support? (Select TW...
Question 173: Which of the following are characteristics of security in Sn...
Question 174: What happens when a network policy includes values that appe...
Question 175: What are the main differences between the account usage view...
Question 176: Which virtual warehouse consideration can help lower compute...
Question 177: A Snowflake user is trying to load a 125 GB file using SnowS...
Question 178: Which operation can be performed on Snowflake external table...
Question 179: Which Snowflow object does not consume and storage costs?...
Question 180: User1, who has the SYSADMIN role, executed a query on Snowsi...
Question 181: How does Snowflake Fail-safe protect data in a permanent tab...
Question 182: In the Data Exchange, who can get or request data from the l...
Question 183: Which SQL commands, when committed, will consume a stream an...
Question 184: Users are responsible for data storage costs until what occu...
Question 185: What does a masking policy consist of in Snowflake?...
Question 186: What is the default File Format used in the COPY command if ...
Question 187: What file formats does Snowflake support for loading semi-st...
Question 188: What does a Notify &amp; Suspend action for a resource monit...
Question 189: Which Snowflake edition enables data sharing only through Sn...
Question 190: Which of the following features are available with the Snowf...
Question 191: If a virtual warehouse is suspended, what happens to the war...
Question 192: How does a Snowflake stored procedure compare to a User-Defi...
Question 193: A tabular User-Defined Function (UDF) is defined by specifyi...
Question 194: True or False: A 4X-Large Warehouse may, at times, take long...
Question 195: Which of the following are valid methods for authenticating ...
Question 196: What impacts the credit consumption of maintaining a materia...
Question 197: Which Snowflake table objects can be shared with other accou...
Question 198: By default, how long is the standard retention period for Ti...
Question 199: What is the purpose of an External Function?...
Question 200: What is the MINIMUM role required to set the value for the p...
Question 201: Which TABLE function helps to convert semi-structured data t...
Question 202: Which key access control concept does Snowflake descibe as a...
Question 203: Which parameter can be used to instruct a COPY command to ve...
Question 204: Data storage for individual tables can be monitored using wh...
Question 205: What type of query will benefit from the query acceleration ...
Question 206: Which table function should be used to view details on a Dir...
Question 207: What information is stored in the ACCESS_HlSTORY view?...
Question 208: What is the minimum Snowflake edition needed for database fa...
Question 209: Which data type can store more than one type of data structu...
Question 210: Why does Snowflake recommend file sizes of 100-250 MB compre...
Question 211: What is the MAXIMUM number of clusters that can be provision...
Question 212: If 3 size Small virtual warehouse is made up of two servers,...
Question 213: What do the terms scale up and scale out refer to in Snowfla...
Question 214: Which Snowflake URL type is used by directory tables?...
Question 215: If a virtual warehouse runs for 61 seconds, shuts down, and ...
Question 216: Which of the following Snowflake capabilities are available ...
Question 217: Files have been uploaded to a Snowflake internal stage. The ...
Question 218: A user wants to access stored in a stage without authenticat...
Question 219: Which statement describes pruning?...
Question 220: For the ALLOWED VALUES tag property, what is the MAXIMUM num...
Question 221: Which command can be used to load data files into a Snowflak...
Question 222: When enabling access to unstructured data, which URL permits...
Question 223: Where is Snowflake metadata stored?...
Question 224: Which Snowflake function will parse a JSON-null into a SQL-n...
Question 225: How many resource monitors can be assigned at the account le...
Question 226: In which Snowflake layer does Snowflake reorganize data into...
Question 227: Which function should be used to find the query ID of the se...
Question 228: Which of the following are benefits of micro-partitioning? (...
Question 229: Using variables in Snowflake is denoted by using which SQL c...
Question 230: How many days is load history for Snowpipe retained?...
Question 231: Which of the following can be executed/called with Snowpipe?...
Question 232: True or False: It is possible for a user to run a query agai...
Question 233: Which Snowflake object does not consume any storage costs?...
Question 234: Which feature is only available in the Enterprise or higher ...
Question 235: How can a user improve the performance of a single large com...
Question 236: Which kind of Snowflake table stores file-level metadata for...
Question 237: What is one of the characteristics of data shares?...
Question 238: Which command removes a role from another role or a user in ...
Question 239: A table needs to be loaded. The input data is in JSON format...
Question 240: How many network policies can be assigned to an account or s...
Question 241: Which statement describes how Snowflake supports reader acco...
Question 242: The Information Schema and Account Usage Share provide stora...
Question 243: How often are the Account and Table master keys automaticall...
Question 244: Which of the following describes external functions in Snowf...
Question 245: Based on Snowflake recommendations, when creating a hierarch...
Question 246: What occurs when a pipe is recreated using the CREATE OR REP...
Question 247: Which of the following SQL statements will list the version ...
Question 248: What are supported file formats for unloading data from Snow...
Question 249: How does Snowflake reorganize data when it is loaded? (Selec...
Question 250: What type of query benefits the MOST from search optimizatio...
Question 251: Which of the following compute resources or features are man...
Question 252: Which Snowflake objects can be shared with other Snowflake a...
Question 253: Which function should be used to insert JSON format string d...
Question 254: Which Snowflake URL type allows users or applications to dow...
Question 255: Which data types optimally store semi-structured data? (Sele...
Question 256: What do temporary and transient tables have m common in Snow...
Question 257: When would Snowsight automatically detect if a target accoun...
Question 258: Which Snowflake objects track DML changes made to tables, li...
Question 259: How long is Snowpipe data load history retained?...
Question 260: What affects whether the query results cache can be used?...
Question 261: What are characteristic of Snowsight worksheet? (Select TWO....
Question 262: What can a Snowflake user do in the Admin area of Snowsight?...
Question 263: What action can a user take to address query concurrency iss...
Question 264: What can a Snowflake user do with the information included i...
Question 265: The VALIDATE table function has which parameter as an input ...
Question 266: Which type of join will list a I rows in the specified table...
Question 267: Which command is used to unload data from a Snowflake databa...
Question 268: How does the search optimization service help Snowflake user...
Question 269: What is cached during a query on a virtual warehouse?...
Question 270: What are characteristics of reader accounts in Snowflake? (S...
Question 271: If a Snowflake user decides a table should be clustered, wha...
Question 272: Which task privilege does a Snowflake role need in order to ...
Question 273: How does a Snowflake user extract the URL of a directory tab...
Question 274: Which SQL command can be used to verify the privileges that ...
Question 275: What is the relationship between a Query Profile and a virtu...
Question 276: What compute resource is used when loading data using Snowpi...
Question 277: In which scenarios would a user have to pay Cloud Services c...
Question 278: What is the MOST performant file format for loading data in ...
Question 279: Which user object property requires contacting Snowflake Sup...
Question 280: Which of the following features, associated with Continuous ...
Question 281: The first user assigned to a new account, ACCOUNTADMIN, shou...
Question 282: A user is loading JSON documents composed of a huge array co...
Question 283: What value provides information about disk usage for operati...
Question 284: At what levels can a resource monitor be configured? (Select...
Question 285: What privilege should a user be granted to change permission...
Question 286: Which commands are restricted in owner's rights stored proce...
Question 287: What is the maximum total Continuous Data Protection (CDP) c...
Question 288: Which feature allows a user the ability to control the organ...
Question 289: Which Snowflake tool is recommended for data batch processin...
Question 290: What activities can a user with the ORGADMIN role perform? (...
Question 291: What operations can be performed while loading a simple CSV ...
Question 292: Which services does the Snowflake Cloud Services layer manag...
Question 293: A company needs to allow some users to see Personally Identi...
Question 294: Which of the following describes how multiple Snowflake acco...
Question 295: A Snowflake account has activated federated authentication. ...
Question 296: Which Snowflake object contains all the information required...
Question 297: What is the default value in the Snowflake Web Interface (Ul...
Question 298: What Snowflake features allow virtual warehouses to handle h...
Question 299: What function can be used with the recursive argument to ret...
Question 300: What type of account can be used to share data with a consum...
Question 301: What happens when a virtual warehouse is resized?...
Question 302: How can a Snowflake user access a JSON object, given the fol...
Question 303: Which statements describe benefits of Snowflake's separation...
Question 304: True or False: Snowpipe via REST API can only reference Exte...
Question 305: What are the least privileges needed to view and modify reso...