Microsoft Azure

Microsoft Certified: Fabric Data Engineer Associate

DP-700

Achieve the Fabric Data Engineer Associate certification with the DP-700 exam.

150 questions 0 views Free
Start Mock Test Timed · Full-length · Scored

Questions 131–140 of 150

Q131

A company needs to securely manage user permissions across multiple Azure services. What should they implement?

  • A Azure Resource Manager
  • B Azure Active Directory
  • C Azure Functions
  • D Azure Logic Apps
Explanation Azure Active Directory provides centralized identity management and access control, unlike the other options which do not specialize in permissions management.
Q132

You are configuring Azure Data Factory for daily pipeline runs. What happens if a pipeline has no activity end time?

  • A It fails immediately after starting
  • B It runs indefinitely
  • C It stops after one execution
  • D It raises a timeout error
Explanation Pipelines without an activity end time will run until manually stopped or until set conditions are met, while the other options do not correctly describe pipeline behavior.
Q133

Which service is primarily used for data integration in Azure Fabric?

  • A Azure Data Factory
  • B Azure Blob Storage
  • C Azure SQL Database
  • D Azure Functions
Explanation Azure Data Factory is specifically designed for data integration, whereas the others serve different purposes.
Q134

You are configuring a serverless SQL pool in Azure Fabric. What happens when you query data that isn't in-memory?

  • A Query fails immediately
  • B Data is retrieved from Azure Storage
  • C Query executes without performance hit
  • D Data is cached permanently
Explanation When querying, serverless SQL pools pull data from Azure Storage on-the-fly if it's not in-memory.
Q135

A company needs to prevent unauthorized data access in Azure Fabric. Which approach should they take?

  • A Use public IP address access
  • B Implement role-based access control
  • C Store data in multiple regions
  • D Enable anonymous user access
Explanation Role-based access control (RBAC) effectively restricts access based on assigned roles, unlike the other options.
Q136

Which Azure service is best for real-time analytics?

  • A Azure Synapse Analytics
  • B Azure Data Factory
  • C Azure Stream Analytics
  • D Azure Blob Storage
Explanation Azure Stream Analytics is specifically designed for real-time analytics, whereas the others serve different purposes.
Q137

A company needs to securely share data with external partners. What should they use?

  • A Azure Blob Storage
  • B Azure SQL Database
  • C Azure Data Share
  • D Azure Data Lake
Explanation Azure Data Share specifically facilitates secure data sharing, unlike the other options.
Q138

You are configuring a Data Factory pipeline. What happens if a failure occurs?

  • A Pipeline automatically retries all activities
  • B Pipeline stops and logs the error
  • C Pipeline completes with warnings only
  • D Pipeline sends an email notification
Explanation The default behavior is to stop and log errors; automatic retries can be configured but are not default.
Q139

Which Azure service provides real-time analytics on streaming data?

  • A Azure Stream Analytics
  • B Azure Data Lake
  • C Azure Blob Storage
  • D Azure Synapse Analytics
Explanation Azure Stream Analytics specializes in real-time data processing, unlike the other storage and analytics services.
Q140

A company needs to trigger an Azure Logic App based on a HTTP request. What is required in the Logic App configuration?

  • A Use 'When a HTTP request is received'
  • B Add a Recurrence trigger
  • C Incorporate Azure Event Grid
  • D Set a Schedule trigger
Explanation You need the HTTP request trigger specifically designed for this purpose, while the others are unrelated to HTTP requests.