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 141–147 of 147

Q141

What happens when an Azure SQL Database's DTU limit is reached?

  • A Database automatically restarts
  • B Queries are throttled
  • C All connections are terminated
  • D Data is lost temporarily
Explanation When the DTU limit is reached, queries are throttled to maintain performance, rather than the other dramatic scenarios.
Q142

Which service is used for serverless data integration?

  • A Azure Data Factory
  • B Azure Blob Storage
  • C Azure SQL Database
  • D Azure Synapse Analytics
Explanation Azure Data Factory enables serverless data integration, while others serve different purposes.
Q143

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

  • A Azure Logic Apps
  • B Azure Functions
  • C Azure Stream Analytics
  • D Azure Virtual Machines
Explanation Azure Stream Analytics is specifically designed for real-time data analysis, unlike the other options.
Q144

What happens when you scale up an Azure SQL Database?

  • A Data is lost during scaling
  • B Performance may temporarily decrease
  • C Storage size automatically decreases
  • D CPU and memory resources increase
Explanation Scaling up increases CPU and memory resources, enhancing performance and not risking data loss.
Q145

Which service provides a fully managed relational database?

  • A Azure SQL Database
  • B Blob Storage
  • C Azure Functions
  • D Cosmos DB
Explanation Azure SQL Database offers a fully managed relational database service, while the others serve different purposes.
Q146

A company needs to visualize real-time data from IoT devices. Which Azure service should it use?

  • A Azure Logic Apps
  • B Power BI
  • C Azure Data Lake Storage
  • D Azure Stream Analytics
Explanation Azure Stream Analytics is designed for real-time data visualization, while the other services do not focus on real-time analytics.
Q147

What happens when you exceed the limits of Azure Blob Storage?

  • A Data automatically deletes oldest blobs
  • B You cannot write more data
  • C Increased latency on data retrieval
  • D Service becomes unavailable temporarily
Explanation Exceeding the limits prevents further data write operations, while the other options do not accurately reflect how Blob Storage works.