SnowPro-Core Exam Dumps | A user is loading JSON documents composed of a huge array containing multiple records into Snowflake.

<< Prev Question Next Question >>

Question 66/249

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

A. It removes the last element of the outer array.

B. It removes the outer array structure and loads the records into separate table rows,

C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

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...

Question 66/249

LEAVE A REPLY

Download PDF File