What should you include in the recommendation?
You have a server named Server1 that runs Windows Server 2012.
You have a 3-TB database that will be moved to Server1.
Server1 has the following physical disks:
Three 2-TB SATA disks that are attached to a single IDE controller
One 1-TB SATA disk that is attached to a single IDE controller
You need to recommend a solution to ensure that the database can be moved to Server1.
The solution must ensure that the database is available if a single disk fails.
What should you include in the recommendation?
Which is the correct answer?
You are mastering the company database called Testing; you should back up the Testing
database fully. You do transaction log once every two hours from 08:00 to 17:00.You should
run database snapshots for the Testing database. You should develop database snapshot
every day at 07:00. At 8:30 the user removes the whole information on the Testing database
which was entered intothe CurrentSpeaker table yesterday. Deletion is the first step for the
database. It is now 11:45 and many other changes have happened in the database. You
should find solution to solve this problem .Which is the correct answer?
What should you include in the recommendation?
Your network contains an Active Directory domain named contoso.com. The domain
contains 10 sites. The sites are located in different cities and connect to each other by using
low-latency WAN links.
In each site, you plan to implement Microsoft System Center 2012 Configuration Manager
and to deploy multiple servers.
You need to recommend which Configuration Manager component must be deployed to
each site for the planned deployment.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.
Which trigger syntax should you use?
Click the Exhibit button.
You are developing a database using Microsoft SQL Server 2008. The database contains the tables
shown in the exhibit.
You are required to prevent parts from being deleted if they belong to a kit. If a part belongs to a kit,
the
delete should not occur and the IsDeleted column for the row should be changed to ‘True’. Parts can
be
deleted if they do not belong to a kit.
You have the following TransactSQL
statement to be used in a trigger:
UPDATE p
SET IsDeleted = 1
FROM KitPart kp
JOIN deleted d ON kp.PartID = d.PartID
JOIN Part p ON kp.PartID = p.PartID;
DELETE FROM p
FROM Part p
JOIN deleted d ON p.PartID = d.PartID
LEFT OUTER JOIN KitPart kp ON p.PartID = kp.PartID
WHERE kp.KitID IS NULL;
You need to implement the TransactSQL
statement in a trigger. Which trigger syntax should you use?
Which components should you identify?
Your network contains an Active Directory forest named contoso.com. The forest is
managed by using Microsoft System Center 2012.
You plan to create virtual machine templates to deploy servers by using the Virtual Machine
Manager Self-service Portal (VMMSSP).
To the Virtual Machine Manager (VMM) library, you add a VHD that has a generalized image
of Windows Server 2012.
You need to identify which VMM components must be associated with the image.
Which components should you identify? (Each correct answer presents part of the solution.
Choose all that apply.)
You need to monitor the SQL Server instance to record the use of features that will be discontinued
You migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008.
You need to monitor the SQL Server instance to record the use of features that will be
discontinued.
What should you do?
How many images should you recommend?
Your network contains an Active Directory forest named contoso.com.
You plan to deploy 200 new physical servers during the next 12 months by using Windows
Deployment Services (WDS). You identify four server builds for the 200 servers as shown in
the following table.
You need to recommend the minimum number of images that must be created for the
planned deployment.
How many images should you recommend?
You need to create a report that includes the following information…
Your network contains 50 servers that run Windows Server 2003 and 50 servers that run
Windows Server 2008.
You plan to implement Windows Server 2012.
You need to create a report that includes the following information:
The servers that run applications and services that can be moved to Windows Server 2012
The servers that have hardware that can run Windows Server 2012
The servers that are suitable to be converted to virtual machines hosted on Hyper-V hosts
that run Windows Server 2012
What should you do?
Which Active Directory infrastructure should you recommend?
Your company has a main office and a branch office. The main office contains 2,000 users.
The branch office contains 800 users. Each office contains three IP subnets.
The company plans to deploy an Active Directory forest.
You need to recommend an Active Directory infrastructure to meet the following
requirements:
Ensure that the users are authenticated by using a domain controller in their respective
office.
Minimize the amount of Active Directory replication traffic between the offices.
Which Active Directory infrastructure should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
What should you configure on each server?
DRAG DROP
Your network contains three servers named Server1, Server2, and Server3 that run
Windows Server 2012. Server3 is connected to a disk storage array.
You need to ensure that Server1 can store files on the storage array. The solution must
ensure that Server1 can access the storage as a local disk.
What should you configure on each server?
To answer, drag the appropriate configuration to the correct location in the answer area.
Each configuration may be used once, more than once, or not at all. Additionally, you may
need to drag the split bar between panes or scroll to view content.
