Microsoft
70-463 · Question #253
70-463 Question #253: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #253. The question stem and answer options stay visible for context.
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
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.