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

Q81

What happens when a data lake's access level is set to private?

  • A Everyone can access it.
  • B Only specified users access it.
  • C Data is encrypted automatically.
  • D It prevents data sharing entirely.
Explanation Private access restricts data access to only specified users; the other options misinterpret access control.
Q82

Which service in Microsoft Fabric enables real-time streaming analytics?

  • A Azure Stream Analytics
  • B Azure Data Lake
  • C Azure SQL Database
  • D Azure Synapse Analytics
Explanation Azure Stream Analytics is designed for real-time data processing; the others focus on storage or batch processing.
Q83

A company needs to analyze data stored in Azure Data Lake. Which integration feature is best for this?

  • A Data Factory Pipeline
  • B Power BI Direct Query
  • C Azure Functions
  • D Serverless SQL Pool
Explanation Serverless SQL Pool enables querying Data Lake directly; the others require transformation first.
Q84

What happens when you set a filter in Azure Machine Learning during model training?

  • A Increases model accuracy
  • B Reduces data input size
  • C Modifies model parameters
  • D Enhances feature selection
Explanation Setting a filter reduces the dataset used for training; the other options do not accurately describe the action.
Q85

Which service provides integration for real-time analytics on streaming data?

  • A Azure Event Hubs
  • B Azure Blob Storage
  • C Azure SQL Database
  • D Azure Data Lake Storage
Explanation Azure Event Hubs is designed for real-time data ingestion, while the others focus on storage and querying.
Q86

A company needs to monitor data flow between Azure services with minimal latency. What should they implement?

  • A Azure Data Factory
  • B Azure Synapse Analytics
  • C Azure Logic Apps
  • D Azure Stream Analytics
Explanation Azure Stream Analytics specializes in low-latency data processing, whereas the others are for batch processing or orchestration.
Q87

You are configuring data retention policies in Azure Data Lake Storage. What happens when the retention policy expires?

  • A Data is archived to cold storage
  • B Data is deleted permanently
  • C Data is moved to Azure Blob Storage
  • D Data remains unchanged
Explanation Expired data under retention policies is automatically deleted, while the others do not occur.
Q88

Which service in Microsoft Fabric is used for data ingestion?

  • A Data Factory
  • B Power BI
  • C Azure Stream Analytics
  • D Dataflows
Explanation Data Factory is designed for data ingestion, unlike the other options.
Q89

A company needs to visualize streaming data from IoT devices. What is the best approach?

  • A Store data in Azure SQL Database
  • B Use Azure Stream Analytics with Power BI
  • C Process data with HDInsight
  • D Use Azure Functions for data processing
Explanation Using Stream Analytics with Power BI enables real-time visualization.
Q90

You are configuring Azure Data Lake Storage. What occurs if you set an ACL that prohibits all access?

  • A Access granted only to admins
  • B No access for anyone at all
  • C Read access granted to non-owners
  • D Access permissions are ignored
Explanation Setting an ACL that prohibits all access denies access completely.