You need to ensure that the following data export requirements are met: A Microsoft Office Open XML document f
You administer a SQL Server 2008 instance that contains a database named
AdventureWorks.
The AdventureWorks database contains a table named OrderDetail. You plan to export all
data from this table to a file.
You need to ensure that the following data export requirements are met:
A Microsoft Office Open XML document format is used The data export process is saved for
reuse.
What should you do?
What should you create?
You have a server named Server1 that runs Windows Server 2012 R2.
You connect three new hard disks to Server1.
You need to create a storage space that contains the three disks.
The solution must meet the following requirements:
Provide fault tolerance if a single disk fails.
Maximize the amount of files that can be stored in the storage space.
What should you create?
You need to ensure that the client computers locate the ISATAP router
Your network contains an Active Directory domain named contoso.com. All servers run Windows
Server 2012 R2.Client computers run either Windows 7 or Windows 8.
All of the computer accounts of the client computers reside in an organizational unit (OU) named
Clients. A Group Policy object (GPO) named GPO1 is linked to the Clients OU. All of the client
computers use a DNS server named Server1.
You configure a server named Server2 as an ISATAP router. You add a host (A) record for ISATAP to
the contoso.com DNS zone.
You need to ensure that the client computers locate the ISATAP router.
What should you do?
Which query should you use?
Your database contains sales information for millions of orders.
You need to identify the orders with the highest average unit price and an order total greater than
10,000.
The list should contain no more than 20 orders.
Which query should you use?
How many IPv6 subnets should you identify?
You are configuring the IPv6 network infrastructure for a branch office.
The corporate network administrator allocates the 2001:DB8:0:C000::/58 address space for use in
the branch office.
You need to identify the maximum number of IPv6 subnets you can create.
How many IPv6 subnets should you identify?
You need to ensure that the current state of VM1 is contained in a single virtual hard disk file
Your network contains a Hyper-V host named Server1 that runs Windows Server 2012 R2.
Server1 hosts a virtual machine named VM1 that runs Windows Server 2012 R2.
You create a checkpoint of VM1, and then you install an application on VM1. You verify that the
application runs properly.
You need to ensure that the current state of VM1 is contained in a single virtual hard disk file.
The solution must minimize the amount of downtime on VM1.
What should you do?
You need to add a new partition that contains integer values greater than 200.000
You administer a SQL Server 2008 instance that contains a database named
AdventureWorks. The AdventureWorks database contains the OrderHistory table. The
OrderHistory table is partitioned on the OrderId column. The first partition contains integer
values between 1 and
100.000. The second partition contains integer values greater than 100.000. You need to
add a new partition that contains integer values greater than 200.000. What should you do?
Which two actions should you perform?
Your network contains an Active Directory domain named contoso.com. The domain contains a
server named Server1 that runs Windows Server 2012 R2.Server1 has the Hyper-V server role
installed. Server1 has a virtual switch named RDS Virtual.
You replace all of the network adapters on Server1 with new network adapters that support singleroot I/O visualization (SR-IOV).
You need to enable SR-IOV for all of the virtual machines on Server1.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose
two.)
which group should you add User1?
Your network contains an Active Directory domain named contoso.com. The domain contains a
server named Server1 that runs Windows Server 2012 R2.Server1 contains a virtual machine named
VM1 that runs Windows Server 2012 R2.
You need to ensure that a user named User1 can install Windows features on VM1. The solution
must minimize the number of permissions assigned to User1.
To which group should you add User1?
You need to resolve the issue that causes VM1 to shut down every 60 minutes
You have a Hyper-V host named Server1 that runs Windows Server 2012 R2 Datacenter.Server1 is
located in an isolated network that cannot access the Internet.
On Server1, you install a new virtual machine named VM1.VM1 runs Windows Server 2012 R2
Essentials and connects to a private virtual network.
After 30 days, you discover that VM1 shuts down every 60 minutes.
You need to resolve the issue that causes VM1 to shut down every 60 minutes.
What should you do?