Whenever possible.

Overview
Tailspin Toys is a worldwide manufacturing company that operates on several continents.
The company has datacenters in London and New York.
Existing Environment
Technical Problems
Users in London office and New York office report quick response times when they connect to the datacenters. Users in all other office report slow response times.
Application Environment
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 Changes
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 Server license plans be implemented, whenever possible.
Technical Requirements
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 process must be scheduled to execute nightly at midnight Eastern Time (UTC-5). The implementation of the business processes must minimize administrative effort.
Networking requirements
All Internet traffic initiated from the servers in Azure must be routed through the local network firewalls and content filters.
Applications
App1
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 scale.
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 accesses 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 offices 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
App2 is developed by using third-party open source code that is updated frequently. The database for App2 is named DB2. App2 only supports MySQL. None of the developers at Tailspin Toys are skilled in 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.
App3
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 sizes 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’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 own on-premises solution for reporting.
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.
A.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.