Exam 70-776 topic 1 question 29 discussion

Actual exam question from Microsoft's 70-776

Question #: 29
Topic #: 1

You have a 2-TB text file stored in Microsoft Azure Blob storage.
You need to load the file to an Azure SQL data warehouse in the least amount of time possible. The solution must use all the available Data Warehouse Units
(DWUs).
What should you use to query the file?

A. an Azure Data Factory pipeline
B. a script uses the bcp utility
C. an external table
D. a Microsoft SQL Server Integration Services (SSIS) package

Show Suggested Answer

Suggested Answer: C 🗳️
PolyBase uses T-SQL external objects to define the location and attributes of the external data. The external object definitions are stored in SQL Data Warehouse.
The data itself is stored externally.
Incorrect Answers:
A: Azure Data Factory is a managed cloud service that's built for these complex hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects.
B: bcp loads directly to SQL Data Warehouse without going through Azure Blob storage, and is intended only for small loads.
References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-blob-storage-with-polybase

by [deleted] at April 4, 2025, 4:58 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!