QUESTION: 85

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.

access to the latest features
complete control over backup and restore processes
in-database machine learning services
reduced administrative effort for managing the server infrastructure

Answer(s): A,D

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:

https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

Reveal Solution Next Question

QUESTION: 86

HOTSPOT (Drag and Drop is not supported)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: No
Microsoft handles all patching and updating of the SQL and operating system code. You don't have to manage the underlying infrastructure.

Box 2: Yes
SQL Database is a fully managed service that has built-in high availability, backups, and other common maintenance operations.

Box 3: No

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

Reveal Solution Next Question

QUESTION: 87

DRAG DROP (Drag and Drop is not supported)
You have a table named Sales that contains the following data.

You need to query the table to return the average sales amount per day. The output must produce the following results.

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: SELECT
Box 2: GROUP BY
Example:
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:

https://docs.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql

Reveal Solution Next Question

QUESTION: 88

When you create an Azure SQL database, which account can always connect to the database?

the Azure Active Directory (Azure AD) account that created the database
the server admin login account of the logical server
the Azure Active Directory (Azure AD) administrator account
the sa account

Answer(s): B

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:

https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart

Reveal Solution Next Question

Free DP-900 Exam Braindumps (page: 22)

QUESTION: 85

Explanation:

Reference:

QUESTION: 86

Explanation:

Reference:

QUESTION: 87

Explanation:

Reference:

QUESTION: 88

Explanation:

Reference: