DP-900 Exam Questions: Azure Data Fundamentals

1. You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.
You need to embed documents and query results into a SQL notebook.
What should you use?

2. HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

3. You're designing a data storage solution in Azure for a file system where data blocks are frequently added to files but cannot be deleted once added. Which type of Azure Blob should you employ to accommodate this requirement?

4. What should you create first for an integration process that copies data from Microsoft Excel files to Parquet files by using Azure Data Factory?

5. What should you do to an existing Azure Storage account in order to support a data lake for Azure Synapse Analytics?

6. Which Azure data service allows you to store images, PDF files, and static JSON files?

7. When configuring key elements for Azure Table storage, which components must you consider to effectively organize and retrieve your data within the Azure environment?

8. Which service can you use to perpetually retrieve data from a Kafka queue, process the data, and write the data to Azure Data Lake?

9. In your company's infrastructure setup, there's a crucial need to establish secure connectivity between an Azure virtual machine and Azure SQL databases while ensuring that the databases remain shielded from exposure to the internet.

What solution should you implement to meet this requirement, balancing security and accessibility?

10. You're tasked with designing and modeling a database, and you're looking for a graphical tool that supports project-oriented offline database development.

Which tool should you choose for this database design and modeling task?

11. You are tasked with implementing a Software as a Service (SaaS) solution for data analytics in your Azure-based project. Among the following options, which services would you select to effectively meet the data analytics requirements for your scenario?

12. Which statement is an example of Data Manipulation Language (DML)?

13. Which data service allows you to migrate an entire Microsoft SQL Server to the Azure cloud without requiring that you manage the infrastructure after the migration?

14. Which of the following statements is true about Azure SQL Database?

15.

16. In the context of building data models for analytics in Azure, specifically within Microsoft Power BI, which data model element signifies the entities you intend to aggregate measures around?

17. You're tasked with gathering data from various sources to compile a comprehensive report for your company's quarterly review meeting. You need a tool that can seamlessly import data from multiple platforms and help you generate insightful reports.
Which tool should you use to import data from multiple data sources and create a report?

18. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Statements

1. Relational database tables contain columns and rows
2. Indexes in a relational database describe the data types in a table
3. A database view is a virtual table whose content is defined by a query

19. Which service is managed and serverless, avoids the use of Windows Server licenses, and allows for each workload to have its own instance of the service being used?

20. You're tasked with selecting the appropriate Azure Blob storage access tier for data that will only be accessed once per year and can tolerate an access time exceeding an hour. Which Azure Blob storage access tier should you opt for in this scenario?

21. Which azure storage solution allows you to aggregate data stored in JSON files for use in analytical reports without additional development effort?

22. In the context of creating a globally distributed database solution using Azure Cosmos DB, what approach would you take to ensure that users worldwide can seamlessly work with their localized replicas of the database?

23. You're tasked with implementing a data pre-processing solution in Azure that involves handling a substantial volume of data using Scala. In this context, which two Azure services provide comprehensive solutions for pre-processing data with Scala?

24. Within your stream processing architecture in Azure, you need a mechanism to persist the processed results as files for further analysis and archival. What Azure service or feature would best serve this purpose, allowing you to seamlessly store the processed results as files?

25. In your data processing workflow, which encompasses both batch and stream processing mechanisms, you aim to maintain transactional consistency throughout the entire process. What approach or tool should you employ to guarantee that transactional consistency is upheld while processing data across both batches and streams?

26.

27. Your team is planning to implement a comprehensive data solution in Azure, accommodating document, graph, and column-family databases. Which Azure data service should you choose to fulfill these diverse database requirements effectively?

28. You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to create a database object that would allow other users to rerun the same SQL query.
What should you create?

29. You're managing an e-commerce application hosted on Azure that interacts with an Azure SQL database for reading and writing data.

What type of processing does the e-commerce application primarily utilize?

30. Your team needs to store a vast quantity of files that will be shared with virtual machines via SMB (Server Message Block) in the Azure environment. Which type of Azure Storage should you employ for this purpose?

31. The Azure Cosmos DB ___________ API enables the use of SELECT statements to retrieve documents from Azure Cosmos DB.

32. You're exploring the architecture of Azure Synapse Analytics, particularly its massively parallel processing (MPP) engine.

What role does the MPP engine play in Azure Synapse Analytics?

33. An extract, transform, and load (ETL) process requires

34. In your Azure database environment, you have data stored across two tables, and you've recently established a relationship between these tables. What type of data configuration are you currently managing?

35. A visualization that shows a university's current student enrollment versus the maximum capacity is an example of ____________________ analytics.

36. Which deployment option offers the best compatibility when migrating an existing SQL Server on-premises solution?

37. In an Azure environment, which job role is primarily responsible for generating reports from a database and leveraging OLAP cubes?

38. Which API should you use to store and query JSON documents in Azure Cosmos DB?

39. Which Azure PaaS services can you use to create a pipeline for data ingestion and processing?

40. You're architecting a data solution in Azure Cosmos DB that involves data stored in the BSON format. Which Azure Cosmos DB API should you select to effectively manage data in this format?

41. What are two advantages of using normalization over not using normalization in a relational database? Each correct answer presents a complete solution.

42. Which service would you use to continually capture data from an IoT Hub, aggregate it over temporal periods, and store results in Azure SQL Database?

43. HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

44. You're tasked with selecting a data service for your company's new application. The application requires a database that can seamlessly scale up and down without any downtime. Which of the following options would be the most suitable choice?

45. You need to create an Azure Storage account.
Data in the account must replicate outside the Azure region automatically.
Which two types of replication can you use for the storage account?

46. What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

47. Which Azure Cosmos DB API should you use to work with data in which entities and their relationships to one another are represented in a graph using vertices and edges?

48. Your development team is exploring open-source database options for a new project that involves managing both relational and object data efficiently. Which of the following open-source databases would be the best fit for your project's requirements?

49. A team of developers, equipped with computers running both Windows 10 and Ubuntu Desktop, aims to establish connectivity to an Azure SQL database. They seek comprehensive code assistance features, including IntelliSense, to enhance their querying capabilities.

Which tool should the developers leverage for their database interaction needs?

50. For each of the following statements, select Yes if the statement is true. Otherwise, select No.

51. Which service allows you to perform on-demand analysis of large volumes of data from text logs, websites and IoT devices by using a common querying language for all the data sources?