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 71–80 of 147

Q71

A company needs to provide analytics across multiple data sources. Which Azure service should they use?

  • A Azure Data Factory
  • B Azure SQL Database
  • C Azure Synapse Analytics
  • D Azure Cosmos DB
Explanation Azure Synapse Analytics integrates data from multiple sources for analytics, unlike the others which focus on individual data management.
Q72

You are configuring a new Azure SQL Database. What happens if you select ‘Hyperscale’ service tier?

  • A Automatic replication to multiple regions
  • B Capacity to scale storage and compute independently
  • C It becomes read-only after scaling
  • D Data is encrypted by default
Explanation Hyperscale allows storage and compute to scale independently, unlike other options which do not represent the Hyperscale feature.
Q73

Which Azure service is best for creating visual reports from data?

  • A Azure Data Lake
  • B Azure Synapse Analytics
  • C Power BI
  • D Azure Blob Storage
Explanation Power BI is specifically designed for visual reporting, unlike the others which serve different purposes.
Q74

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

  • A Azure Blob Storage
  • B Azure Stream Analytics
  • C Azure SQL Database
  • D Azure Functions
Explanation Azure Stream Analytics is tailored for real-time data analysis from IoT devices, making it the best choice here.
Q75

You are configuring a data processing pipeline. What happens when you set the latency to 'real-time' in Azure Data Factory?

  • A Batch processing occurs weekly.
  • B Data is processed instantly.
  • C Processing is delayed by minutes.
  • D No data will be processed.
Explanation 'Real-time' means data is processed immediately, which is the primary purpose of this setting, unlike other timeframes.
Q76

What type of service is Azure Blob Storage?

  • A Object storage service
  • B Relational database service
  • C Caching service
  • D Messaging service
Explanation Azure Blob Storage is specifically designed for storing unstructured data in blob format, while other options represent different types of cloud services.
Q77

A company needs to analyze streaming data in real-time. Which Azure service is most suitable?

  • A Azure Data Lake
  • B Azure Stream Analytics
  • C Azure SQL Database
  • D Azure Cosmos DB
Explanation Azure Stream Analytics excels in real-time data processing, while the other options are not optimized for streaming scenarios.
Q78

When configuring Azure Active Directory (AAD), what is the role of a 'Service Principal'?

  • A User account for management
  • B Security for data encryption
  • C Identity for applications
  • D Policy for resource access
Explanation A Service Principal is specifically used to represent an application identity in AAD, while the other options describe different concepts or functionalities.
Q79

Which Azure service is best for managing relational databases?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Cosmos DB
  • D Azure Data Lake Storage
Explanation Azure SQL Database is specifically designed for relational database management, while others serve different purposes.
Q80

A company needs to rapidly analyze large datasets in real-time. Which solution should they use?

  • A Azure Batch
  • B Azure Stream Analytics
  • C Azure Synapse Analytics
  • D Azure Data Factory
Explanation Azure Stream Analytics specializes in real-time data processing, while others focus on batch processing or data orchestration.