You need to ensure that the new columns do not break the thirdparty application
You have a thirdparty
application that inserts data directly into a table.
You add two new columns to the table. These columns cannot accept NULL values and cannot use
default constraints.
You need to ensure that the new columns do not break the thirdparty
application.
What should you do?
What should you recommend?
Your network contains an Active Directory domain named contoso.com. The Active Directory
site topology is configured as shown in the exhibit. (Click the Exhibit button.)
DC1 and DC2 run Windows Server 2003 R2. All FSMO roles are located on DC2.
You plan to deploy a read-only domain controller (RODC) to Site3.
You need to recommend changes to the network to support the planned RODC
implementation.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
You need to analyze the workload of the remote SQL Server instance on a local SQL Server instance by using the
You administer a remote SQL Server 2008 instance. Users report that the performance of
the application is poor.
You use SQL Profiler to capture a workload of the remote instance to a trace table on the
remote SQL Server instance.
You need to analyze the workload of the remote SQL Server instance on a local SQL Server
instance by using the Database Engine Tuning Advisor.
What should you do?
What should you recommend?
Your network contains an Active Directory domain named contoso.com.
Your company plans to open a branch office. The branch office will have 10 client computers
that run Windows 8 and at least one server that runs Windows Server 2012. The server will
host
BranchCache files and manage print queues for the network print devices in the branch
office.
You need to recommend a solution to ensure that the users in the branch office can print if
the branch office server fails.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
You need to implement a solution to reduce the amount of bandwidth used by the client computers in the branch
Your company has a main office that contains several servers and several users. The main
office contains a file server named Server1 that runs Windows Server 2012.
The users access a large report file that is created on Server1 each day.
The company plans to open a new branch office. The branch office will contain only client
computers.
You need to implement a solution to reduce the amount of bandwidth used by the client
computers in the branch office to download the report each day.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.
What data collection process should you implement?
You manage a SQL Server 2008 instance. You plan to maintain a management data
warehouse that collects performance data by using the data collector.
You need to implement a process that routinely gathers and uploads data in the
management data warehouse on different schedules.
What data collection process should you implement?
Which computers should you identify?
Your network contains an Active Directory domain named contoso.com. The domain
contains four computers that are configured as shown in the following table.
You plan to use domain controller cloning.
You need to identify on which computers you can clone domain controllers that run Windows
Server 2012.
Which computers should you identify? (Each correct answer presents part of the solution.
Choose all that apply.)
Which TransactSQL statement should you use?
Your database contains two tables named Order and OrderDetails that store order information. They
relate to each other using the OrderID column in each table. Your business requires that the
LastModifiedDate column in the Order table must reflect the date and time when a change is made
in the OrderDetails table for the related order.
You need to create a trigger to implement this business requirement.
Which TransactSQL statement should you use?
What should you recommend?
Your company has two divisions named Division1 and Division2.
The network contains an Active Directory domain named contoso.com. The domain contains
two child domains named divisionl.contoso.com and division2.contoso.com.
The company sells Division1 to another company.
You need to prevent administrators in contoso.com and division2.contoso.com from gaining
administrative access to the resources in divisionl.contoso.com.
What should you recommend?
Which SQL Server database engine subdirectory should you back up?
You maintain a SQL Server 2008 instance. Your failure recovery plan requires you to back
up the default trace.
You need to backup the subdirectory that contains the default trace.
Which SQL Server database engine subdirectory should you back up?