70-473 · Question #58
Relecloud recently implemented the planned changes. you plan to add a new customer named Fabrikam, Inc. You need to ensure that the administrators at Fabrikam can access their data after the data load
The correct answer is A. sp_set_firewall_rule. Case Study 5 - Tailspin Toys (QUESTION 59 - QUESTION 66) 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 User in the London office and the New York
Question
Exhibit
Options
- Asp_set_firewall_rule
- BSet-AzureRmSqlServerFirewallRule
- Csp_set_database_firewall_rule
- Dnew-AzureRmSqlServerFirewallRule
How the community answered
(31 responses)- A74% (23)
- B16% (5)
- C3% (1)
- D6% (2)
Explanation
Case Study 5 - Tailspin Toys (QUESTION 59 - QUESTION 66) 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 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. 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. 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. 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 processes must be scheduled to execute righty at midright 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. 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 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 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'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.
Topics
Community Discussion
No community discussion yet for this question.
