Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft 70-473 Exam

Status: RETIRED
Exam Name: Designing and Implementing Cloud Data Platform Solutions
Exam Code: 70-473
Related Certification(s): Microsoft MCSE: Data Management and Analytics Certification
Certification Provider: Microsoft
Actual Exam Duration: 90 Minutes
Number of 70-473 practice questions in our database: 136 (updated: 29-06-2019)
Expected 70-473 Exam Topics, as suggested by Microsoft :
  • Topic 1: Design and implement database solutions for Microsoft SQL Server and SQL Database Design for high availability
  • Topic 2: disaster recovery
  • Topic 3: and scalability Monitor and manage database implementations on Azure
Disscuss Microsoft 70-473 Topics, Questions or Ask Anything Related

Currently there are no comments in this discussion, be the first to comment!

Free Microsoft 70-473 Exam Actual Questions

Note: Premium Questions for 70-473 were last updated On 29-06-2019 (see below)

Question #1

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.

Reveal Solution Hide Solution
Correct Answer: C, D

From Scenario: Security requirements

Relecloud identifies the following requirements:

Customers must be able to read data only. (db_datareader)

Customers must be able to create custom views. (db_ddladmin)

Customers must be able to use two-factor authentication when accessing Azure SQL databases.


Question #2

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?

Reveal Solution Hide Solution
Correct Answer: B

Scenario: Technical requirements

Relecloud identifies the following technical requirements:

If ServerDB0 and ServerDB2 fail, AzDB01 must be able to respond to customer requests for data.

The Always On availability groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012 (11.x), Always On availability groups maximizes the availability of a set of user databases for an enterprise. An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of read-write primary databases and one to eight sets of corresponding secondary databases.


Question #3

You need to recommend a database strategy to support the planned new customers. The solution must minimize costs.

What should you recommend?

Reveal Solution Hide Solution
Correct Answer: A

Scenario: Planned changes

Relecloud plans to move all of its customers to a delivery model that uses Azure SQL Database and plans to maintain a single database for each customer.

Relecloud plans to automate the process of creating the required infrastructure for each new customer, including the process of loading data to the customer databases.

Relecloud plans to onboard 30 new customer accounts during the next year. The data for the new customers is approximately 10 GB and has a static size. The new customers require a rapid response time to database queries and each customer has five to 10 concurrent logins.

Incorrect Answers:

B: A premium database pool would be more costly.


Question #4

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?

Reveal Solution Hide Solution
Correct Answer: D

The New-AzureRmSqlServerFirewallRule cmdlet creates a firewall rule for the specified Azure SQL Database server.

Database-level firewall rules enable clients to access certain (secure) databases within the same logical server. You can create these rules for each database (including the master database) and they are stored in the individual databases.


https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/new-azurermsqlserverfirewallrule?view=azurermps-6.7.0

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure

Question #5

You need to recommend a solution to meet the network requirement.

What should you recommend?

Reveal Solution Hide Solution
Correct Answer: C

Application Gateway operates as an application delivery controller and offers SSL termination, cookie-based session affinity, round-robin load distribution, content-based routing, ability to host multiple websites and security enhancements.

Scenario: Networking requirements

All Internet traffic initiated from the servers in Azure must be routed through the local network firewalls and content filters.

Incorrect Answers:

B: If you need basic network level access control (based on IP address and the TCP or UDP protocols), you can use Network Security Groups (NSGs). An NSG is a basic, stateful, packet filtering firewall, and it enables you to control access based on a 5-tuple.



Unlock Premium 70-473 Exam Questions with Advanced Practice Test Features:
  • Select Question Types you want
  • Set your Desired Pass Percentage
  • Allocate Time (Hours : Minutes)
  • Create Multiple Practice tests with Limited Questions
  • Customer Support
Get Full Access Now

Save Cancel