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 81–90 of 150

Q81

You are configuring a data lake in Azure. What happens when you disable public network access?

  • A Data is deleted
  • B Access is restricted
  • C Storage costs increase
  • D Data encryption is disabled
Explanation Disabling public network access restricts who can access the data but does not delete or encrypt it.
Q82

Which service is primarily used for data integration in Azure?

  • A Azure Data Factory
  • B Azure Blob Storage
  • C Azure SQL Database
  • D Azure Functions
Explanation Azure Data Factory is for orchestrating data workflows, while others serve different purposes.
Q83

A company needs to ensure compliance with data residency regulations. What should they utilize?

  • A Azure Global Services
  • B Azure Regions
  • C Azure CDN
  • D Azure Functions
Explanation Azure Regions allow control over data residency, unlike the other options.
Q84

You are configuring data pipeline error handling in Azure Data Factory. What happens if you set the Continue On Error option?

  • A Pipeline stops immediately
  • B Errors will be logged only
  • C Pipeline continues regardless of errors
  • D Error messages replace existing data
Explanation Setting Continue On Error allows the pipeline to proceed, while others hinder execution.
Q85

Which service is best for real-time analytics in Azure?

  • A Azure Stream Analytics
  • B Azure Data Lake
  • C Azure Blob Storage
  • D Azure Virtual Machines
Explanation Azure Stream Analytics processes real-time data streams, whereas others serve different purposes.
Q86

A company needs to store large volumes of unstructured data cost-effectively. Which Azure solution is optimal?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Cosmos DB
  • D Azure Table Storage
Explanation Azure Blob Storage is designed for unstructured data efficiently, while others are not as cost-effective for large volumes.
Q87

You are configuring data retention policies in Azure Data Lake. What happens if you set a policy to 'delete' aged data?

  • A Data is permanently deleted
  • B Data is archived
  • C Data is moved to another storage
  • D Data is marked as 'Inactive'
Explanation A 'delete' policy results in permanent deletion of data, while others imply preservation.
Q88

Which service in Azure is primarily used for real-time analytics on streaming data?

  • A Azure Stream Analytics
  • B Azure SQL Database
  • C Azure Blob Storage
  • D Azure Data Lake
Explanation Azure Stream Analytics processes real-time data streams; the others are storage or database services.
Q89

A company needs to store data in a schema-less fashion with high scalability. Which Azure service should they choose?

  • A Azure SQL Database
  • B Azure Cosmos DB
  • C Azure Blob Storage
  • D Azure Table Storage
Explanation Azure Cosmos DB supports schema-less data and scales globally; the others have different storage structures.
Q90

What happens when you configure Azure Data Factory with a self-hosted integration runtime?

  • A Only cloud data can be processed
  • B On-premises data sources become accessible
  • C No transformations can be done
  • D Data movement is slower
Explanation Self-hosted integration runtime allows access to on-premises data; the others misrepresent its capabilities.