70-463 · Question #253
You have a database named Sales and a data warehouse named DataW. From Sales, you plan to bulk insert to a table in DataW that is more than 2 TB. The process will insert a minimum of 11 million rows s
The correct answer is D. non-durable staging table. Incorrect Answers: C: In-Memory OLTP can significantly improve the performance of transaction processing, data ingestion and data load, and transient data scenarios. It does not fit a data warehouse scenario. Exam Questions, Study Guides, Practice Tests. Lead the way to help you
Question
You have a database named Sales and a data warehouse named DataW. From Sales, you plan to bulk insert to a table in DataW that is more than 2 TB. The process will insert a minimum of 11 million rows simultaneously. You need to identify which data storage strategy must be used to minimize load times. Which data storage strategy should you identify?
Options
- Aa nonclustered columnstore
- BFileStream
- Ca durable In-Memory OLTP
- Dnon-durable staging table
How the community answered
(24 responses)- A13% (3)
- B4% (1)
- C4% (1)
- D79% (19)
Explanation
Incorrect Answers: C: In-Memory OLTP can significantly improve the performance of transaction processing, data ingestion and data load, and transient data scenarios. It does not fit a data warehouse scenario. Exam Questions, Study Guides, Practice Tests. Lead the way to help you pass any IT Certification exams, Implementing 100% Pass Guaranteed or Full Refund. Especially Vendor: Microsoft Exam 70 - 4 63 Exam Microsoft Version: 1 8 . 0 7 1 , Nortel, EXIN and so on. Our Slogan: First Test, First Pass. Help you to pass any IT Certification exams at the first try. You can reach us at any of the email addresses listed below. Any problems about IT certification or our products, you could rely upon us, we will give you satisfactory answers in 24 hours.
Topics
Community Discussion
No community discussion yet for this question.