Get Full Version of the Exam
Users at Relecloud report slow performance when viewing reports from AzD801.
You need to identify the cause of the performance issue as quickly as possible. Which dynamic management view and performance monitor counter should you use? To answer, select the appropriate options in the answers area.
NOTE: Each correct selection is worth one point.
You need to recommend a database strategy to support the planned new customers. The solution must minimize costs.
What should you recommend?
a Basic database pool that has at least 1,200 eDTUs
a Premium database pool that has at least 1,000 eDTUs
30 Basic databases
30 Premium P14 databases
Correct Answer: C
Topic 5, Tailspin Toys
Tailspin Toys is a worldwide manufacturing company that operates on several continents. The company has datacenters in London and New York.
User in the London office and the New York office report quick response times when they connect to the datacenters. Users in all other offices report slow response times.
Tailspin Toys stores sensitive customer data.
The company uses several applications. An application named App1 uses Microsoft SQL Server as a back-end database. An application named App2 uses MySQL as a back-end database. customer audits of documents rarely occur. When an audit occurs, it is scheduled between the customer and the auditing team of Tailspin Toys.
Requirements Planned Charges
Tailspin Toys plans to migrate several workloads to Microsoft Azure. As part of the planned migration, the company requires that the lowest costs for monthly Azure services and for SQL Serverlicense planes be implemented, whenever possible.
The customer-sensitive data stored in Azure must be encrypted when at rest. The on-premises environment of Tailspin Toys has several jobs that support business processes scheduled by using the SQL Server Agent. After the migration to Azure, the business processes must be scheduled to execute righty at midright Eastern Time (UTC-5). The implementation of the business processes must minimize administrative effort.
All Internet traffic initiated from the servers in Azure must be routed through the local network firewalls and content filters.
App1 is developed and maintained by the developers at Tailspin Toys the company plans to make architectural changes to the application to achieve the best possible performance and state. The database for App1 is named DB1 and is 100-TB. 99.8 percent of the data in DB1 is large object binary (LOB) data. After the data is uploaded to DB1, the data is accessed frequently for 10 days; then the data is accessed rarely for 20 days; and then the data is never accessed, unless a customer audit occurs.
Users in multiple Tailspin Toys officers worldwide must use app1 to access the relational records stored in DB1.
App1 has a Service Level Agreement (SLA) that requires an uptime of 99.95 percent. After the planned migration to Azure, the finance department plans to replicate a subset of DB1 to an on- premises database for reporting purposes.
App2 is developed by using third-party open source code that is updated frequently. The database for App2 is named DB2. App2 only supports My SQL. None of the developers at Tailspin Toys are skilled is using MySQL DB2 is supported by a team of external developers. DB2 is 20 GB and is expected to reach 50 GB during the next five years. DB2 has a storage performance requirement of 200 IOPs.
DB2 must be highly available.
As part of the planned migration to Azure, Tailspin Toys is developing a new application named App3 that will provide business-to-business features. Some of the customers that will use App3 will have a single employee, while others will have tens of thousands of employees using the application.
Due to the different size of the workloads, Tailspin Toys is concerned that parameter sniffing will
hinder the performance of App3.
The web servers for App3 will be in multiple Azure regions and will use Traffic Manager. Customers worldwide will use App3. For each customer, the database for App3 must be located near the customer#39;s corporate office. The customer also must be able to choose additional regions in which to store read only copies of their database for an additional cost. Two hundred customers plan to use App3 as soon as it becomes available. The customers request that their data be made available to them for reporting purposes. Some customers plan to use reporting in Azure, while other customers plan to use their database for an additional cost.
App3 has an SLA that requires 99.95 percent uptime. The developers of App3 require an empty development database and a test database that contains data to test the application. The databases must be refreshed regularly.
What should you use to schedule the nightly jobs to meet the technical requirements?
Migrate the SQL Server Agent jobs.
Create an Azure Scheduler task.
Create an Azure runbook.
Implement an Elastic Database jobs.
Correct Answer: A
You need to recommend a solution to meet the reporting requirements of App3. What should you include in the recommendation?
SQL Server replication
AlwaysOn Availability Groups
Azure Data Sync
Correct Answer: D
You need to provision the database for DB2 in Azure. How should you provision the database?
To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You need to recommend a solution to meet the network requirement. What should you recommend?
Implement forced tunneling.
Create a network security group (NSG) rule.
Create an Azure virtual network gateway.
Implement split tunneling.
Correct Answer: C
You need to migrate DB2 to Azure.
Which utility should you use for each task?
To answer, drag the appropriate utilities to the correct tasks. Each utility may be used once, more than once, or not at all. You made need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
You need to identify the appropriate data architecture for App1. The solution must support the planned changes.
Which storage platforms should you identify for App1?
To answer, drag the appropriate storage platforms to the correct data types. Each storage platform 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
You need to implement a solution to meet the technical requirements for the encryption of the data in Appl. Which two features should you enable? Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point
Storage Account Encryption
Azure Key Vault
Dynamic Data Masking
Transparent Data Encryption (TDE)
Correct Answer: AD
Which database platform should App3 use?
Azure SQL Database
Azure Database for PostgreSQL
Azure Database for MySQL
an Azure virtual machine that has SQL Server installed