Practice Free DP-900 Exam Online Questions
You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?
- A . Online Transaction Processing (OLTP)
- B . batch processing
- C . Online Analytical Processing (OLAP)
- D . stream processing
You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).
Which Azure service should you use to support the application?
- A . Azure Cosmos DB
- B . Azure Synapse Analytics
- C . Azure HDInsight
- D . Azure SQL Database
You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?
- A . Microsoft SQL Server Data Tools (SSDT)
- B . Microsoft SQL Server Management Studio (SSMS)
- C . Azure Databricks
- D . Azure Data Studio
Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
- A . WHERE
- B . SELECT
- C . JOIN
You have data saved in the following format.
Which format was used?
- A . XML
- B . yaml
- C . JSON
- D . HTML
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.
DRAG DROP
Match the data storage options to the appropriate types of data. To answer, drag the appropriate data storage option from the column on the left to its data type on the right. Each data storage option may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
DRAG DROP
Match the types of visualizations to the appropriate descriptions.
To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
