Which view should you create for Region1?
You manage a SQL Server 2008 database that is located at your company’s corporate headquarters.
The database contains a table named dbo.Sales. You need to create different views of the dbo.Sales
table that will be used by each region to insert, update, and delete rows. Each regional office must
only be able to insert, update, and delete rows for their respective region.
Which view should you create for Region1?
Does this meet the goal?
Your network contains an Active Directory domain named contoso.com. The domain
contains multiple sites.
You plan to deploy DirectAccess.
The network security policy states that when client computers connect to the corporate
network from the Internet, all of the traffic destined for the Internet must be routed through
the corporate network.
You need to recommend a solution for the planned DirectAccess deployment that meets the
security policy requirement.
Solution: You enable split tunneling.
Does this meet the goal?
You need to restore the Finance database from the database backups by ensuring minimal data loss in minimum po
You maintain a SQL Server 2008 instance that contains a database named Finance. The
recovery model of the Finance database is set to Full.
The backup strategy for the Finance database is as shown in the following table.
The system databases, user database data, and log files are stored on separate disks. The
hard disks that contain the user database data files are reported to have failed at 15:00
hours on Wednesday.
You need to restore the Finance database from the database backups by ensuring minimal
data loss in minimum possible time.
What should you do?
Does this meet the goal?
Your network contains an Active Directory domain named contoso.com. The domain
contains three VLANs. The VLANs are configured as shown in the following table.
All client computers run either Windows 7 or Windows 8.
Goal: You need to implement a solution to ensure that only the client computers that have all
of the required security updates installed can connect to VLAN 1. The solution must ensure
that all other client computers connect to VLAN 3.
Solution: You implement the 802.1x Network Access Protection (NAP) enforcement method.
Does this meet the goal?
Does this meet the goal?
Your network contains an Active Directory domain named contoso.com. The domain
contains three VLANs. The VLANs are configured as shown in the following table.
All client computers run either Windows 7 or Windows 8.
The corporate security policy states that all of the client computers must have the latest
security updates installed.
You need to implement a solution to ensure that only the client computers that have all of the
required security updates installed can connect to VLAN 1. The solution must ensure that all
other client computers connect to VLAN 3.
Solution: You implement the VPN enforcement method.
Does this meet the goal?
Which index should you create?
You administer a SQL Server 2008 database that contains a table name dbo.Sales, which contains the
following table definition:
CREATE TABLE [dbo].[Sales](
[SalesID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
[OrderDate] [datetime] NOT NULL,
[CustomerID] [int] NOT NULL,
[SalesPersonID] [int] NULL,
[CommentDate] [date] NULL);
This table contains millions of orders. You run the following query to determine when sales persons
comment in the dbo.Sales table:
SELECT SalesID,CustomerID,SalesPersonID,CommentDate
FROM dbo.Sales
WHERE CommentDate IS NOT NULL
AND SalesPersonID IS NOT NULL;
You discover that this query runs slow. After examining the data, you find only 1% of rows have
comment
dates and the SalesPersonID is null on 10% of the rows. You need to create an index to optimize the
query. The index must conserve disk space while optimizing your query.
Which index should you create?
You need to restore the database by ensuring minimal data loss in minimum possible time
You maintain a SQL Server 2008 instance that contains a database named Finance.
The Finance database contains the following filegroups:
The PRIMARY filegroup that contains the On-Line Transaction Processing (OLTP) data
stored in the F: volume.
A filegroup named Histoiy that contains historical data stored in the G: volume.
The transaction log of the database is stored in the H: volume.
As part of the archiving strategy for the Finance database, data is frequently moved from the
PRIMARY filegroup to the History filegroup.
The backup strategy for the Finance database consists of the following requirements:
Backing up the PRIMARY filegroup five times a day
Backing up the History filegroup at the end of each working day
Backing up the transaction log every 15 minutes
At 13:00 hours, the volume that contains the History filegroup fails.
You need to restore the database by ensuring minimal data loss in minimum possible time.
What should you do?
Does this meet the goal?
Your network contains an Active Directory domain named contoso.com. The domain
contains three VLANs. The VLANs are configured as shown in the following table.
All client computers run either Windows 7 or Windows 8.
The corporate security policy states that all of the client computers must have the latest
security updates installed.
You need to implement a solution to ensure that only the client computers that have all of the
required security updates installed can connect to VLAN 1. The solution must ensure that all
other client computers connect to VLAN 3.
Solution: You implement the DHCP Network Access Protection (NAP) enforcement method.
Does this meet the goal?
You need to ensure that only compliant client computers can access network resources through the new switch
Your network contains a server named Server1 that runs Windows Server 2012. Server1
has the Network Policy Server server role installed.
You configure Server1 as part of a Network Access Protection (NAP) solution that uses the
802.lx enforcement method,
You add a new switch to the network and you configure the switch to use 802.lx
authentication.
You need to ensure that only compliant client computers can access network resources
through the new switch.
What should you do on Server1?
What solution should you include in the recommendation?
Your network contains an Active Directory domain named contoso.com.
Your company has 100 users in the sales department. Each sales user has a domain-joined
laptop computer that runs either Windows 7 or Windows 8. The sales users rarely travel to
the company’s offices to connect directly to the corporate network.
You need to recommend a solution to ensure that you can manage the sales users’ laptop
computers when the users are working remotely.
What solution should you include in the recommendation?