Which Resource Governor component should you configure?
You administer a SQL Server 2008 instance. The instance contains databases for a finance
application and a manufacturing application. You configure the Resource Governor to limit
the maximum CPU query time allowed by the applications. The administrator of the
manufacturing application reports that certain reports no longer execute successfully. You
need to modify the Resource Governor configuration to allow the manufacturing application
to consume more CPU time.
Which Resource Governor component should you configure?
Which object should you use?
You need to identify, within a given clause, if the month of February will contain 29 days for a
specified
year. Which object should you use?
You need to prevent User1 from receiving the error message when editing DHCP scopes by using IPAM
Your network contains an Active Directory domain named contoso.com. All servers run
either Windows Server 2008 R2 or Windows Server 2012.
Your company uses IP Address Management (IPAM) to manage multiple DHCP servers.
A user named User1 is a member of the IPAM Users group and is a member of the local
Administrators group on each DHCP server.
When User1 edits a DHCP scope by using IPAM, the user receives the error message
shown in the exhibit. (Click the Exhibit button.)
You need to prevent User1 from receiving the error message when editing DHCP scopes by
using IPAM.
What should you do?
What should you include in the recommendation?
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.
What should you include in the recommendation?
Which dynamic management view should you use?
You troubleshoot the performance of a SQL Server 2008 instance.
You need to identify the longest-running common language runtime (CLR) queries.
Which dynamic management view should you use?
What should you recommend?
Your company has a main office.
The network contains an Active Directory domain named contoso.com. The main office
contains a server named Server1 that runs Windows Server 2012. Server1 has the Remote
Access server role installed and is configured to accept incoming SSTP-based VPN
connections.
All client computers run Windows 7.
The company plans to open a temporary office that will contain a server named Server2 that
runs
Windows Server 2012 and has the DHCP Server server role installed. The office will also
have 50 client computers and an Internet connection.
You need to recommend a solution to provide the users in the temporary office with access
to the resources in the main office.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
Which option should you use when you create the function?
You are creating a function that references a table.
You need to prevent the table from being dropped.
Which option should you use when you create the function?
What should you include in the recommendation?
Your network contains multiple servers that run Windows Server 2012. All client computers
run Windows 8.
You need to recommend a centralized solution to download the latest antivirus definitions for
Windows Defender.
What should you include in the recommendation?
Which is the correct answer?
You are mastering the company database; a new SQL Server 2008 computer named
TesterDB should be set by yourself. Reporting Services will work in TesterDB. It should be
set to run database backups and other maintenance job automatically. In the network
environment, the company has no other SQL Server computers. The whole approach SQL2
will be made by using SQL1s DNS name. You should enable any necessary devices on
SQL2. Which is the correct answer?(select more than one)
Which Network Access Protection (NAP) enforcement method should you implement?
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.
Which Network Access Protection (NAP) enforcement method should you implement?