nerdexam
Microsoft

70-475 · Question #75

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 B. No. If you need the best performance, then use PolyBase to import data into Azure SQL warehouse.

Implement Big Data batch processing solutions

Question

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 have more than one correct solution, while the others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You plan to deploy a Microsoft Azure SQL data warehouse and a web application. The data warehouse will ingest 5 TB of data from an on-premises Microsoft SQL Server database daily. The web application will query the data warehouse. You need to design a solution to ingest data into the data warehouse. Solution: You use the bcp utility to export CSV files from SQL Server and then to import the files to Azure SQL Data Warehouse. Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(32 responses)
  • A
    22% (7)
  • B
    78% (25)

Explanation

If you need the best performance, then use PolyBase to import data into Azure SQL warehouse.

Topics

#Azure SQL Data Warehouse#data ingestion#on-premises migration#batch ETL

Community Discussion

No community discussion yet for this question.

Full 70-475 Practice