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 21–30 of 150

Q21

You are configuring data encryption for a Data Lake in Azure. What type of encryption should you implement for automatically encrypting data at rest?

  • A Client-side encryption
  • B Server-side encryption
  • C Transport Layer Security
  • D No encryption needed
Explanation Server-side encryption is designed for automatic data encryption at rest, whereas the others do not perform this function.
Q22

Which service provides real-time analytics on streaming data?

  • A Azure Stream Analytics
  • B Azure Data Lake
  • C Azure Functions
  • D Azure Blob Storage
Explanation Azure Stream Analytics is designed for real-time analytics on streaming data; the others are not primarily focused on real-time analysis.
Q23

A company needs to move large amounts of data to a cloud environment quickly. Which Azure service should they use?

  • A Azure Data Factory
  • B Azure Data Lake
  • C Azure Logic Apps
  • D Azure Cosmos DB
Explanation Azure Data Factory is tailored for rapid data movement; the others are not specifically designed for this purpose.
Q24

What happens when a user exceeds the provisioned capacity in Azure SQL Database?

  • A Database crashes immediately
  • B Throttling of requests will occur
  • C Automatic scaling to higher tiers
  • D Error message with stored procedures
Explanation Throttling occurs to manage load, while others describe incorrect or unsupported behavior.
Q25

Which service helps in monitoring Azure cost trends?

  • A Azure Cost Management
  • B Azure Logic Apps
  • C Azure Functions
  • D Azure App Service
Explanation Azure Cost Management provides insights into spending trends, while others are for automation or app hosting.
Q26

A company needs real-time data processing of streaming data. Which Azure service should they use?

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

You are configuring a Databricks cluster with a low-cost option. What should you choose?

  • A Spot VMs for workers
  • B Standard VMs for all
  • C Dedicated nodes only
  • D Premium add-ons for performance
Explanation Spot VMs are cheaper for non-critical workloads, while the other options increase costs unnecessarily.
Q28

Which service is primarily responsible for data orchestration in Azure Fabric?

  • A Azure Data Factory
  • B Azure Functions
  • C Azure Storage
  • D Azure Databricks
Explanation Azure Data Factory specializes in data orchestration, while others serve different functions.
Q29

A company needs to manage sensitive data in Azure. What should they implement for strict access control?

  • A Static IP addressing
  • B Role-Based Access Control (RBAC)
  • C Virtual Network Integration
  • D Basic Authentication
Explanation RBAC allows fine-grained access management, unlike the other options.
Q30

You are configuring a real-time analytics pipeline. What would happen if you choose batch processing instead of stream processing?

  • A Immediate data insights
  • B Delayed data processing
  • C Higher cost of operations
  • D Increased data accuracy
Explanation Batch processing introduces delays as it's aggregated over time, unlike stream processing.