Post Top Ad

Post Top Ad

Selasa, 04 Oktober 2016

70-473 Real Exam

70-473 Real Exam

Topic 1, Proseware, Inc.


General Overview

Proseware, Inc. Is a software engineering business enterprise that has 100 personnel. Proseware has sales, marketing, bills, human resources IT, and improvement departments.

The IT department has one group committed to dealing with the internal assets and one group committed to managing patron assets, which can be positioned within the business enterprise’s website hosting surroundings.

Proseware develops websites, primary web apps, and custom net apps. The web sites and the apps are hosted and maintained in the website hosting surroundings of Proseware.

Physical Locations

Proseware has places of work located in Seattle and Montreal. The Seattle workplace includes all the hardware required to host its clients’ websites, internet apps, and databases. The Seattle workplace consists of the IT crew for the hosting environment.

The Montreal office includes all of the hardware required to host the business enterprise’s inner packages, databases, and websites.

Each office connects immediately to the Internet. Testing well-knownshows that the minimal latency from the places of work to Microsoft Azure is 20 ms.

Existing Environment

Internal Microsoft SQL Server Environment

Proseware makes use of a custom purchaser relationship control (CRM) software.

The internal Microsoft SQL Server environment contains two bodily servers named CRM-A and CRM-B. Both servers run SQL Server 2012 Standard and host databases for the CRM utility.

CRM-A hosts the foremost example and CRM-B hosts the reflected instance of the CRM database. RM-A also hosts databases for several different programs which might be utilized by the corporation’s inner packages.

CRM-A has a quad middle processor and 12 GB of RAM. CRM-' has a dual center processor and 8 GB of RAM.

Custom Web Applications Environment

Some Proseware customers request custom net-based programs that require more than simply databases, such as SQL Server Integration Services (SSIS) and CLR stored methods.

Proseware uses a Hyper-V server named Host1. Host1 has 4 times of SQL Server 2014 Enterprise in the host working machine. The times are mirrored on a server named Host2.

Host1 additionally hosts 4 digital machines named VM1, VM2, VM3, and VM4. VM1 has SQL Server 2005 Standard mounted. VM2 has SQL Server 2005 Enterprise Edition set up. VM3 has SQL Server 2008 Standard Edition set up. VM4 has SQL Server 2008 R2 Standard Edition installed.

Host1 uses a SAN to keep all of the information and log documents for the four SQL Server times and the four virtual machines.

Websites and Basic Web Apps Environment

Proseware has physical servers named WebServer1 and WebData1. WebServer1 hosts simple internet apps and web sites for its clients. WebData1 has a database for each internet site and each simple internet app that Proseware hosts. WebData1 has four cores and 8 GB of RAM.

Each internet site database includes client records for billing functions. Proseware generates a consolidated document that consists of facts from all of these databases.

The applicable databases on WebData1 are:

*CWDB: Currently 60 GB and isn't anticipated to exceed a hundred GB. CWDB includes a desk named Personallinfo.

*MovieReviewDB: Currently 5 GB and isn't predicted to exceed 10 GB.

Marketing Department

Proseware has an internet app for the advertising department. The web app makes use of an Azure SQL database. Managers in the advertising department on occasion bulk load statistics by means of the usage of a custom software. The database is up to date daily.

Problem Statements

Proseware identifies the following troubles:

* Lack of making plans and understanding has complicated the database surroundings

* Customers who have net apps hosted on Webserver1 report frequent outages caused by screw ups on

WebDatal. The cutting-edge uptime is much less than ninety percentage .

* internally customers whinge of gradual performance by using the CRM application when the databases fail over to CRM-B

* WebDatal has no excessive availability choice for the databases or the server.

* An internal licensing audit of SQL Server identifies that Proseware is non compliant. Hostl, CRM- A, and CRM-B are certified properly. VM1 VM2, VM3, VM4, and WebDatal are unlicensed.

Business Requirements

Proseware identifies the subsequent commercial enterprise necessities:

Security Requirements

Proseware hosts a database for a business enterprise named Contoso, Ltd. Currently, all of the personnel at Contoso can get right of entry to all the data in the database.

Contoso plans to restriction user get entry to to the CWDU database in order that customer support representatives can see most effective the data from the PersonalInfo table that pertains to their own clients.

Question: 1


You want to identify which techniques to use emigrate MovieReviewDB and CWDB.

Which method ought to you perceive for every database?To solution, choose the right options inside the solution area.




Https://azure.Microsoft.Com/en-gb/documentation/articles/sq.-database-cloud-migrate-compatible-the usage of-ssms-migration-wizard/

Question: 2

You are making plans the consolidation of the databases from Host1.

You want to perceive which methods to apply to returned up the records after the consolidation completes. What are two feasible techniques that obtain this intention?Each accurate solution offers a entire answer.


B. AlwaysOn failover clustering

C. A maintenance plan

D. AlwaysOn Availability Groups

Answer: A,C

Question: three

You need to propose a catastrophe restoration solution for the CRM application that meets the business requirements.

What should you advise?

A. Backup and restore with the aid of the usage of Windows Azure Storage

B. Log transport

C. AlwaysOn Availability Groups

D. Database mirroring

Answer: A

Question: 4


You are comparing the migration of the databases from Host1 and WebData1 to Azure.

You need to advise the most value-effective answer for storing the database in Azure. The solution should meet the enterprise requirements.

In the desk under, advise the maximum cost-effective garage answer for Host1 and WebData1. NOTE: Make handiest one selection in every column.


Question: 5

You are evaluating transferring the information from WebData1 to an Azure SQL database.

You need to recommend a strategy to generate the consolidated report for billing. The solution need to meet the enterprise requirements.

What should you consist of in the recommendation?

A. SQL Server Integration Services (SSIS)

B. SQL Server Analysis Services (SSAS)

C. An elastic database process

D. An elastic query

Answer: D

Question: 6


You plan to put in force row-level security for the CWDB database.

You create the fn_limitusers characteristic under the restrict schema.

You want to create the coverage.

How have to you whole the policy?To solution, drag the appropriate elements to the right locations. Each detail can be used once, greater than once, or never. You may also want to pull the cut up bar among panes or scroll to view content material.





Question: 7


A marketing department manager reviews that the advertising branch database consists of incorrect facts. The manager reports that the records turned into accurate the day past.

You want to endorse a way to get better the information.

Which three actions must you endorse be executed in series?To solution, pass the precise movements from the list of movements to the answer area and arrange them in the correct order.