Microsoft 70-473 Designing and Implementing Cloud Data Platform Solutions Online Training
Microsoft 70-473 Online Training
The questions for 70-473 were last updated at Nov 20,2024.
- Exam Code: 70-473
- Exam Name: Designing and Implementing Cloud Data Platform Solutions
- Certification Provider: Microsoft
- Latest update: Nov 20,2024
You need to design a security strategy to support the planned changes for the customer databases, The solution must meet the security requirements.
Which two security roles should you grant to the customers? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A . db_datawriter
- B . dbcreator
- C . db_ddladmin
- D . db_datareader
You need to implement a disaster recovery solution that meets the technical requirements. The solution must NOT require customers to modify their connection strings.
Which disaster recovery solution should you implement?
- A . Transactional Replication to Azure
- B . AlwaysOn Availability groups
- C . Transaction Log Shipping
- D . failover cluster instances
You need to recommend a database strategy to support the planned new customers. The solution must minimize costs.
What should you recommend?
- A . a Basic database pool that has at least 1,200 eDTUs
- B . a Premium database pool that has at least 1,000 eDTUs
- C . 30 Basic databases
- D . 30 Premium P14 databases
DRAG DROP
You need to implement a solution to meet the technical requirements for the database administrators.
Which three actions should you perform in sequence from the Azure portal? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
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
loading process. You collect the IP addresses used by the Fabrikam administrators.
Which Transact-SQL command or Azure PowerShell cmdlet should you use next?
- A . sp_set_firewall_rule
- B . Set-AzureRmSqlServerFirewallRule
- C . sp_set_database_firewall_rule
- D . new-AzureRmSqlServerFirewallRule
Topic 5, Tailspin Toys
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
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.
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.
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.
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 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
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.
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 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.
You need to recommend a solution to meet the network requirement.
What should you recommend?
- A . Implement forced tunneling.
- B . Create a network security group (NSG) rule.
- C . Create an Azure virtual network gateway.
- D . Implement split tunneling.
You need to recommend a solution to meet the reporting requirements of App3.
What should you include in the recommendation?
- A . SQL Server replication
- B . database mirroring
- C . AlwaysOn Availability Groups
- D . Azure Data Sync
HOTSPOT
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.
DRAG DROP
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.
What should you use to schedule the nightly jobs to meet the technical requirements?
- A . Migrate the SQL Server Agent jobs.
- B . Create an Azure Scheduler task.
- C . Create an Azure runbook.
- D . Implement an Elastic Database jobs.
Latest 70-473 Dumps Valid Version with 162 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
