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 91–100 of 147

Q91

Which service can manage schema for Azure Cosmos DB?

  • A Azure Data Factory
  • B Azure Data Lake
  • C Azure Schema Registry
  • D Azure Synapse Analytics
Explanation Azure Schema Registry manages schemas for Cosmos DB; others don't handle schema management specifically.
Q92

A company needs reliable storage for unstructured data with high availability. Which Azure service should they choose?

  • A Azure Blob Storage
  • B Azure Table Storage
  • C Azure SQL Database
  • D Azure Queue Storage
Explanation Azure Blob Storage is optimized for unstructured data; the others serve different data types or use cases.
Q93

What happens when you configure a view in Azure SQL Database without proper permissions?

  • A The view is created successfully.
  • B An error occurs during creation.
  • C The view is created but inaccessible.
  • D Permissions are automatically granted.
Explanation The view can be created but users without permissions cannot access it; errors occur only for failed creations, not for access restrictions.
Q94

Which service acts as a scalable message queue in Azure?

  • A Azure Queue Storage
  • B Azure Blob Storage
  • C Azure Data Lake Storage
  • D Azure SQL Database
Explanation Azure Queue Storage is designed for message queuing, while the others serve different purposes.
Q95

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

  • A Azure Stream Analytics
  • B Azure Data Factory
  • C Azure Blob Storage
  • D Azure Data Lake Storage
Explanation Azure Stream Analytics provides real-time analytics, while the others are not aimed at live analysis.
Q96

You are configuring an Azure Cosmos DB database. What happens when you choose the 'Gremlin' API?

  • A Use SQL for queries
  • B Execute document-based transactions
  • C Model graph structures
  • D Store only tabular data
Explanation The 'Gremlin' API allows for storing and querying graph structures, whereas the others pertain to different databases or formats.
Q97

Which service is used for big data analytics on Azure?

  • A Azure Synapse Analytics
  • B Azure App Service
  • C Azure Blob Storage
  • D Azure Functions
Explanation Azure Synapse Analytics specializes in big data analytics, while the others serve different purposes.
Q98

A company needs to analyze real-time data streams. Which solution is appropriate?

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

You are configuring an Azure service for scalability. What do you focus on?

  • A Vertical scaling only
  • B Horizontal scaling only
  • C Vertical and horizontal scaling
  • D Adding more data storage only
Explanation Both vertical and horizontal scaling are important for maximizing resource efficiency and scalability.
Q100

Which Azure service is used for data warehousing?

  • A Azure Synapse Analytics
  • B Azure Blob Storage
  • C Azure Data Lake
  • D Azure SQL Database
Explanation Azure Synapse Analytics is specifically designed for data warehousing, while others serve different purposes.