- (Exam Topic 5)
You have an Azure subscription that contains a server named Server1. Server1 hosts two Azure SQL databases named DB1 and DB2.
You plan to deploy a Windows app named App1 that will authenticate to DB2 by using SQL authentication. You need to ensure that App1 can access DB2. The solution must meet the following requirements:
App1 must be able to view only DB2.
Administrative effort must be minimized. What should you create?

Correct Answer:D
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/contained-database-users-making-your-databa

- (Exam Topic 5)
You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1.
You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync.
You need to recommend a database service for the deployment. The solution must minimize administrative effort.
What should you include in the recommendation?

Correct Answer:B
Azure SQL Database single database supports Data Sync. Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison

- (Exam Topic 5)
You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases.
Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution.
NOTE:Each correct selection is worth one point.

Correct Answer:ACE
CE: Estimate the vCores needed for the pool as follows:
For vCore-based purchasing model: MAX(,
A: Estimate the storage space needed for the pool by adding the number of bytes needed for all the databases in the pool.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview

- (Exam Topic 5)
You are monitoring an Azure Stream Analytics job.
You discover that the Backlogged input Events metric is increasing slowly and is consistently non-zero. You need to ensure that the job can handle all the events.
What should you do?

Correct Answer:D
Backlogged Input Events: Number of input events that are backlogged. A non-zero value for this metric implies that your job isn't able to keep up with the number of incoming events. If this value is slowly increasing or consistently non-zero, you should scale out your job, by increasing the SUs.
Reference:
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-monitoring

- (Exam Topic 5)
You have a Microsoft SQL Server 2017 server that hosts five databases. You Plan to migrate the databases to Azure.
You need to recommend a solution that meets the following requirements:
Automatically scales compute based on the workload demand
Provides per-second billing
What should you include in the recommendation? To answer, select the appropriate options in the answer area.

Solution:


Does this meet the goal?

Correct Answer:A

- (Exam Topic 5)
You have an Azure SQL database named DB1. A user named User 1 has an Azure AD account.
You need to provide User1 with the ability to add and remove columns from the tables inDBV The solution must use the principle of least privilege.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point

Correct Answer:AD