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 141–150 of 150

Q141

What happens when you set an Azure Data Factory pipeline to run on a schedule with a trigger?

  • A It processes the data immediately
  • B It runs periodically as defined
  • C It requires manual execution only
  • D It fails if no activity exists
Explanation A scheduled trigger runs the pipeline automatically at defined intervals, unlike the other options.
Q142

Which service is used for managing data transformation in Azure Fabric?

  • A Azure Data Factory
  • B Azure Blob Storage
  • C Azure Functions
  • D Azure Kubernetes Service
Explanation Azure Data Factory specializes in data transformation, while others serve different purposes.
Q143

A company needs to ensure reliable data stream ingestion in real-time. Which tool should they use?

  • A Azure Stream Analytics
  • B Azure Data Lake Storage
  • C Azure Synapse Analytics
  • D Azure Storage Explorer
Explanation Azure Stream Analytics is designed for real-time data ingestion, unlike the other options.
Q144

You are configuring a Data Warehouse in Azure Fabric. What happens when you set the performance level to 'cheapest'?

  • A Maximum performance guaranteed
  • B Lower data processing speed
  • C No cost associated
  • D Enhanced data security
Explanation Setting to 'cheapest' results in lower data processing speed, while others are misleading.
Q145

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

  • A Azure Stream Analytics
  • B Azure Logic Apps
  • C Azure Data Lake Storage
  • D Azure Blob Storage
Explanation Azure Stream Analytics is designed for real-time analytics, while the others focus on workflow automation or storage solutions.
Q146

A company needs to automate data ingestion into Azure Data Warehouse. Which tool should they use?

  • A Azure Data Factory
  • B Azure DevOps
  • C Azure Functions
  • D Azure Databricks
Explanation Azure Data Factory specializes in data integration and ETL automation, while the others serve different purposes.
Q147

You are configuring Azure Purview for data governance. What happens if you enable automatic scanning?

  • A Data is inaccessible
  • B Assets remain unchanged during discovery
  • C New data sources are detected automatically
  • D Existing classifications are deleted
Explanation Enabling automatic scanning allows Azure Purview to discover and register new data sources automatically, while other options are incorrect in this context.
Q148

Which service in Azure Fabric provides seamless data integration?

  • A Azure Data Factory
  • B Azure Blob Storage
  • C Azure SQL Database
  • D Azure Machine Learning
Explanation Azure Data Factory is designed specifically for data integration, while others serve different purposes.
Q149

A company needs to analyze real-time data from IoT devices. Which Azure service is most suitable?

  • A Azure SQL Database
  • B Azure Stream Analytics
  • C Azure Synapse Analytics
  • D Azure Blob Storage
Explanation Azure Stream Analytics is best suited for real-time data analysis from IoT sources.
Q150

You are configuring data access policies in Azure Fabric. What happens if you set a policy to deny all users access?

  • A No one can access the data
  • B Only admins retain access
  • C Public access is still available
  • D Data becomes read-only
Explanation Setting a policy to deny all means zero access for all users, including admins unless otherwise specified.