You need to add a new partition for the upcoming year
You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems
table. The table has the following definition: Currently, the table is partitioned by year with
each year in its own filegroup.
You need to add a new partition for the upcoming year.
What should you do?
You need to ensure that when users browse the network, the Sources share is not visible
You have a server named Server2 that runs Windows Server 2012 R2. You open Server Manager on
Server2 as shown in the exhibit. (Click the Exhibit button.) The Everyone group has read share
permission and read NTFS permission to Sources.
You need to ensure that when users browse the network, the Sources share is not visible.
What should you do?
Which TransactSQL statements should you run?
You have been tasked to delete a number of Database Mail messages that have been sent.
You need to delete all the emails that were sent more than one month ago.
Which TransactSQL
statements should you run?
Which zone should you identify?
HOTSPOT
You have a DNS server named Server1. Server1 runs Windows Server 2012 R2. The network ID is
10.1.1.0/24. An administrator creates several reverse lookup zones. You need to identify which
reverse lookup zone is configured correctly. Which zone should you identify? To answer, select the
appropriate zone in the answer area.
What FSMO roles you need on to restore the access?
Your infrastructure divided in 2 sites. You have a forest root domain and child domain. There is only
one DC on site 2 with no FSMO roles. The link goes down to site 2 and no users can log on. What
FSMO roles you need on to restore the access?
Which tool should you use?
You perform a Server Core Installation of window Server 2012 R2 on server named Server1.
You need to add a graphical user interface (GUI) to server1. Which tool should you use?
You need to create a partition scheme that will place all data to the SECONDARY filegroup
You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems
table. The table has the following definition:
The following DDL has been run on the database:
CREATE PARTITION FUNCTION FUNC_FG (INT)
AS RANGE LEFT FOR VALUES (1, 100, 1000);
You need to create a partition scheme that will place all data to the SECONDARY filegroup.
What should you do?
What should you perform?
A network technician installs Windows Server 2012 R2 Standard on a server named Server1.
A corporate policy states that all servers must run Windows Server 2012 R2 Enterprise.
You need to ensure that Server1 complies with the corporate policy.
You want to achieve this goal by using the minimum amount of administrative effort.
What should you perform?
You need to ensure that the logon script in GPO1 is applied to the sales users
Your network contains an Active Directory domain named contoso.com. All user accounts in the
sales department reside in an organizational unit (OU) named OU1.
You have a Group Policy object (GPO) named GPO1. GPO1 is used to deploy a logon script to all of
the users in the sales department.
You discover that the logon script does not run when the sales users log on to their computers. You
open Group Policy Management as shown in the exhibit.
You need to ensure that the logon script in GPO1 is applied to the sales users. What should you do?
You need to identify which servers were restarted during the last two days
Your network contains an Active Directory domain named adatum.com. The domain contains several
thousand member servers that run Windows Server 2012 R2. All of the computer accounts for the
member servers are in an organizational unit (OU) named ServersAccounts. Servers are restarted
only occasionally.
You need to identify which servers were restarted during the last two days.
What should you do?