Microsoft Azure

Implementing Analytics Solutions Using Microsoft Fabric

DP-600

Learn to implement analytics solutions with the DP-600 exam focused on Microsoft Fabric.

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

Questions 121–130 of 150

Q121

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

  • A Azure Stream Analytics
  • B Azure Batch
  • C Azure SQL Database
  • D Azure Functions
Explanation Azure Stream Analytics processes real-time data, while others do not focus on real-time analytics.
Q122

A company needs to manage data pipelines efficiently. What should they use to orchestrate workflows?

  • A Azure Data Factory
  • B Azure Logic Apps
  • C Azure Event Hubs
  • D Azure SQL Database
Explanation Azure Data Factory is specifically designed for data pipeline orchestration, unlike others in the list.
Q123

You are configuring data access in Azure. What happens when you assign a user a role with 'Reader' permissions?

  • A User can only view resources
  • B User can modify resources
  • C User can delete resources
  • D User can create resources
Explanation 'Reader' role allows only viewing resources, not modifications or deletions.
Q124

Which service provides data integration in Microsoft Fabric?

  • A Data Factory
  • B Azure SQL Database
  • C Power BI
  • D Azure Blob Storage
Explanation Data Factory enables data integration and orchestration, while others focus on analysis or storage.
Q125

A company needs real-time insights from streams of IoT sensors using Microsoft Fabric. Which service should they choose?

  • A Dataflow
  • B Stream Analytics
  • C Data Lake
  • D Azure Synapse
Explanation Stream Analytics is designed for real-time data processing, whereas others are suited for batch or storage.
Q126

What happens when you set a Dataflow to refresh every 10 minutes?

  • A Increased data latency
  • B Cost increases significantly
  • C Up-to-date data every 10 mins
  • D Data will be static until next refresh
Explanation Setting a refresh interval ensures data is updated regularly; other options misrepresent the refresh behavior.
Q127

Which Azure Fabric component is best for real-time analytics?

  • A Azure Data Lake
  • B Azure Stream Analytics
  • C Azure Blob Storage
  • D Azure Data Factory
Explanation Azure Stream Analytics is designed for real-time data processing, while the others are for storage or batch processing.
Q128

A company needs to integrate on-premises data with Azure analytics services securely. Which solution should they choose?

  • A Azure Data Factory
  • B Azure Synapse Analytics
  • C Azure Arc
  • D Azure Data Lake
Explanation Azure Data Factory enables hybrid data integration, while others do not primarily focus on on-premises integration.
Q129

You are configuring Azure Data Factory pipelines. What happens when you set the 'Fault tolerance' threshold to 5?

  • A Pipelines will retry 5 times
  • B Pipelines will fail immediately
  • C Pipelines will skip failed activities
  • D Pipelines will wait 5 minutes
Explanation Setting the threshold determines how many failures are tolerated and can lead to skipping failed activities instead of immediate failure.
Q130

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

  • A Azure Stream Analytics
  • B Azure SQL Database
  • C Azure Data Lake Storage
  • D Azure Machine Learning
Explanation Azure Stream Analytics provides real-time analytics for streaming data, while others serve different storage or processing purposes.