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 1–10 of 150

Q1

Which service would you use for real-time data stream processing in Azure?

  • A Azure Stream Analytics
  • B Azure Data Lake Storage
  • C Azure Blob Storage
  • D Azure Functions
Explanation Azure Stream Analytics specifically handles real-time data processing, whereas the others are primarily for storage or serverless functions.
Q2

You are configuring a pipeline in Azure Data Factory to move data from an on-premises SQL database to Azure Blob Storage once a day. What should you ensure?

  • A Data factory has local network access
  • B Staging data in Azure SQL first
  • C Create a manual trigger each day
  • D Data should be compressed before transfer
Explanation The data factory must have access to the on-premises network to move data, while the other options are unnecessary or incorrect for this scenario.
Q3

If you set a Data Lake file or folder to be immutable, what will happen?

  • A It can still be deleted by admins
  • B No modifications can be made
  • C Users can overwrite the data
  • D Immutable only for 30 days
Explanation An immutable file or folder prevents all modifications, including deletions, while the other options suggest incorrect behaviors.
Q4

Which service in Azure is specifically designed for real-time analytics on event data?

  • A Azure Event Hubs
  • B Azure Blob Storage
  • C Azure SQL Database
  • D Azure Data Factory
Explanation Azure Event Hubs is tailored for event streaming and real-time analytics, while others serve different purposes.
Q5

A company needs to ensure sensitive data is encrypted both at rest and in transit. Which Azure feature should they implement?

  • A Azure Virtual Network
  • B Azure Key Vault
  • C Azure Storage Service Encryption
  • D Azure Policy
Explanation Azure Storage Service Encryption provides encryption at rest, and in-transit options exist in other services.
Q6

You are configuring a pipeline in Azure Data Factory to copy data from an on-premises SQL Server to Azure Blob Storage. What is required for the integration?

  • A No additional requirements
  • B Self-hosted Integration Runtime
  • C Azure Data Lake Storage
  • D Virtual Network gateway
Explanation A Self-hosted Integration Runtime is needed for access to on-premises data services, while the others do not facilitate this scenario.
Q7

Which service provides a unified analytics environment in Azure?

  • A Azure Synapse Analytics
  • B Azure Functions
  • C Azure Logic Apps
  • D Azure Blob Storage
Explanation Azure Synapse Analytics integrates big data and data warehousing, while others serve different purposes.
Q8

A company needs to ensure its data in Azure is encrypted at rest. Which service should they use?

  • A Azure Key Vault
  • B Azure Data Lake
  • C Azure Monitor
  • D Azure Table Storage
Explanation Azure Key Vault manages encryption keys for various services, ensuring secure access and management.
Q9

What happens when an Azure Data Factory pipeline fails due to a transient error?

  • A It automatically retries based on policy
  • B It halts without any actions
  • C It sends an error notification immediately
  • D It rolls back all changes made
Explanation Azure Data Factory can be configured to retry on transient errors, improving resilience during data processing.
Q10

Which service would you use for large-scale data ingestion?

  • A Azure Data Lake Storage
  • B Azure Stream Analytics
  • C Azure Data Factory
  • D Azure Databricks
Explanation Azure Data Factory is designed for ETL tasks and large-scale data ingestion, while the others serve different purposes.