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 11–20 of 147

Q11

A company needs to ensure that only specific users can access its sensitive data stored in Azure SQL Database. Which Azure feature should they implement?

  • A Role-Based Access Control (RBAC)
  • B Virtual Network
  • C Azure Key Vault
  • D Azure Data Lake
Explanation Role-Based Access Control (RBAC) manages user permissions effectively, unlike other options.
Q12

What happens when you delete a column in Azure Cosmos DB without using soft delete?

  • A Column can be restored later
  • B Data is permanently lost
  • C Data is archived automatically
  • D Operation fails with an error
Explanation Deleting a column without soft delete permanently removes the data, unlike other options.
Q13

Which Azure service provides on-demand cloud computing resources?

  • A Azure Virtual Machines
  • B Azure Functions
  • C Azure SQL Database
  • D Azure Blob Storage
Explanation Azure Virtual Machines provide scalable computing resources, while others serve different purposes like functions and databases.
Q14

A company needs to store a large amount of unstructured data, which service should they use?

  • A Azure Table Storage
  • B Azure Blob Storage
  • C Azure SQL Database
  • D Azure Cosmos DB
Explanation Azure Blob Storage is ideal for unstructured data; other options cater to structured or semi-structured data.
Q15

What happens when you enable geo-replication for an Azure SQL Database?

  • A Data is duplicated locally
  • B Data is stored in multiple regions
  • C Backup frequency increases
  • D Database size limitations apply
Explanation Geo-replication allows data to be replicated across multiple geographical regions, enhancing availability.
Q16

Which Azure service is used for large-scale data analysis?

  • A Azure Synapse Analytics
  • B Azure Functions
  • C Azure Blob Storage
  • D Azure App Service
Explanation Azure Synapse Analytics is designed for big data and analytics, while others focus on different functionalities.
Q17

A company needs to store structured data and perform complex queries quickly. Which service should they choose?

  • A Azure Data Lake Storage
  • B Azure SQL Database
  • C Azure Cosmos DB
  • D Azure Data Factory
Explanation Azure SQL Database is optimized for structured data and complex queries, unlike the others.
Q18

What happens when a data retention policy is applied in Azure Blob Storage?

  • A Data is permanently deleted immediately
  • B Data is archived after a set time
  • C Data can be deleted automatically
  • D Data access is restricted to admins
Explanation A data retention policy automates deletion of blobs older than specified age; others are misleading interpretations.
Q19

Which service is used for real-time analytics on big data in Azure?

  • A Azure Stream Analytics
  • B Azure Blob Storage
  • C Azure Data Factory
  • D Azure SQL Database
Explanation Azure Stream Analytics is designed for real-time data processing, while others serve different purposes.
Q20

A company needs to retain access to daily backups of their Azure SQL Database. What is the optimal approach?

  • A Enable Point-in-time restore
  • B Use Azure Blob Storage only
  • C Perform manual backups only
  • D Implement Azure Functions for tagging
Explanation Point-in-time restore allows full recovery based on retention policies, unlike the other options.