Practice Free DP-900 Exam Online Questions
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.
You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?
- A . Online Transaction Processing (OLTP)
- B . batch
- C . massively parallel processing (MPP)
- D . streaming
Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?
- A . Azure SQL Database Hyperscale
- B . Azure SQL managed instance
- C . Azure SQL Database serveless
- D . Azure SQL Database elastic pod
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?
- A . Microsoft SQL Server Management Studio (SSMS)
- B . Azure Data Studio
- C . Azure CLI
- D . Azure PowerShell
You have an Azure SQL database that contains tables for customers and orders. You need to create a query that will return the orders placed by each customer.
Which two Transact-SQL statements should you include in the query? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . JOIN
- B . ORDERBY
- C . INDEX
- D . SLLLCT
- E . EXISTS
When you create an Azure SQL database, which account can always connect to the database?
- A . the Azure Active director/ (Azure AO) account that created the database
- B . the Azure Active Directly Azure AD) administrator account
- C . the sa account
- D . the server admin login account of the logical server
Which clause should you use in a select statement to combine rows in one table with rows in another table?
- A . JOIN
- B . VALUES
- C . set
- D . KEY