Valid SnowPro-Core Dumps shared by ExamDiscuss.com for Helping Passing SnowPro-Core Exam! ExamDiscuss.com now offer the newest SnowPro-Core exam dumps, the ExamDiscuss.com SnowPro-Core exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com SnowPro-Core dumps with Test Engine here:
Access SnowPro-Core Dumps Premium Version
(630 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 159/249
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:
Correct Answer: B
- Question List (249q)
- Question 1: Snowflake is designed for which type of workloads? (Choose t...
- Question 2: Which formats are supported for unloading data from Snowflak...
- Question 3: True or False: When a new Snowflake object is created, it is...
- Question 4: What is the purpose of multi-cluster virtual warehouses?...
- Question 5: If a Small Warehouse is made up of 2 servers/cluster, how ma...
- Question 6: Which of the following roles is recommended to be used to cr...
- Question 7: True or False: Reader Accounts incur no additional Compute c...
- Question 8: Which of the following is the Snowflake Account_Usage.Meteri...
- Question 9: Which semi-structured file formats are supported when unload...
- Question 10: Which of the following are options when creating a Virtual W...
- Question 11: How would a user execute a series of SQL statements using a ...
- Question 12: How long is Snowpipe data load history retained?...
- Question 13: True or False: Snowpipe via RFST API can only reference Exte...
- Question 14: Increasing the size of a Virtual Warehouse from an X-Small t...
- Question 15: Which command should be used to download files from a Snowfl...
- Question 16: Users are responsible for data storage costs until what occu...
- Question 17: A company needs to read multiple terabytes of data for an in...
- Question 18: True or False: Pipes can be suspended and resumed....
- Question 19: Which semi-structured file formats are supported when unload...
- Question 20: Increasing the maximum number of clusters in a Multi-Cluster...
- Question 21: True or False: Query ID's are unique across all Snowflake de...
- Question 22: Which of the following significantly improves the performanc...
- Question 23: Which Snowflake feature is used for both querying and restor...
- Question 24: By default, which Snowflake role is required to create a sha...
- Question 25: Which statement is true about running tasks in Snowflake?...
- Question 26: The number of queries that a Warehouse can concurrently proc...
- Question 27: Which formats are supported for unloading data from Snowflak...
- Question 28: How many resource monitors can be assigned at the account le...
- Question 29: Assume there is a table consisting of five micro-partitions ...
- Question 30: When loading data into Snowflake via Snowpipe what is the co...
- Question 31: In an auto-scaling multi-cluster virtual warehouse with the ...
- Question 32: Increasing the maximum number of clusters in a Multi-Cluster...
- Question 33: Which formats are supported for unloading data from Snowflak...
- Question 34: True or False: A third-party tool that supports standard JDB...
- Question 35: Which cache type is used to cache data output from SQL queri...
- Question 36: Which are true of Snowflake roles?...
- Question 37: If a Small Warehouse is made up of 2 servers/cluster, how ma...
- Question 38: A single user of a virtual warehouse has set the warehouse t...
- Question 39: Which account__usage views are used to evaluate the details ...
- Question 40: Snowflake recommends, as a minimize, that all users with the...
- Question 41: Which of the following statements describes a benefit of Sno...
- Question 42: In which use cases does Snowflake apply egress charges?...
- Question 43: Which of the following can be executed/called with Snowpipe?...
- Question 44: What is a limitation of a Materialized View?...
- Question 45: How would a user run a multi-cluster warehouse in maximized ...
- Question 46: Which of the following describes a Snowflake stored procedur...
- Question 47: Snowflake is designed for which type of workloads? (Choose t...
- Question 48: True or False: A 4X-Large Warehouse may, at times, take long...
- Question 49: Which of the following describes how clustering keys work in...
- Question 50: Which of the following is a data tokenization integration pa...
- Question 51: How are serverless features billed?...
- Question 52: The PUT command: (Choose two.)
- Question 53: Which of the following objects is not covered by Time Travel...
- Question 54: Which of the following statements apply to Snowflake in term...
- Question 55: What is the MINIMUM edition of Snowflake that is required to...
- Question 56: True or False: When active, a pipe requires a dedicated Virt...
- Question 57: What is the minimum Snowflake edition that customers plannin...
- Question 58: Which interfaces can be used to create and/or manage Virtual...
- Question 59: Which of the following statements are true of VALIDATION_MOD...
- Question 60: Which command is used to unload data from a Snowflake table ...
- Question 61: A user unloaded a Snowflake table called mytable to an inter...
- Question 62: True or False: It is possible for a user to run a query agai...
- Question 63: True or False: Snowflake charges additional fees to Data pro...
- Question 64: A user has unloaded data from Snowflake to a stage Which SQL...
- Question 65: True or False: When you create a custom role, it is a best p...
- Question 66: A user is loading JSON documents composed of a huge array co...
- Question 67: Which of the following objects can be shared through secure ...
- Question 68: Which of the following terms best describes Snowflake's data...
- Question 69: True or False: Snowpipe via REST API can only reference Exte...
- Question 70: Network policies can be applied to which of the following Sn...
- Question 71: Which of the following describes external functions in Snowf...
- Question 72: True or False: Data Providers can share data with only the D...
- Question 73: What is a responsibility of Snowflake's virtual warehouses?...
- Question 74: Select the three types of tables that exist within Snowflake...
- Question 75: What happens when a Data Provider revokes privileges to a Sh...
- Question 76: What COPY INTO SQL command should be used to unload data int...
- Question 77: True or False: Snowflake's Global Services Layer gathers and...
- Question 78: Which of the following statements is true of data loading? S...
- Question 79: The Query History in the Snowflake Web Interface (UI) is kep...
- Question 80: Which of the following objects are contained within a schema...
- Question 81: Which type of table corresponds to a single Snowflake sessio...
- Question 82: What is the most granular object that the Time Travel retent...
- Question 83: Which statement best describes Snowflake tables?...
- Question 84: True or False: The COPY command must specify a File Format i...
- Question 85: Which stage type can be altered and dropped?...
- Question 86: True or False: All Snowflake table types include fail-safe s...
- Question 87: A user has an application that writes a new Tile to a cloud ...
- Question 88: For a multi-cluster Warehouse, the number of credits billed ...
- Question 89: True or False: Reader Accounts are able to extract data from...
- Question 90: True or False: A third-party tool that supports standard JDB...
- Question 91: True or False: You can query the files in an External Stage ...
- Question 92: True or False: Snowflake's data warehouse was built from the...
- Question 93: Which Snowflake technique can be used to improve the perform...
- Question 94: Which data types are supported by Snowflake when using semi-...
- Question 95: What is a best practice after creating a custom role?...
- Question 96: How does Snowflake allow a data provider with an Azure accou...
- Question 97: What are value types that a VARIANT column can store? (Selec...
- Question 98: Files have been uploaded to a Snowflake internal stage. The ...
- Question 99: What privileges are required to execute a task?...
- Question 100: Which of the following statements is true of data loading? S...
- Question 101: True or False: It is possible to load data into Snowflake wi...
- Question 102: If 3 size Small virtual warehouse is made up of two servers,...
- Question 103: Which object allows you to limit the number of credits consu...
- Question 104: Which statement about billing applies to Snowflake credits?...
- 1 commentQuestion 105: How would you execute a series of SQL statements using Task?...
- Question 106: True or False: AWS Private Link provides a secure connection...
- Question 107: Which of the following connectors allow Multi-Factor Authent...
- Question 108: Which type of table corresponds to a single Snowflake sessio...
- Question 109: Which statement describes how Snowflake supports reader acco...
- 1 commentQuestion 110: How often are the Account and Table master keys automaticall...
- Question 111: True or False: A single database can exist in more than one ...
- Question 112: Which statements are correct concerning the leveraging of th...
- Question 113: The fail-safe retention period is how many days?...
- Question 114: Account-level storage usage can be monitored via:...
- Question 115: True or False: Some queries can be answered through the meta...
- Question 116: When should you consider disabling auto-suspend for a Virtua...
- Question 117: Using variables in Snowflake is denoted by using which SQL c...
- Question 118: What is the most granular object that the Time Travel retent...
- Question 119: What is a responsibility of Snowflake's virtual warehouses?...
- Question 120: For non-materialized views, what column in Information Schem...
- Question 121: True or False: A Virtual Warehouse consumes Snowflake credit...
- Question 122: When should a multi-cluster warehouse be used in auto-scalin...
- Question 123: What features does Snowflake Time Travel enable?...
- Question 124: Which of the following commands sets the Virtual Warehouse f...
- Question 125: What data is stored in the Snowflake storage layer? (Select ...
- Question 126: Which of the following statements are true of Virtual Wareho...
- Question 127: What is the minimum Snowflake edition that provides multi-cl...
- Question 128: When cloning a database containing stored procedures and reg...
- Question 129: How many shares can be consumed by single Data Consumer?...
- Question 130: To run a Multi-Cluster Warehouse in auto-scale mode, a user ...
- Question 131: Which of the following is true of Snowpipe via REST API? (Ch...
- Question 132: During periods of warehouse contention which parameter contr...
- Question 133: Select the three types of tables that exist within Snowflake...
- Question 134: How many days is load history for Snowpipe retained?...
- Question 135: Snowflake provides two mechanisms to reduce data storage cos...
- Question 136: Which query profile statistics help determine if efficient p...
- Question 137: What actions will prevent leveraging of the ResultSet cache?...
- Question 138: What happens to the shared objects for users in a consumer a...
- Question 139: Which of the following are options when creating a virtual W...
- Question 140: A running virtual warehouse is suspended. What is the MINIMU...
- Question 141: True or False: Snowflake charges additional fees to Data pro...
- Question 142: Which statement best describes '' clustering''?...
- Question 143: Which statements reflect key functionalities of a Snowflake ...
- Question 144: When reviewing a query profile, what is a symptom that a que...
- Question 145: True or False: During data unloading, only JSON and CSV file...
- Question 146: Which of the following statements describes a benefit of Sno...
- Question 147: True or False: When a new Snowflake object is created, it is...
- Question 148: The number of queries that a Virtual Warehouse can concurren...
- Question 149: Why would a customer size a Virtual Warehouse from an X-Smal...
- Question 150: Select the different types of Internal Stages: (Choose three...
- Question 151: User INQUISITIVE_PERSON has been granted the role DATA_SCIEN...
- Question 152: A sales table FCT_SALES has 100 million records. The followi...
- Question 153: What is the default character set used when loading CSV file...
- Question 154: Which services does the Snowflake Cloud Services layer manag...
- Question 155: Which interfaces can be used to create and/or manage Virtual...
- Question 156: What happens to the underlying table data when a CLUSTER BY ...
- Question 157: Query compilation occurs in which architecture layer of the ...
- Question 158: Which of the following commands cannot be used within a read...
- 1 commentQuestion 159: Increasing the maximum number of clusters in a Multi-Cluster...
- Question 160: Fail-safe is unavailable on which table types?...
- Question 161: Which of the following features, associated with Continuous ...
- Question 162: Which of the following features are available with the Snowf...
- Question 163: True or False: Snowflake charges a premium for storing semi-...
- Question 164: True or False: A table in Snowflake can only be queried usin...
- Question 165: What can be used to view warehouse usage over time? (Select ...
- Question 166: Which of the following connectors are available in the Downl...
- Question 167: What tasks can be completed using the copy command? (Select ...
- Question 168: Which command can be used to load data files into a Snowflak...
- Question 169: When loading data into Snowflake, how should the data be org...
- Question 170: What type of query benefits the MOST from search optimizatio...
- Question 171: Where can a user find and review the failed logins of a spec...
- Question 172: When a Pipe is recreated using the CREATE OR REPLACE PIPE co...
- Question 173: True or False: A 4X-Large Warehouse may, at times, take long...
- Question 174: Which of the following statements are true of VALIDATION_MOD...
- Question 175: When scaling up Virtual Warehouse by increasing Virtual Ware...
- Question 176: True or False: A single database can exist in more than one ...
- Question 177: Which Snowflake object enables loading data from files as so...
- Question 178: Which of the following Snowflake capabilities are available ...
- Question 179: What is the recommended Snowflake data type to store semi-st...
- Question 180: What privileges are required to create a task?...
- Question 181: Which parameter can be used to instruct a COPY command to ve...
- Question 182: If a Small Warehouse is made up of 2 servers/cluster, how ma...
- Question 183: What is the maximum compressed row size in Snowflake?...
- Question 184: Which command can be used to load data into an internal stag...
- Question 185: Which statement best describes Snowflake tables?...
- Question 186: Which of the following connectors allow Multi-Factor Authent...
- Question 187: Which of the following statements is true of Snowflake?...
- Question 188: Which Snowflake technique can be used to improve the perform...
- Question 189: True or False: The user has to specify which cluster a query...
- Question 190: Which statement describes pruning?...
- Question 191: Select the three types of tables that exist within Snowflake...
- Question 192: True or False: Fail-safe can be disabled within a Snowflake ...
- Question 193: Which of the following connectors allow Multi-Factor Authent...
- Question 194: True or False: A Virtual Warehouse consumes Snowflake credit...
- Question 195: Which of the following is true of Snowpipe via REST API? Cho...
- Question 196: True or False: It is possible to unload structured data to s...
- Question 197: Which privilege is required for a role to be able to resume ...
- Question 198: Which of the following Snowflake features provide continuous...
- Question 199: Which of the following are main sections of the top navigati...
- Question 200: Which of the following activities consume virtual warehouse ...
- Question 201: How can a user change which columns are referenced in a view...
- Question 202: Which of the following can be used when unloading data from ...
- Question 203: True or False: Bulk unloading of data from Snowflake support...
- Question 204: Which object allows you to limit the number of credits consu...
- Question 205: Which Snowflake SQL statement would be used to determine whi...
- Question 206: True or False: AWS Private Link provides a secure connection...
- Question 207: True or False: Snowflake's Global Services Layer gathers and...
- Question 208: If auto-suspend is enable for a Virtual Warehouse, he Wareho...
- Question 209: What parameter controls if the Virtual warehouse starts imme...
- Question 210: Each incremental increase in Virtual Warehouse size (e,g. Me...
- Question 211: A user has 10 files in a stage containing new customer data....
- Question 212: A user has a standard multi-cluster warehouse auto-scaling p...
- Question 213: A Snowflake user executed a query and received the results. ...
- Question 214: What command is used to load files into an Internal Stage wi...
- Question 215: True or False: When Snowflake is configured to use Single Si...
- Question 216: When should you consider disabling auto-suspend for a Virtua...
- Question 217: A company's security audit requires generating a report list...
- Question 218: Where would a Snowflake user find information about query ac...
- Question 219: Which of the following are characteristics of security in Sn...
- Question 220: What are two ways to create and manage Data Shares in Snowfl...
- Question 221: Which of the following commands cannot be used within a read...
- Question 222: True or False: Users are able to see the result sets of quer...
- Question 223: Which of the following statements describes a benefit of Sno...
- Question 224: True or False: Each worksheet in the Snowflake Web Interface...
- Question 225: The FLATEEN function is used to query which type of data in ...
- Question 226: Which of the following connectors are available in the Downl...
- Question 227: Which of the following are valid Snowflake Virtual Warehouse...
- Question 228: True or False: Data in Fail-safe can be deleted by a user or...
- Question 229: Which of the following indicates that it may be appropriate ...
- Question 230: Which command sets the Virtual Warehouse for a session?...
- Question 231: Data storage for individual tables can be monitored using wh...
- Question 232: What is a machine learning and data science partner within t...
- 1 commentQuestion 233: How long is Snowpipe data load history retained?...
- Question 234: A virtual warehouse's auto-suspend and auto-resume settings ...
- Question 235: Query compilation occurs in which architecture layer of the ...
- Question 236: What is the default File Format used in the COPY command if ...
- Question 237: Which of the following Snowflake features provide continuous...
- Question 238: True or False: A customer using SnowSQL / native connectors ...
- Question 239: Which of the following is true of Snowpipe via REST API? Cho...
- Question 240: What is a machine learning and data science partner within t...
- Question 241: A deterministic query is run at 8am, takes 5 minutes, and th...
- Question 242: To run a Multi-Cluster Warehouse in auto-scale mode, a user ...
- Question 243: Which of the following are best practice recommendations tha...
- Question 244: Which statement best describes "clustering"?...
- Question 245: What is the MINIMUM Snowflake edition required to use the pe...
- Question 246: How a Snowpipe charges calculated?...
- Question 247: When scaling up Virtual Warehouse by increasing Virtual Ware...
- Question 248: True or False: It is possible for a user to run a query agai...
- Question 249: When a pipe is recreated using the CREATE on REPLAC PIPE com...
[×]
Download PDF File
Enter your email address to download Snowflake.SnowPro-Core.v2023-03-29.q249.pdf
Recent Comments (The most recent comments are at the top.)
The correct answer is C. Scaling Out, according to https://docs.snowflake.com/en/user-guide/warehouses-considerations
Scaling Up vs Scaling Out
Snowflake supports two ways to scale warehouses:
- Scale up by resizing a warehouse.
- Scale out by adding clusters to a multi-cluster warehouse (requires Snowflake Enterprise Edition or higher).