Image source: http://c.asstatic.com/images/2980399_636161622016315000-slide1_normal.png
B. AlwaysOn failover clustering
C. a upkeep plan
D. AlwaysOn Availability Groups
Answer:
Question: 1
Question: 5
Question: three
Answer: A
Answer:
DRAG DROP
You plan to put in energy row-stage steady practices for the CWDB database.
You create the fn_limitusers feature underneath the restriction schema.
You favor to create the policy.
How in case you comprehensive the policy? To respond, drag the right platforms to the exact locations. Each point would possibly neatly also be utilized once, greater than once, or on no account. You would possibly additionally neatly favor to drag the break up bar amongst panes or scroll to view content drapery.
You are comparing shifting the evidence from WebData1 to an Azure SQL database.
You favor to endorse an respond to generate the consolidated report for billing. The solution meet the undertaking necessities.
What in case you consist of throughout the recommendation?
Question: 6
Question: 2
You are making plans the consolidation of the databases from Host1.
You favor to compliment which use to again up the evidence after the consolidation completes. What are two without doubt equipment that accomplish that focus on? Each precise respond gifts an entire solution.
Topic 1, Proseware, Inc.
Overview
General Overview
Proseware, Inc. is a program engineering emblem that has 100 staff of staff. Proseware has revenue, vending, accounts, human supplies IT, and structure departments.
The IT department has one staff committed to handling the inside supplies and one staff committed to handling buyer supplies, that's also made up our minds throughout the companys internet web hosting atmosphere.
Proseware develops internet internet sites, clean internet apps, and customized internet apps. The internet internet sites and the apps are hosted and maintained throughout the net web hosting atmosphere of Proseware.
Physical Locations
Proseware has two offices positioned in Seattle and Montreal. The Seattle place of business carries the entire hardware required to host its clients internet internet sites, internet apps, and databases. The Seattle place of business carries the IT staff for the net web hosting atmosphere.
The Montreal place of business carries the entire hardware required to host the companys within packages, databases, and internet internet sites.
Each place of business connects at once to the Internet. Testing screens that the minimum latency from the offices to Microsoft Azure is 20 ms.
Existing Environment
Internal Microsoft SQL Server Environment
Proseware uses a customized buyer relationship management (CRM) program.
The within Microsoft SQL Server atmosphere carries two actual servers named CRM-A and CRM-B. Both servers run SQL Server 2012 Standard and host databases for the CRM program.
CRM-A hosts the basic example and CRM-B hosts the reflected example of the CRM database. RM-A moreover hosts databases for greater than a couple of other packages that will probably be utilized by the companys within packages.
CRM-A has a quad core processor and 12 GB of RAM. CRM-' has a twin core processor and 8 GB of RAM.
Custom Web Applications Environment
Some Proseware clients request customized internet-dependent most again and again packages that require greater than only databases, at the side of SQL Server Integration Services (SSIS) and CLR kept procedures.
Proseware uses a Hyper-V server named Host1. Host1 has four prerequisites of SQL Server 2014 Enterprise throughout the host working system. The prerequisites are reflected on a server named Host2.
Host1 moreover hosts four virtual machines named VM1, VM2, VM3, and VM4. VM1 has SQL Server 2005 Standard put in. VM2 has SQL Server 2005 Enterprise Edition put in. VM3 has SQL Server 2008 Standard Edition put in. VM4 has SQL Server 2008 R2 Standard Edition put in.
Host1 uses a SAN to buy the entire evidence and log place of business work for the four SQL Server prerequisites and the four virtual machines.
Websites and Basic Web Apps Environment
Proseware has two actual servers named WebServer1 and WebData1. WebServer1 hosts clean internet apps and internet internet sites for its clients. WebData1 has a database for each and every webpage and each and every clean internet app that Proseware hosts. WebData1 has four cores and 8 GB of RAM.
Each webpage database carries buyer methods for billing purposes. Proseware generates a consolidated report that carries evidence from all of those databases.
The relevant databases on WebData1 are:
*CWDB: Currently 60 GB and is in no manner and not using a doubt anticipated to exceed 100 GB. CWDB carries a desk named Personallinfo.
*MovieReviewDB: Currently 5 GB and is in no manner and not using a doubt anticipated to exceed 10 GB.
Marketing Department
Proseware has a internet-dependent most again and again app for the vending department. The internet app uses an Azure SQL database. Managers throughout the vending department quite often bulk load evidence making use of making use of a customized program. The database is up-to-date day-by-day.
Problem Statements
Proseware identifies the subsequent themes:
* Lack of making plans and capabilities has complicated the database atmosphere
* Customers who've internet apps hosted on Webserver1 report mounted outages equally about by disasters on
WebDatal. The supply uptime is underneath ninety percentage .
* internally customers bitch of sluggish functionality by the CRM program whilst the databases fail over to CRM-B
* WebDatal has no high availability danger for the databases or the server.
* An within licensing audit of SQL Server identifies that Proseware is non compliant. Hostl, CRM- A, and CRM-B are approved adequately. VM1 VM2, VM3, VM4, and WebDatal are unlicensed.
Business Requirements
Proseware identifies the subsequent undertaking necessities:
Question: four
Security Requirements
Proseware hosts a database for a corporation named Contoso, Ltd. Currently, the entire staff of staff at Contoso can get entry to the entire evidence throughout the database.
Contoso plans to restriction consumer get entry to to the CWDU database so as that buyer service representatives can see most productive the evidence from the PersonalInfo desk that pertains to their personal clients.
Answer: D
Question: 7
Answer:
Answer:
HOTSPOT
You favor to compliment which use to migrate MovieReviewDB and CWDB.
Which intellect-set in case you go with for each and every database? To respond, go with the right commerce decisions throughout the respond vicinity.
Explanation:
References:
https://msdn.microsoft.com/en-us/library/dn765131.aspx
A. SQL Server Integration Services (SSIS)
B. SQL Server Analysis Services (SSAS)
C. an elastic database job
D. an elastic query
Explanation:
References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-cloud-migrate-compatible-employing-ssms-migration-wizard/
Answer: A,C
A. backup and fix making use of making use of Windows Azure Storage
B. log shipping
C. AlwaysOn Availability Groups
D. database mirroring
You favor to endorse a disaster therapy solution for the CRM program that meets the undertaking necessities.
What in case you endorse?
HOTSPOT
You are comparing the migration of the databases from Host1 and WebData1 to Azure.
You favor to endorse the first within your cost sequence solution for storing the database in Azure. The solution meet the undertaking necessities.
In the desk beneath, endorse the first within your cost sequence garage solution for Host1 and WebData1. NOTE: Make most productive one sequence in each and every column.
DRAG DROP
A vending department supervisor reviews that the vending department database carries mistaken evidence. The supervisor reviews that the evidence was precise the former day.
You favor to endorse a development to recuperate the evidence.
Which three objectives in case you endorse be completed in sequence? To respond, float the right objectives from the listing of objectives to the respond vicinity and get all of them set throughout the exact order.
