Dp 900 Microsoft Azure Data Fundamentals Practice Test - Set 1

Test your knowledge with this Dp 900 Microsoft Azure Data Fundamentals mock exam. Get real-world IT questions and prepare for certification success.

DP-900: Microsoft Azure Data Fundamentals - Exam Information

Exam Information

Exam Code

Dp 900 Microsoft Azure Data Fundamentals

Exam Title

DP-900: Microsoft Azure Data Fundamentals

Vendor

Microsoft

Difficulty

Beginner

Duration

60 Minutes

Question Format

Multiple Choice

Last Updated

February 25, 2025

The DP-900 exam tests knowledge of core data concepts and Azure data services.

Practice Test

Shop Best DP-900: Microsoft Azure Data Fundamentals Resources Worldwide Amazon

1. Which type of database is best suited for handling large amounts of structured relational data?

SQL Database
Blob Storage
NoSQL Database
File Storage

2. Which Azure service is used for large-scale data warehousing and analytics?

Azure Synapse Analytics
Azure Cosmos DB
Azure Data Factory
Azure Functions

3. Which Azure service is used for storing unstructured data such as images and videos?

Azure Blob Storage
Azure SQL Database
Azure Table Storage
Azure Queue Storage

4. Which Azure service is used for real-time data streaming and analytics?

Azure Stream Analytics
Azure Data Lake Storage
Azure Cosmos DB
Azure SQL Database

5. Which Azure service is used for managing NoSQL databases?

Azure Cosmos DB
Azure SQL Database
Azure Blob Storage
Azure Data Factory

6. Which Azure service is used for orchestrating data workflows and moving data between different sources?

Azure Data Factory
Azure SQL Database
Azure Monitor
Azure Cognitive Services

7. Which Azure service is used for managing and querying large datasets in a distributed file system?

Azure Data Lake Storage
Azure Cosmos DB
Azure Blob Storage
Azure SQL Managed Instance

8. Which Azure service is used for managing and analyzing time-series data?

Azure Time Series Insights
Azure Stream Analytics
Azure Data Factory
Azure Synapse Analytics

9. Which Azure service is used for managing and querying graph databases?

Azure Cosmos DB (Graph API)
Azure SQL Database
Azure Blob Storage
Azure Data Factory

10. Which Azure service is used for managing and querying key-value pairs?

Azure Table Storage
Azure SQL Database
Azure Blob Storage
Azure Data Factory

11. Which Azure service is used for managing and querying document databases?

Azure Cosmos DB (SQL API)
Azure SQL Database
Azure Blob Storage
Azure Data Factory

12. Which Azure service is used for managing and querying column-family databases?

Azure Cosmos DB (Cassandra API)
Azure SQL Database
Azure Blob Storage
Azure Data Factory

13. Which Azure service is used for managing and querying in-memory databases?

Azure Cache for Redis
Azure SQL Database
Azure Blob Storage
Azure Data Factory

14. Which Azure service is used for managing and querying data warehouses?

Azure Synapse Analytics
Azure SQL Database
Azure Blob Storage
Azure Data Factory

15. Which Azure service is used for managing and querying data lakes?

Azure Data Lake Storage
Azure SQL Database
Azure Blob Storage
Azure Data Factory

16. Which Azure service is used for managing and querying relational databases?

Azure SQL Database
Azure Cosmos DB
Azure Blob Storage
Azure Data Factory

17. Which Azure service is used for managing and querying NoSQL databases with MongoDB compatibility?

Azure Cosmos DB (MongoDB API)
Azure SQL Database
Azure Blob Storage
Azure Data Factory

18. Which Azure service is used for managing and querying NoSQL databases with Gremlin compatibility?

Azure Cosmos DB (Gremlin API)
Azure SQL Database
Azure Blob Storage
Azure Data Factory

19. Which Azure service is used for managing and querying NoSQL databases with Table API compatibility?

Azure Cosmos DB (Table API)
Azure SQL Database
Azure Blob Storage
Azure Data Factory

20. Which Azure service is used for managing and querying NoSQL databases with Cassandra compatibility?

Azure Cosmos DB (Cassandra API)
Azure SQL Database
Azure Blob Storage
Azure Data Factory

21. Which Azure service is used for analyzing data using SQL-like queries over large datasets?

Azure Data Lake Analytics
Azure Synapse Analytics
Azure Stream Analytics
Azure SQL Database

22. Which Azure service is used for creating and managing data pipelines?

Azure Data Factory
Azure Synapse Analytics
Azure Cosmos DB
Azure SQL Database

23. Which Azure service provides a managed relational database with built-in high availability?

Azure SQL Database
Azure Cosmos DB
Azure Blob Storage
Azure Data Lake Storage

24. Which Azure service is best suited for storing semi-structured data, such as JSON or XML?

Azure Cosmos DB
Azure Blob Storage
Azure SQL Database
Azure Table Storage

25. Which Azure service provides distributed, high-performance, and fault-tolerant file storage?

Azure Data Lake Storage
Azure Blob Storage
Azure Queue Storage
Azure Table Storage

26. Which Azure service is best suited for running data science workloads and building machine learning models?

Azure Databricks
Azure Data Factory
Azure Synapse Analytics
Azure Machine Learning

27. Which Azure service is best for organizing, managing, and analyzing large datasets stored in a distributed file system?

Azure Data Lake Storage
Azure Blob Storage
Azure SQL Database
Azure Table Storage

28. Which Azure service allows you to build, deploy, and manage machine learning models at scale?

Azure Machine Learning
Azure Databricks
Azure Synapse Analytics
Azure Cognitive Services

29. Which Azure service provides real-time analytics on data streams from various sources?

Azure Stream Analytics
Azure Synapse Analytics
Azure Data Lake Storage
Azure Data Factory

