PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

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?

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?

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?