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 61–70 of 147

Q61

Which Azure service offers a fully managed NoSQL database?

  • A Azure Cosmos DB
  • B Azure SQL Database
  • C Azure Blob Storage
  • D Azure Virtual Machines
Explanation Azure Cosmos DB is a fully managed NoSQL database, while others serve different purposes.
Q62

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

  • A Azure Cosmos DB
  • B Azure SQL Database
  • C Azure Blob Storage
  • D Azure Data Lake Storage
Explanation Azure Blob Storage is designed for unstructured data, unlike Azure SQL which is relational.
Q63

You are configuring Azure Data Factory. What happens when the pipeline encounters an error during runtime?

  • A Pipeline stops and throws an exception
  • B Pipeline retries automatically until success
  • C Pipeline aborts and last run is saved
  • D Custom error handling can be defined
Explanation Azure Data Factory allows custom error handling, while others do not provide this flexibility.
Q64

Which service is primarily used for data storage in Azure?

  • A Azure Blob Storage
  • B Azure Functions
  • C Azure DevOps
  • D Azure Active Directory
Explanation Azure Blob Storage is designed for storing unstructured data; the others serve different purposes.
Q65

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

  • A Azure Cosmos DB
  • B Azure Stream Analytics
  • C Azure Data Factory
  • D Azure SQL Database
Explanation Azure Stream Analytics is specifically tailored for real-time data analysis, while the others do not focus on streaming.
Q66

What happens when configuring an Azure Virtual Network with overlapping address spaces?

  • A No impact, continue as normal
  • B Connectivity issues may arise
  • C Performance will improve significantly
  • D Security is enhanced automatically
Explanation Overlapping address spaces can lead to connectivity conflicts, whereas the other options do not accurately describe the network behavior.
Q67

Which service provides data warehousing capabilities in Azure?

  • A Azure Synapse Analytics
  • B Azure Blob Storage
  • C Azure Data Lake
  • D Azure Table Storage
Explanation Azure Synapse Analytics is specifically designed for data warehousing, unlike the other options.
Q68

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

  • A Azure Data Factory
  • B Azure Stream Analytics
  • C Azure Functions
  • D Azure SQL Database
Explanation Azure Stream Analytics is optimized for real-time data analysis, whereas the other services handle batch processing or other functionalities.
Q69

What happens when you set up a private endpoint for an Azure SQL Database?

  • A It disables public access
  • B It increases database performance
  • C It encrypts all data at rest
  • D It automatically scales the database
Explanation A private endpoint indeed restricts public access, while other options mention unrelated functionalities.
Q70

Which service is best for real-time data analytics?

  • A Azure Stream Analytics
  • B Azure Blob Storage
  • C Azure Data Lake Storage
  • D Azure Functions
Explanation Azure Stream Analytics is designed for real-time data processing, while others focus on storage and alternate functionalities.