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 31–40 of 147

Q31

Which service provides relational database capabilities in Azure?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Cosmos DB
  • D Azure Functions
Explanation Azure SQL Database is designed for relational data; Blob Storage is for files, Cosmos DB is NoSQL, and Functions are for serverless compute.
Q32

A company needs to analyze data trends over time using stream inputs. Which Azure service should they use?

  • A Azure Data Lake Storage
  • B Azure Stream Analytics
  • C Azure Blob Storage
  • D Azure Virtual Machines
Explanation Azure Stream Analytics is optimized for real-time data streaming analytics; Data Lake is for storage, Blob Storage is file-based, and VMs are compute resources.
Q33

You are configuring a data retention policy in Azure Storage. What happens if the retention period is exceeded?

  • A Data is permanently deleted
  • B Data is archived
  • C Data is duplicated
  • D Data is preserved indefinitely
Explanation Exceeding the retention policy automatically triggers deletion of data; it is not archived, duplicated, or preserved indefinitely.
Q34

Which service is best for data transformation in Azure?

  • A Azure Data Factory
  • B Azure Blob Storage
  • C Azure Functions
  • D Azure SQL Database
Explanation Azure Data Factory specializes in data integration and transformation, while others serve different purposes.
Q35

A company needs to analyze large datasets efficiently in Azure. What service should they primarily consider?

  • A Azure Synapse Analytics
  • B Azure DevOps
  • C Azure App Service
  • D Azure Virtual Machines
Explanation Azure Synapse Analytics is designed for big data analysis, unlike the other options.
Q36

You are configuring a database in Azure. What happens if you exceed the maximum number of DTUs?

  • A Performance degrades temporarily
  • B Database is automatically deleted
  • C You can’t access the database
  • D The cost increases instantly
Explanation Exceeding DTUs leads to degraded performance, but does not result in a deletion or access issue.
Q37

Which Azure service is primarily used for building and deploying machine learning models?

  • A Azure Machine Learning
  • B Azure Databricks
  • C Azure Data Factory
  • D Azure Stream Analytics
Explanation Azure Machine Learning is designed for model development, while others serve different purposes.
Q38

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

  • A Azure Blob Storage
  • B Azure SQL Database
  • C Azure Cosmos DB
  • D Azure Table Storage
Explanation Azure Blob Storage is specifically optimized for unstructured data storage.
Q39

You are configuring access for a new Azure Data Lake Storage account. What should you do to ensure the least privilege principle?

  • A Assign Owner role to all users
  • B Assign Reader role to all users
  • C Assign specific roles to users
  • D Disable all access temporarily
Explanation Assigning specific roles avoids unnecessary permissions, adhering to least privilege.
Q40

Which Azure service is designed for big data analytics?

  • A Azure Synapse Analytics
  • B Azure Blob Storage
  • C Azure Functions
  • D Azure Cosmos DB
Explanation Azure Synapse Analytics integrates big data and data warehousing, while the others serve different purposes.