BenchMark Quizzes by MDFT Pro

Configure Azure Synapse To Receive PolyBase Data

You work for MDFT Pro, a well-known training agency that operates a managed data warehouse solution on Microsoft Azure. Mark, the Enterprise Data Architect, has asked you to configure Azure Synapse Analytics to load historical course sales data from Azure Blob Storage. The data is stored in Parquet format and contains millions of records about student enrollments, course purchases, and payment transactions. Mark needs you to use PolyBase to retrieve this data and load it into a large fact table called FactCourseSales in the data warehouse. He emphasizes that the configuration should follow best practices for security and performance.

Which four actions should you perform in sequence?

Choose all correct answers from the options below.

Explanations for each answer:

Create a master key on the database is correct. Creating a database master key is the first step required to encrypt the credentials used for accessing external data sources.
Create an external data source for Azure Blob Storage is correct. An external data source must be created to define the connection to Azure Blob Storage where the Parquet files are located.
Enable transparent data encryption is incorrect. Transparent data encryption is for securing data at rest in the database, not required for configuring PolyBase to load external data.
Create an external file format to map the Parquet files is correct. An external file format must be created to specify that the files are in Parquet format so PolyBase can properly read them.
Create the external table FactCourseSales is correct. Finally, the external table must be created to define the structure and provide access to the data in the Parquet files.
Load the data to a staging table is incorrect. Loading to a staging table is not part of the initial configuration sequence for PolyBase. The external table provides direct access to the data.

Learn more about PolyBase In SQL Server:

PolyBase In SQL Server

Practice Exam

Configure Azure Synapse To Receive PolyBase Data

Discuss this question on social media: