The latest Microsoft DP-900 Azure Data Fundamentals certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the Microsoft DP-900 Azure Data Fundamentals exam and earn Microsoft DP-900 Azure Data Fundamentals certification.
Table of Contents
- DP-900 Question 81
- Exam Question
- Correct Answer
- Explanation
- DP-900 Question 82
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 83
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 84
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 85
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 86
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 87
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 88
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 89
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 90
- Exam Question
- Correct Answer
- Explanation
- Reference
DP-900 Question 81
Exam Question
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
Correct Answer
B. Azure Active Directory (Azure AD) authentication
Explanation
Microsoft Learn > Shared concepts > Security > Azure AD Authentication > Using multi-factor Azure Active Directory authentication
DP-900 Question 82
Exam Question
To complete the sentence, select the appropriate option in the answer area.
Transparent Data Encryption (TDE) encrypts __________.
Answer Area:
A. a column to protect data at rest and in transit.
B. queries and their results in order to protect data in transit.
C. the database to protect data at rest.
D. the server to protect data at rest.
Correct Answer
C. the database to protect data at rest.
Reference
Microsoft Learn > Shared concepts > Security > Transparent data encryption for SQL Database, SQL Managed Instance, and Azure Synapse Analytics
DP-900 Question 83
Exam Question
A team of developers has computers that run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as IntelliSense.
What should the developers use?
A. sqlcmd
B. Microsoft SQL Server Management Studio (SSMS)
C. Azure Data Studio
D. Azure Data Explorer
Correct Answer
C. Azure Data Studio
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
Microsoft Learn > Azure Data Studio > Download and install Azure Data Studio
DP-900 Question 84
Exam Question
Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. INSERT
C. DELETE
D. DROP
Correct Answer
D. DROP
Explanation
Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:
- ALTER
- Collations
- CREATE
- DROP
- DISABLE TRIGGER
- ENABLE TRIGGER
- RENAME
- UPDATE STATISTICS
- TRUNCATE TABLE
- UPDATE
Reference
Microsoft Learn > SQL > SQL Server > Transact-SQL statements
DP-900 Question 85
Exam Question
When you create an Azure SQL database, which account can always connect to the database?
A. the Azure Active Directory (Azure AD) account that created the database
B. the server admin login account of the logical server
C. the Azure Active Directory (Azure AD) administrator account
D. the sa account
Correct Answer
B. the server admin login account of the logical server
Explanation
When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin.
Reference
Microsoft Learn > Azure SQL Database (SQL DB) > Quickstarts > Quickstart: Create a single database – Azure SQL Database
DP-900 Question 86
Exam Question
You have a table named Sales that contains the following data.
| SalesDate | SalesAmount | ProductID |
|---|---|---|
| 4-Apr-20 | $2,000 | 1 |
| 5-Apr-20 | $40 | 2 |
| 5-Apr-20 | $2,300 | 1 |
| 6-Apr-20 | $40 | 3 |
| 6-Apr-20 | $200 | 4 |
You need to query the table to return the average sales amount per day. The output must produce the following results.
| SalesDate | AVG(SalesAmount) |
|---|---|
| 4-Apr-20 | $2,000 |
| 5-Apr-20 | $1,170 |
| 6-Apr-20 | $120 |
How should you complete the query?
Correct Answer
Explanation
<box 1>: SELECT
<box 2>: GROUP BY
When used with a GROUP BY clause, each aggregate function produces a single value covering each group, instead of a single value covering the whole table. The following example produces summary values for each sales territory in the AdventureWorks2012 database. The summary lists the average bonus received by the sales people in each territory, and the sum of year-to-date sales for each territory.
SELECT TerritoryID, AVG(Bonus)as ‘Average bonus’, SUM(SalesYTD) as ‘YTD sales’
FROM Sales.SalesPerson
GROUP BY TerritoryID;Reference
Microsoft Learn > SQL > SQL Server > AVG (Transact-SQL)
DP-900 Question 87
Exam Question
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Statement 1: If you have a platform as a service (PaaS) database in Azure, you are responsible for applying operating system updates.
Statement 2: If you have a platform as a service (PaaS) database in Azure, backups are performed automatically.
Statement 3: If you have a platform as a service (PaaS) database in Azure, you are responsible for upgrading the database engine.
Correct Answer
Statement 1: If you have a platform as a service (PaaS) database in Azure, you are responsible for applying operating system updates: No
Statement 2: If you have a platform as a service (PaaS) database in Azure, backups are performed automatically: Yes
Statement 3: If you have a platform as a service (PaaS) database in Azure, you are responsible for upgrading the database engine: No
Explanation
Statement 1: If you have a platform as a service (PaaS) database in Azure, you are responsible for applying operating system updates: No
Microsoft handles all patching and updating of the SQL and operating system code. You don’t have to manage the underlying infrastructure.
Statement 2: If you have a platform as a service (PaaS) database in Azure, backups are performed automatically: Yes
SQL Database is a fully managed service that has built-in high availability, backups, and other common maintenance operations.
Statement 3: If you have a platform as a service (PaaS) database in Azure, you are responsible for upgrading the database engine: No
Reference
Microsoft Learn > Azure SQL Database (SQL DB) > What is Azure SQL Database?
DP-900 Question 88
Exam Question
What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database?
A. access to the latest features
B. complete control over backup and restore processes
C. in-database machine learning services
D. reduced administrative effort for managing the server infrastructure
Correct Answer
A. access to the latest features
D. reduced administrative effort for managing the server infrastructure
Explanation
A: Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.
D: SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure.
Reference
Microsoft Learn > Azure > SQL Database (SQL DB) > What is Azure SQL Database?
DP-900 Question 89
Exam Question
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 HDInsight
C. Azure SQL Database
D. Azure Synapse Analytics
Correct Answer
C. Azure SQL Database
Explanation
Azure SQL Database is relational database and a managed service.
Incorrect Answers:
A, B: Cosmos DB, HDInsight are non-relational databases.
D: Azure Synapse Analytics is for data warehousing, not for Online Transaction Processing.
Reference
Azure Database Review: Your Guide for Database Assessment
DP-900 Question 90
Exam Question
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Statement 1: Azure Data Studio can be used to query an Azure SQL database from a device that runs macOS.
Statement 2: Microsoft SQL Server Management Studio (SSMS) enables users to create and use SQL notebooks.
Statement 3: Azure Data Studio can be used to restore a database.
Correct Answer
Statement 1: Azure Data Studio can be used to query an Azure SQL database from a device that runs macOS: Yes
Statement 2: Microsoft SQL Server Management Studio (SSMS) enables users to create and use SQL notebooks: No
Statement 3: Azure Data Studio can be used to restore a database: Yes
Explanation
Statement 1: Azure Data Studio can be used to query an Azure SQL database from a device that runs macOS: Yes
Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
You can use Azure Data Studio to connect to an Azure SQL Database server. You’ll then run Transact-SQL (T-SQL) statements to create and query Azure SQL databases.
Statement 2: Microsoft SQL Server Management Studio (SSMS) enables users to create and use SQL notebooks: No
SQL Server Management Studio is for configuring, managing, and administering all components within Microsoft SQL Server, not to create SQL notebooks.
Instead use Azure Data Studio to create SQL notebook.
Statement 3: Azure Data Studio can be used to restore a database: Yes
You can use the Azure Data Studio to restore databases.
Reference
Microsoft Learn > Azure Data Studio > What is Azure Data Studio?