nerdexam
Microsoft

DP-700 · Question #20

QUESTION 22 You have a Fabric workspace named Workspace1 that contains an Apache Spark job definition named Job1. You have an Azure SQL database named Source1 that has public internet access…

The correct answer is B. a managed private endpoint. To enable an Apache Spark job in Fabric to securely access an Azure SQL database with public internet access disabled, a managed private endpoint should be created. This establishes a private connection over Azure Private Link, ensuring secure data transfer.

Manage data governance and security

Question

QUESTION 22 You have a Fabric workspace named Workspace1 that contains an Apache Spark job definition named Job1. You have an Azure SQL database named Source1 that has public internet access disabled. You need to ensure that Job1 can access the data in Source1. What should you create?

Options

  • Aan on-premises data gateway
  • Ba managed private endpoint
  • Can integration runtime
  • Da data management gateway

How the community answered

(48 responses)
  • A
    6% (3)
  • B
    75% (36)
  • C
    4% (2)
  • D
    15% (7)

Why each option

To enable an Apache Spark job in Fabric to securely access an Azure SQL database with public internet access disabled, a managed private endpoint should be created. This establishes a private connection over Azure Private Link, ensuring secure data transfer.

Aan on-premises data gateway

An on-premises data gateway is used for connecting to data sources that are located on-premises, not for connecting to private Azure services.

Ba managed private endpointCorrect

A managed private endpoint establishes a private connection from the Fabric workspace's managed virtual network to Azure SQL Database, bypassing the public internet. This is the correct solution for accessing private resources securely from Fabric Spark jobs.

Can integration runtime

An integration runtime is used in Azure Data Factory or Azure Synapse Analytics for data integration tasks, but it's not the direct mechanism for establishing a private network link from Fabric Spark to an Azure SQL DB.

Da data management gateway

A data management gateway is an older term for an on-premises data gateway and serves the same purpose of connecting to on-premises sources.

Concept tested: Fabric Spark private access to Azure SQL Database

Source: https://learn.microsoft.com/en-us/fabric/networking/concepts-managed-private-endpoints

Topics

#Fabric#Azure SQL Database#Managed Private Endpoint#Network Security

Community Discussion

No community discussion yet for this question.

Full DP-700 Practice