Practice Exam

Question 53 of 75

Enable Spark Job Access to Azure SQL Database

You work for MDFT Pro, a well-known training agency that processes student assessment data using advanced analytics. Claire, a Data Engineering Architect at MDFT Pro, manages a Fabric workspace named AnalyticsWorkspace that contains an Apache Spark job definition named AssessmentScoreProcessor. The company maintains an Azure SQL database named StudentAssessmentDB that contains detailed assessment results, quiz scores, and competency evaluations. For security and compliance reasons, StudentAssessmentDB has public internet access disabled and can only be accessed through private network connectivity. Claire needs to ensure that AssessmentScoreProcessor can securely access the data in StudentAssessmentDB to perform advanced scoring calculations and generate student performance insights. The solution must work with the existing security configuration that prohibits public internet access to the database.

What should Claire create to enable AssessmentScoreProcessor to access StudentAssessmentDB?

Choose the correct answer from the options below.

Explanations for each answer:

Learn more about managed private endpoints for Microsoft Fabric:
Managed Private Endpoints Overview
Next Question
Discuss this question on social media: