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 111–120 of 147

Q111

What happens when you exceed Azure SQL Database DTU limits?

  • A Database continues without issues
  • B Operational performance degrades
  • C Database will be deleted
  • D You lose access temporarily
Explanation Exceeding DTU limits degrades performance, whereas others are incorrect outcomes.
Q112

Which service allows for real-time data stream processing in Azure?

  • A Azure Stream Analytics
  • B Azure Data Factory
  • C Azure Cosmos DB
  • D Azure SQL Database
Explanation Azure Stream Analytics is specifically designed for real-time data processing, while the others serve different purposes.
Q113

A company needs to analyze unstructured data from social media. What Azure service is most suitable for this?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Data Lake Storage
  • D Azure Table Storage
Explanation Azure Data Lake Storage is optimal for large-scale unstructured data storage and analysis, unlike the other options mainly focused on structured data.
Q114

What happens when you choose a low performance tier for Azure SQL Database?

  • A Increased storage capacity
  • B Enhanced performance
  • C Lower costs with reduced IOPS
  • D Immediate scale-out capabilities
Explanation Choosing a low performance tier decreases costs but also limits IOPS, impacting performance.
Q115

Which Azure service allows you to analyze large data sets?

  • A Azure Synapse Analytics
  • B Azure Power BI
  • C Azure Functions
  • D Azure SQL Database
Explanation Azure Synapse Analytics is designed for big data analytics, while others serve different purposes.
Q116

A company needs to process streams of data in real-time. Which Azure service should they use?

  • A Azure Data Factory
  • B Azure Data Lake Storage
  • C Azure Stream Analytics
  • D Azure Blob Storage
Explanation Azure Stream Analytics is specifically built for real-time data processing, not batch or storage solutions like Data Factory or Blob Storage.
Q117

What happens when you configure a Cosmos DB with multi-region writes enabled?

  • A Data is stored in one region
  • B Latency is increased
  • C Conflict resolution is necessary
  • D Read performance decreases
Explanation Multi-region writes require managing data conflicts, while the other options do not accurately reflect its effects.
Q118

Which service is used for managing data lakes in Azure?

  • A Azure Data Lake Storage
  • B Azure Cosmos DB
  • C Azure Blob Storage
  • D Azure SQL Database
Explanation Azure Data Lake Storage is specifically designed for data lakes, while the others cater to different data storage needs.
Q119

A company needs to analyze large datasets in real time. Which Azure service should they use?

  • A Azure Synapse Analytics
  • B Azure Stream Analytics
  • C Azure Data Factory
  • D Azure Logic Apps
Explanation Azure Stream Analytics specializes in real-time data analysis, while the others are for batch processing or ETL.
Q120

What happens when you integrate Azure Data Factory with Azure Databricks?

  • A Data pipelines are simplified.
  • B Data quality is reduced.
  • C Real-time analytics is disabled.
  • D Data storage costs increase.
Explanation Integrating them simplifies data ingestion and transformation processes, while the others are incorrect outcomes.