70-475 · Question #74
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might…
The correct answer is A. Yes. If you need the best performance, then use PolyBase to import data into Azure SQL warehouse. Note: Often the speed of migration is an overriding concern compared to ease of setup and maintainability, particularly when there's a large amount of data to move. Optimizing purely…
Question
Options
- AYes
- BNo
How the community answered
(21 responses)- A86% (18)
- B14% (3)
Explanation
If you need the best performance, then use PolyBase to import data into Azure SQL warehouse. Note: Often the speed of migration is an overriding concern compared to ease of setup and maintainability, particularly when there's a large amount of data to move. Optimizing purely for speed, a source controlled differentiated approach relying on bcp to export data to files, efficiently moving the files to Azure Blob storage, and using the Polybase engine to import from blob storage works best.
Topics
Community Discussion
No community discussion yet for this question.