Which utility should you use?
You administer a SQL Server 2008 instance.
You use the SQL Server Import and Export Wizard to export data from SQL Server to a
Microsoft Excel file.
You save the package definition to a file.
You need to reexecute the package from the command line.
Which utility should you use?
What should you include in the recommendation?
Your company has two main offices and 10 branch offices. Each office is configured as a
separate Active Directory site.
The main offices sites are named Site1 and Site2. Each office connects to Site1 and Site2
by using a WAN link. Each site contains a domain controller that runs Windows Server 2008.
You are redesigning the Active Directory infrastructure.
You plan to implement domain controllers that run Windows Server 2012 and decommission
all of the domain controllers that run Windows Server 2008.
You need to recommend a placement plan for the Windows Server 2012 domain controllers
to meet the following requirements:
Ensure that users can log on to the domain if a domain controller or a WAN link fails.
Minimize the number of domain controllers implemented.
What should you include in the recommendation? (Each correct answer presents part of the
solution. Choose all that apply.)
You need to implement appropriate permissions for John and the stored procedure Marketing.GetSalesSummary
You have a SQL Server database. The database contains two schemas named Marketing and Sales.
The Marketing schema is owned by a user named MarketingManager. The Sales schema is owned by
a user named SalesManager.
A user named John must be able to access the Sales.Orders table by using a stored procedure named
Marketing.GetSalesSummary. John is not granted a SELECT permission on the Sales.Orders table. A
user named SalesUser does have SELECT permission on the Sales.Orders table. You need to
implement
appropriate permissions for John and the stored procedure Marketing.GetSalesSummary.
What should you do?
What should you include in the recommendation?
Your network contains a Hyper-V host named Host1 that runs Windows Server 2012. Host1
contains a virtual machine named DC1. DC1 is a domain controller that runs Windows
Server 2012.
You plan to clone DC1.
You need to recommend which steps are required to prepare DC1 to be cloned.
What should you include in the recommendation? (Each correct answer presents part of the
solution. Choose all that apply.)
You need to ensure that the process can be repeated at the end of every month
You maintain a SQL Server 2008 instance that contains a database named
AdventureWorks. The AdventureWorks database contains two tables as shown in the
following table:
The OrderHistory table contains two table partitions: one partition contains all data and the
other partition is empty.
You plan to develop a process to move data from the partition that contains data for the
oldest month of the Orders table to the appropriate partition of the OrderHistory table.
You need to ensure that the process can be repeated at the end of every month.
What should you do?
What should you recommend?
A new company registers the domain name of contoso.com. The company has a web
presence on the Internet. All Internet resources have names that use a DNS suffix of
contoso.com.
A third-party hosts the Internet resources and is responsible for managing the contoso.com
DNS zone on the Internet. The zone contains several hundred records.
The company plans to deploy an Active Directory forest.
You need to recommend an Active Directory forest infrastructure to meet the following
requirements:
Ensure that users on the internal network can resolve the names of the company’s Internet
resources.
Minimize the amount of administrative effort associated with the addition of new Internet
servers.
What should you recommend?
You run the ldifde command and receive the following output:
What should you include in the recommendation?
Your network contains an Active Directory domain named contoso.com. The functional level
of the domain and the forest is Windows Server 2008 R2.
All domain controllers run Windows Server 2008 R2.
You plan to deploy a new line-of-business application named App1 that uses claims-based
authentication.
You need to recommend changes to the network to ensure that Active Directory can provide
claims for App1.
What should you include in the recommendation? (Each correct answer presents part of the
solution. Choose all that apply.)
Which is the correct answer?
You are mastering the company database, with SQL Server 2008 computer named
SQLTEST1The master database on SQLTEST1 is down. Some SQL Server Agent jobs
should be included in the SQLTEST1.The whole database should be backed up every day.
You rebuild and restore the master database. You should make sure that SQLTEST1
functions as it did before the database lost. Which is the correct answer?
Which code segment should you use?
You need to create a stored procedure that accepts a tablevalued
parameter named @Customers.
Which code segment should you use?