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 51–60 of 150

Q51

What happens when you query a materialized view in Azure Synapse Analytics?

  • A Query uses pre-computed data.
  • B Real-time data is always used.
  • C Performance is significantly slower.
  • D Materialized views cannot be updated.
Explanation Materialized views store pre-computed data for faster querying, while the others are incorrect statements.
Q52

Which Azure service is primarily used for data orchestration?

  • A Azure Data Factory
  • B Azure Storage
  • C Azure Synapse
  • D Azure Databricks
Explanation Azure Data Factory specializes in data orchestration, while others serve different purposes.
Q53

A company needs to analyze real-time streaming data. Which service should they use?

  • A Azure SQL Database
  • B Azure Stream Analytics
  • C Azure Blob Storage
  • D Azure Data Lake
Explanation Azure Stream Analytics is designed for real-time data analysis, unlike the others.
Q54

What happens when you set a data retention period on Azure Blob Storage?

  • A Data is deleted automatically after retention.
  • B Data is archived to cheaper storage.
  • C Data becomes read-only after setting.
  • D No impact on data accessibility.
Explanation Setting a data retention period ensures automatic deletion after the specified duration.
Q55

Which service helps visualize data relationships in Azure Data Factory?

  • A Mapping Data Flow
  • B Data Lake Storage
  • C Azure Synapse Analytics
  • D Data Factory Pipelines
Explanation Mapping Data Flow specifically helps to visually design data transformations; the other options focus on storage or orchestration without visualization.
Q56

A company needs to automate their Azure storage lifecycle. What should they configure?

  • A Blob Lifecycle Management
  • B Azure Backup Policies
  • C Service Fabric
  • D Blob Metadata
Explanation Blob Lifecycle Management automates storage policies, while the others do not manage lifecycle specifically.
Q57

What happens when an Azure Data Factory pipeline fails during execution?

  • A All dependent pipelines restart
  • B Only failed activities are retried
  • C The pipeline exits without error
  • D The entire Data Factory stops running
Explanation Only the failed activities can be retried in a pipeline, while the other responses are incorrect in the context of Azure Data Factory's error handling.
Q58

Which service is primarily used for data warehousing in Azure?

  • A Azure Synapse Analytics
  • B Azure Blob Storage
  • C Azure Functions
  • D Azure Cosmos DB
Explanation Azure Synapse Analytics is designed for data warehousing, while others serve different purposes.
Q59

You are configuring an Azure Data Factory pipeline. A task fails due to a transient network error. What is the best approach to handle this?

  • A Retry the task automatically
  • B Immediately notify the admin
  • C Stop the entire pipeline
  • D Log the error and ignore it
Explanation Automatically retrying helps manage transient errors efficiently, while other options may not address the issue effectively.
Q60

A company needs to ensure that sensitive data in Azure SQL Database is encrypted. What must be enabled?

  • A Encryption at Rest
  • B Always Encrypted
  • C Network Security Group
  • D Access Control Lists
Explanation Always Encrypted provides encryption for sensitive data, while the others serve different security functionalities.