Practice Free DP-900 Exam Online Questions
You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?
- A . service principal authentication
- B . Azure Active Directory (Azure AD) authentication
- C . SQL authentication
- D . certificate authentication
B
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview
DRAG DROP
Match the Azure SQL services to the appropriate use cases.
To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.
What should the developers use?
- A . Azure Data Studio
- B . sq1cmd
- C . Microsoft SQL Server Management Studio (SSMS)
- D . Azure Data Explorer
A
Explanation:
Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux.
Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal.
Reference: https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio
DRAG DROP
Match the job roles to the appropriate tasks.
To answer, drag the appropriate role from the column on the left to its task on the right. Each role may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
What can you use to create data ingestion pipelines?
- A . Azure HDInsight
- B . Azure SQL Database
- C . Azure Data Factory
- D . Azure Cosmos DB
Which scenario is an example of a streaming workload?
- A . sending transactions that are older than a month to an archive
- B . sending transactions daily from point of sale (POS) devices
- C . sending telemetry data from edge devices
- D . sending cloud infrastructure metadata every 30 minutes
DRAG DROP
Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
You have a SQL query that combines customer data and order dat a. The query includes calculated columns.
You need to persist the SQL query so that other users can use the query.
What should you create?
- A . a table
- B . an index
- C . scalar function
- D . a view
D
Explanation:
A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/views/views