what should you do?
You are the administrator of your company network. You are in charge of three SQL Server 2008 instances named Instance1, Instance2, and Instance3. Each of them runs on a separate server.
Between Instance1 and Instance2, a mission-critical database is mirrored. At present Instance1 currently acts as the Principal, while Instance3 acts as the witness. You intend to apply a patch on both servers. The server needs to restart itself. You have to identify the sequence of steps necessary to ensure that the patching process is completed with the minimum time and the database is online on the partner that currently does not apply the patch. Besides this two, you have to ensure that the database does not failover to the other partner during this time.So what should you do?
which will be used for encryption. So what should you do?
You are the administrator of your company network. You’re in charge of a SQL Server 2008 cluster in a high security environment. Now you intend to configure and use encrypted connections for the clustered virtual SQL Server. You have to install the certificate which will be used for encryption. So what should you do?
what should you do?
You are the administrator of your company network. You have to install a SQL Server 2008 instance for a new application on an existing server. The server contains a default SQL Server 2005 instance. You must make sure that certified third-party applications have access to their respective database instances. You have to ensure that when you take measures to achieve this, the existing application environments will not be changed, and you should use as little database administrative effort as possible. So what should you do?
which tool should you use to achieve this?
You are the administrator of your company network. Now you’re in charge of a SQL Server 2008 instance.
A user called Jack is running a query and he reports that he is waiting for it to complete. So you have to identify whether the query is blocked. So which tool should you use to achieve this?
What should you do?
Your network contains a server named Server1 that runs Windows Server 2008 R2. The network contains multiple subnets.
An administrator reports that Server1 fails to communicate with computers on remote subnets. You run route.exe print on Server1 as shown in the exhibit. (Click the Exhibit button.)
You need to ensure that Server1 can communicate with all computers on the network.
What should you do?
What should you do?
Your network contains two servers named Server1 and Server2 that run Windows Server 2008 R2. From Server1, you create a collector-initiated subscription that uses Server2 as a source computer. You verify the event subscription and discover the error message shown in the exhibit. (Click the Exhibit button.)
You need to ensure that the subscription collection runs successfully.
What should you do?
What should you do?
You have an Active Directory domain named contoso.com. You have a domain controller named Server1 that is configured as a DNS server. Server1 hosts a standard primary zone for contoso.com. The DNS configuration of Server1 is shown in the exhibit. (Click the Exhibit button.)
You discover that stale resource records are not automatically removed from the contoso.com zone. You need to ensure that the stale resource records are automatically removed from the contoso.com zone.
What should you do?
Which two actions should you perform?
Your company has an Active Directory forest that runs at the functional level of Windows Server 2008.
You implement Active Directory Rights Management Services (AD?RMS). You install Microsoft SQL Server 2005.
When you attempt to open the AD?RMS administration Web site, you receive the following error message: "SQL Server does not exist or access denied." You need to open the AD?RMS administration Web site. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
What should you do?
Your company has two Active Directory forests as shown in the following table.
Forest name Forest functional level Domain(s)
contoso.com Windows Server 2008 contoso.com
fabrikam.com Windows Server 2008 fabrikam.com eng.fabrikam.com The forests are connected by using a two-way forest trust. Each trust direction is configured with forest-wide authentication. The new security policy of the company prohibits users from the eng.fabrikam.com domain to access resources in the contoso.com domain. You need to configure the forest trust to meet the new security policy requirement.
What should you do?
What should you do?
Your company has an Active Directory domain named contoso.com. The company network has two DNS servers named DNS1 and DNS2.
The DNS servers are configured as shown in the following table.
DNS1 DNS2
.(root)
_msdcs.contoso.com
_msdcs.contoso.com
contoso.com
contoso.com
Domain users, who are configured to use DNS2 as the preferred DNS server, are unable to connect to Internet Web sites.
You need to enable Internet name resolution for all client computers.
What should you do?