Which of the following actions should you take?
You work as an administrator at Contoso.com. The Contoso.com network consists of a single domain
named Contoso.com. All servers on the Contoso.com network have Windows Server 2008 R2
installed. Some of Contoso.com’s workstations have Windows 7 installed, while the rest have
Windows 8 installed.
After installing a new Windows Server 2012 computer in the Contoso.com domain, you configure it
to run the File and Storage Services server role. You are instructed to create a shared folder on the
new server, and configure the use of Previous Versions for restoring files located in the shared
folder.
Which of the following actions should you take?
Which tool should you use?
Your network contains an active directory domain named contoso.com. The domain contains a
domain controller named DCS. DCS has a server core installation of windows server 2012. You need
to uninstall Active Directory from DCS manually. Which tool should you use?
You need to identify the following: -The sessions that wait for a resource -The resource needed -The sessions
You troubleshoot a SQL Server 2008 instance.
You suspect that an application uses an inefficient locking strategy and causes concurrency
problems.
You need to identify the following:
-The sessions that wait for a resource -The resource needed -The sessions that block the
resource
Which dynamic management view should you use?
Which four Transact-SQL statements should you use?
DRAG DROP
You administer a Microsoft SQL Server 2008 database for an order-processing application.
The following Transact-SQL statements have been run against the database: You need to
ensure that members of the reporting group can use only up to 35 percent of the CPU and
up to 45 percent of the available RAM.
Which four Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the
correct order.)
Which cmdlet should you run first?
You have a file server named Server1 that runs Windows Server 2012 R2. Server1 has following
hardware configurations:
– 16GB of RAM
– A single quad-core CPU
– Three network teams that have two network adapters each
You add additional CPUs and RAM to Server 1.
You repurpose Server1 as a virtualization host. You install the Hyper-V server role on Server1. You
need to create four external virtual switches in Hyper-V. Which cmdlet should you run first?
Which tool should you use?
Your network contains an Active Directory domain named contoso.com. The domain contains two
servers named Server1 and Server2 that run Windows Server 2012 R2.
You create a security template named Template1 by using the Security Templates snap-in.
You need to apply Template1 to Server2.
Which tool should you use?
How should you configure Service1?
Your network contains an Active Directory domain named contoso.com. The domain contains a
server named Server 2012. You create a group Managed Service Account named gservice1. You need
to configure a service named Service1 to run as the gservice1 account. How should you configure
Service1?
Which TransactSQL statement should you use?
Your company manufactures and distributes bicycle parts. You have a fulltext
catalog on the
Inventory table which contains the PartName and Description columns. You also use a fulltext
thesaurus
to expand common bicycle terms. You need to write a fulltext
query that will not only match the exact
word in the search, but also the meaning.
Which TransactSQL
statement should you use?
Which two actions should you perform?
You administer a SQL Server 2008 instance that contains a very large database named
FinanceDB.
You plan to create a maintenance plan that meets the following objectives for the FinanceDB
database:
-It executes the DBCC CHECKDB statement. -It rebuilds all the indexes. -It updates all index
statistics.
You need to ensure that the maintenance plan is executed in the minimum amount of time.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)
You need to ensure that when you right-click Server1, you see the option to run the DHCP console
Your network contains an Active Directory domain named adatum.com. The domain contains a
member server named Server1 and a domain controller named DC2. All servers run Windows Server
2012 R2. On DC2, you open Server Manager and you add Server1 as another server to manage. From
Server Manager on DC2, you right-click Server1 as shown in the exhibit. You need to ensure that
when you right-click Server1, you see the option to run the DHCP console.
What should you do?
