<< Prev Question Next Question >>

Question 26/115

Network policies can be set at which Snowflake levels? (Choose two.)

LEAVE A REPLY

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

Question List (115q)
Question 1: How often are the Account and Table master keys automaticall...
Question 2: A Snowflake user executed a query and received the results. ...
Question 3: A data provider wants to share data with a consumer who does...
Question 4: Which privilege must be granted to a share to allow secure v...
Question 5: Which of the following describes external functions in Snowf...
Question 6: Which of the following is an example of an operation that ca...
Question 7: What are common issues found by using the Query Profile? (Ch...
Question 8: For non-materialized views, what column in Information Schem...
Question 9: Which Snowflake feature allows a user to substitute a random...
Question 10: In the Snowflake access control model, which entity owns an ...
Question 11: Which of the following statements are true about Schemas in ...
Question 12: True or False: AWS Private Link provides a secure connection...
Question 13: Which Snowflake objects can be shared with other Snowflake a...
Question 14: Which commands should be used to grant the privilege allowin...
Question 15: What can be used to view warehouse usage over time? (Select ...
Question 16: True or False: Snowpipe via REST API can only reference Exte...
Question 17: What is the MOST performant file format for loading data in ...
Question 18: Which account__usage views are used to evaluate the details ...
Question 19: What is a best practice after creating a custom role?...
Question 20: A running virtual warehouse is suspended. What is the MINIMU...
Question 21: By default, which Snowflake role is required to create a sha...
Question 22: When should a multi-cluster warehouse be used in auto-scalin...
Question 23: User INQUISITIVE_PERSON has been granted the role DATA_SCIEN...
Question 24: Which command can be used to load data files into a Snowflak...
Question 25: What data is stored in the Snowflake storage layer? (Select ...
Question 26: Network policies can be set at which Snowflake levels? (Choo...
Question 27: How would a user execute a series of SQL statements using a ...
Question 28: What is the purpose of an External Function?...
Question 29: Which statements reflect key functionalities of a Snowflake ...
Question 30: What are ways to create and manage data shares in Snowflake?...
Question 31: Which of the following are valid Snowflake Virtual Warehouse...
Question 32: The number of queries that a Virtual Warehouse can concurren...
Question 33: A user is loading JSON documents composed of a huge array co...
Question 34: Which of the following objects are contained within a schema...
Question 35: Which of the following is a data tokenization integration pa...
Question 36: True or False: Pipes can be suspended and resumed....
Question 37: Which of the following describes a Snowflake stored procedur...
Question 38: Where would a Snowflake user find information about query ac...
Question 39: What is the minimum Snowflake edition required to create a m...
Question 40: The PUT command: (Choose two.)
Question 41: True or False: Reader Accounts incur no additional Compute c...
Question 42: What is the MINIMUM Snowflake edition required to use the pe...
Question 43: True or False: An active warehouse is required to run a COPY...
Question 44: What actions will prevent leveraging of the ResultSet cache?...
Question 45: Which copy INTO command outputs the data into one file?...
Question 46: True or False: Micro-partition metadata enables some operati...
Question 47: What is the minimum Snowflake edition that provides multi-cl...
Question 48: What is a machine learning and data science partner within t...
Question 49: True or False: Snowflake allows its customers to directly ac...
Question 50: How should a virtual warehouse be configured if a user wants...
Question 51: Which type of table corresponds to a single Snowflake sessio...
Question 52: A table needs to be loaded. The input data is in JSON format...
Question 53: What are the default Time Travel and Fail-safe retention per...
Question 54: Which of the following statements are true of Virtual Wareho...
Question 55: What versions of Snowflake should be used to manage complian...
Question 56: Which database objects can be shared with the Snowflake secu...
Question 57: Will data cached in a warehouse be lost when the warehouse i...
Question 58: A user has 10 files in a stage containing new customer data....
Question 59: How are serverless features billed?...
Question 60: Which Snowflake tool would be BEST to troubleshoot network c...
Question 61: True or False: Loading data into Snowflake requires that sou...
Question 62: True or False: The user has to specify which cluster a query...
Question 63: True or False: It is possible for a user to run a query agai...
Question 64: What is a responsibility of Snowflake's virtual warehouses?...
Question 65: The bulk data load history that is available upon completion...
Question 66: Which feature is only available in the Enterprise or higher ...
Question 67: A user has an application that writes a new Tile to a cloud ...
Question 68: What tasks can be completed using the copy command? (Select ...
Question 69: True or False: Reader Accounts are able to extract data from...
Question 70: Which of the following describes the Snowflake Cloud Service...
Question 71: Which of the following are options when creating a Virtual W...
Question 72: What features that are part of the Continuous Data Protectio...
Question 73: True or False: The COPY command must specify a File Format i...
Question 74: True or False: A Virtual Warehouse can be resized while susp...
Question 75: Which SQL commands, when committed, will consume a stream an...
Question 76: Which command can be used to load data into an internal stag...
Question 77: Which Snowflake technique can be used to improve the perform...
Question 78: A user created a new worksheet within the Snowsight Ul and w...
Question 79: Users are responsible for data storage costs until what occu...
Question 80: Assume there is a table consisting of five micro-partitions ...
Question 81: What internal stages are available in Snowflake? (Choose thr...
Question 82: Which of the following compute resources or features are man...
Question 83: True or False: Snowflake's Global Services Layer gathers and...
Question 84: Which Snowflake architectural layer is responsible for a que...
Question 85: Credit charges for Snowflake virtual warehouses are calculat...
Question 86: What happens when a virtual warehouse is resized?...
Question 87: Which methods can be used to delete staged files from a Snow...
Question 88: If a Small Warehouse is made up of 2 servers/cluster, how ma...
Question 89: The Snowflake Search Optimization Services supports improved...
Question 90: Which of the following objects can be cloned? (Choose four.)...
Question 91: A user has unloaded data from Snowflake to a stage Which SQL...
Question 92: A developer is granted ownership of a table that has a maski...
Question 93: Which data type can be used to store geospatial data in Snow...
Question 94: What are supported file formats for unloading data from Snow...
Question 95: Which of the following are characteristics of Snowflake virt...
Question 96: Which Snowflake layer is always leveraged when accessing a q...
Question 97: What happens when a cloned table is replicated to a secondar...
Question 98: If a Snowflake user decides a table should be clustered, wha...
Question 99: Which Snowflake feature will allow small volumes of data to ...
Question 100: What is the maximum total Continuous Data Protection (CDP) c...
Question 101: What SQL command would be used to view all roles that were g...
Question 102: Which statement about billing applies to Snowflake credits?...
Question 103: During periods of warehouse contention which parameter contr...
Question 104: In an auto-scaling multi-cluster virtual warehouse with the ...
Question 105: True or False: Fail-safe can be disabled within a Snowflake ...
Question 106: What are best practice recommendations for using the ACCOUNT...
Question 107: True or False: Bulk unloading of data from Snowflake support...
Question 108: Which privilege is required for a role to be able to resume ...
Question 109: What is the default character set used when loading CSV file...
Question 110: Which command sets the Virtual Warehouse for a session?...
Question 111: Which Snowflake partner specializes in data catalog solution...
Question 112: Which of the following statements describe features of Snowf...
Question 113: What are the responsibilities of Snowflake's Cloud Service l...
Question 114: Which of the following are best practice recommendations tha...
Question 115: A sales table FCT_SALES has 100 million records. The followi...