30. Which Azure service allows you to query data stored in a NoSQL database using SQL-like syntax?

Azure Cosmos DB (SQL API)
Azure SQL Database
Azure Blob Storage
Azure Table Storage

31. Which Azure service allows you to store large amounts of unstructured data, such as text and binary data?

Azure Blob Storage
Azure SQL Database
Azure Data Lake Storage
Azure Cosmos DB

32. Which Azure service provides a distributed and scalable NoSQL key-value store?

Azure Cosmos DB (Table API)
Azure SQL Database
Azure Blob Storage
Azure Data Factory

33. Which Azure service is ideal for building highly responsive applications that need low-latency access to data?

Azure Cache for Redis
Azure Cosmos DB
Azure Blob Storage
Azure Data Factory

34. Which Azure service is used for real-time ingestion and analysis of streaming data from various sources?

Azure Stream Analytics
Azure Data Lake Storage
Azure Synapse Analytics
Azure Data Factory

35. Which Azure service is used for managing and analyzing time-series data?

Azure Time Series Insights
Azure Stream Analytics
Azure SQL Database
Azure Synapse Analytics

36. Which Azure service is used for managing and querying graph databases?

Azure Cosmos DB (Graph API)
Azure SQL Database
Azure Blob Storage
Azure Data Factory

37. Which Azure service allows you to store and manage datasets for machine learning?

Azure Machine Learning
Azure Databricks
Azure Data Lake Storage
Azure Cognitive Services

38. Which Azure service is used for orchestration of data pipelines and data flow management?

Azure Data Factory
Azure Synapse Analytics
Azure Cosmos DB
Azure Blob Storage

39. Which Azure service is used to create and manage data models for machine learning?

Azure Machine Learning
Azure Databricks
Azure Data Lake Storage
Azure SQL Database

40. Which Azure service is used for analyzing large amounts of structured data in a data warehouse?

Azure Synapse Analytics
Azure SQL Database
Azure Blob Storage
Azure Data Factory

41. Which Azure service provides real-time analytics and decision-making capabilities for business intelligence?

Power BI
Azure SQL Database
Azure Databricks
Azure Cosmos DB

42. Which Azure service allows you to store data in a columnar format for analytics?

Azure Synapse Analytics
Azure Data Lake Storage
Azure Cosmos DB
Azure Blob Storage

43. Which Azure service enables you to store and analyze data using machine learning models?

Azure Machine Learning
Azure Databricks
Azure Synapse Analytics
Azure Cognitive Services

44. Which Azure service is used for high-throughput, low-latency data storage?

Azure Cosmos DB
Azure SQL Database
Azure Blob Storage
Azure Data Factory

45. Which Azure service allows you to store and manage files in a highly available and distributed manner?

Azure File Storage
Azure Blob Storage
Azure Table Storage
Azure Queue Storage

46. Which Azure service is used for analyzing real-time event streams?

Azure Stream Analytics
Azure Synapse Analytics
Azure Blob Storage
Azure Data Lake Storage

47. Which Azure service provides a fully managed NoSQL database with automatic scaling?

Azure Cosmos DB
Azure SQL Database
Azure Blob Storage
Azure Data Factory

48. Which Azure service is ideal for running large-scale distributed queries across multiple data sources?

Azure Synapse Analytics
Azure Data Factory
Azure Cosmos DB
Azure SQL Database

49. Which Azure service provides a managed, serverless platform for running SQL-based queries?

Azure Synapse Analytics
Azure SQL Database
Azure Data Lake Storage
Azure Blob Storage

50. Which Azure service is used to analyze time-series data?

Azure Time Series Insights
Azure Cosmos DB
Azure Blob Storage
Azure Data Factory

51. Which Azure service is used to store and analyze massive amounts of unstructured data?

Azure Data Lake Storage
Azure Blob Storage
Azure SQL Database
Azure Cosmos DB

52. Which Azure service is used to automate the movement and transformation of data?

Azure Data Factory
Azure Synapse Analytics
Azure Cosmos DB
Azure Data Lake Storage

53. Which Azure service is used to store and manage large amounts of structured data?

Azure SQL Database
Azure Cosmos DB
Azure Blob Storage
Azure Data Factory

54. Which Azure service is ideal for querying semi-structured data, such as JSON?

Azure Cosmos DB
Azure SQL Database
Azure Blob Storage
Azure Table Storage

55. Which Azure service is best for low-latency access to highly structured data?

Azure SQL Database
Azure Cosmos DB
Azure Blob Storage
Azure Data Factory

56. Which Azure service provides a platform for running distributed big data workloads?

Azure Synapse Analytics
Azure Data Factory
Azure Cosmos DB
Azure SQL Database

57. Which Azure service can be used to analyze streaming data from devices or applications?

Azure Stream Analytics
Azure Synapse Analytics
Azure SQL Database
Azure Blob Storage

58. Which Azure service provides data storage and query capabilities for data lakes?

Azure Data Lake Storage
Azure Blob Storage
Azure Cosmos DB
Azure SQL Database

59. Which Azure service is used to integrate, transform, and prepare data for analytics?

Azure Data Factory
Azure Synapse Analytics
Azure Cosmos DB
Azure SQL Database

60. Which Azure service is used to manage, monitor, and optimize Azure SQL Database resources?

Azure SQL Database Management
Azure SQL Database
Azure Cosmos DB
Azure Data Factory

The Dp 900 Microsoft Azure Data Fundamentals certification is a globally recognized credential for IT professionals. This practice test helps you prepare by covering key topics like hardware, networking, troubleshooting, and security.

Want more practice? Check out our other mock exams:

© 2025 ITCertRocket.com - Hands-On IT Lab Exercises & Certification Prep. All rights reserved.