Microsoft Azure

Microsoft Azure Data Fundamentals

DP-900

Start your data journey with the DP-900 exam covering Azure Data Fundamentals.

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

Questions 81–90 of 147

Q81

You are configuring Azure Storage redundancy. What happens if you choose Locally Redundant Storage (LRS)?

  • A Data stored across multiple regions
  • B Data replicated in three data centers
  • C Data stored only in one data center
  • D Data encrypted during transfer only
Explanation LRS stores data redundantly in a single region, specifically within one data center, unlike the other redundant storage options.
Q82

A company needs to store unstructured data for processing and analytics. Which Azure service should they choose?

  • A Azure Blob Storage
  • B Azure SQL Database
  • C Azure Data Lake Analytics
  • D Azure Cosmos DB
Explanation Azure Blob Storage is ideal for unstructured data, while Azure SQL and Cosmos DB target structured data and analytics, respectively.
Q83

What happens when you enable soft delete on an Azure storage account?

  • A Data is permanently deleted immediately
  • B Deleted data can be restored later
  • C Storage costs increase significantly
  • D Access to data is restricted
Explanation Soft delete allows for restoring deleted data within a retention period, while the other options describe behaviors that do not occur.
Q84

You are configuring a pipeline in Azure Data Factory to integrate with multiple sources. What feature allows you to ensure data accuracy and reliability?

  • A Data Flow Mapping
  • B Data Validation Activities
  • C Copy Data Tool
  • D Manual Data Entry
Explanation Data Validation Activities ensure data integrity during movement, whereas other options are not directly related to data accuracy checks.
Q85

Which service allows real-time data processing in Azure?

  • A Azure Stream Analytics
  • B Azure Blob Storage
  • C Azure SQL Database
  • D Azure Data Lake Storage
Explanation Azure Stream Analytics is designed for real-time data analysis, while the others are primarily for storage or database operations.
Q86

A company needs to store large volumes of unstructured data. Which Azure service should they use?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Table Storage
  • D Azure Cosmos DB
Explanation Azure Blob Storage is optimal for unstructured data storage, whereas the other options cater to structured formats or specific database use cases.
Q87

What happens when you exceed the limits of the Azure Free Tier?

  • A Your service stops immediately.
  • B You will be billed for overages.
  • C Your account is suspended.
  • D All resources are deleted.
Explanation Exceeding the Free Tier limits results in billing for overages, while the other options do not represent Azure's actual course of action.
Q88

Which Azure service is primarily used for real-time analytics on streaming data?

  • A Azure Stream Analytics
  • B Azure Data Lake
  • C Azure SQL Database
  • D Azure Blob Storage
Explanation Azure Stream Analytics processes real-time streaming data, while the others serve different data or storage needs.
Q89

A company needs to analyze large volumes of data from different sources. Which Azure service should they choose?

  • A Azure Synapse Analytics
  • B Azure App Service
  • C Azure Cosmos DB
  • D Azure Functions
Explanation Azure Synapse Analytics enables integrated analytics from various sources, while the others focus on app hosting, database solutions, or serverless functions.
Q90

What happens when you delete a file from Azure Blob Storage?

  • A File moved to Recycle Bin
  • B File is permanently deleted
  • C File is archived for recovery
  • D File is locked for 30 days
Explanation Deleting a file from Azure Blob Storage permanently removes it, unlike options suggesting recovery or delay.