What task types are included in a SQL Maintenance Plan?
You administer a Microsoft SQL Server 2008 R2 database instance.
You plan to automate maintenance tasks.
What task types are included in a SQL Maintenance Plan? (Choose all that apply.)
Which TransactSQL statement should you use?
Click the Exhibit button.
You have the following XML:
<Site URL=”http://www.contoso.com/index.htm”>
<Site URL=”http://www.contoso.com/finance/index.htm”>
<Site URL=”http://www.contoso.com/finance/reports/index.htm” />
<Site URL=”http://www.contoso.com/finance/main/index.htm” />
</Site>
<Site URL=”http://www.contoso.com/marketing/index.htm”>
<Site URL=”http://www.contoso.com/marketing/reports/index.htm” />
<Site URL=”http://www.contoso.com/marketing/main/index.htm” />
</Site>
<Site URL=”http://www.contoso.com/sales/index.htm” />
</Site>
You are tasked to query the sites listed in the XML by using OPENXML. The results will have two
columns,
ParentSiteURL and SiteURL. The ParentSiteURL column should contain the URL attribute of the
parent
site. The SiteURL column should contain the URL attribute of the site itself.
The output should look like that in the exhibit.
You need to write the OPENXML query.
Which TransactSQL
statement should you use?
Which of the following actions should you take?
You work as an administrator at ABC.com. The ABC.com network consists of a single domain named
ABC.com. All servers in the ABC.com domain, including domain controllers, have Windows Server
2012 R2 installed.
You have installed the DNS Server Role on an ABC.com server, named ABC-SR13. ABC.com’s
workstations make use of a web proxy to access the Internet, and refer to ABC-SR13 as a primary
DNS server.
You have been instructed to make sure that Internet host names for ABC.com’s workstations are not
resolved by ABC-SR13.
Which of the following actions should you take?
Note: Other config such as ip address should not be changed.
You run a Windows Server 2012 R2, what is the PowerShell command to set preferred dns server.
Note: Other config such as ip address should not be changed.
Which installation option is required for these servers?
A company’s server deployment team needs to install fourteen Windows Server 2012 R2 to handle
the expected increase in holiday traffic. The team would like the option of switching the servers
between Server Core and Full GUI servers and do not want to be locked in to their first choice.
The server team would like four of the servers to include the Windows 8 Shell.
Which installation option is required for these servers?
You need to ensure that the reports generated by the application using the InsightDB database return current i
You administer a SQL Server 2008 instance that contains a database named InsightDB.
The InsightDB database is used by an application that is continuously connected.
The application uses the INSERT command extensively. The application uses triggers to
populate multiple tables.
You need to ensure that the reports generated by the application using the InsightDB
database return current information with minimal negative effects on the application inserts.
What should you do?
Which of the following should the administrator configure on the Windows Server 2012 R2 DHCP server?
A company’s network administrator needs to ensure a specific IP address is never assigned by a
Windows Server 2012 R2 DHCP server to any device connecting to the network.
Which of the following should the administrator configure on the Windows Server 2012 R2 DHCP
server?
Which of the following Windows Server versions can be used as guest operating systems when using Hyper-V Fibre
A company’s server virtualization team needs to provision a series of Hyper-V workloads to use
existing network storage arrays. The team has chosen to use Fibre Channel ports within the guest
operating systems.
Which of the following Windows Server versions can be used as guest operating systems when using
Hyper-V Fibre Channel ports?
Which Windows PowerShell module includes the command-line options for installing domain controllers?
A company’s server deployment team needs to introduce many new Windows Server 2012 R2
domain controllers throughout the network into a single Windows Server 2008 R2 domain. The team
has chosen to use Windows PowerShell.
Which Windows PowerShell module includes the command-line options for installing domain
controllers?
Which TransactSQL statement should you use?
Your company uses an application that passes XML to the database server by using stored
procedures.
The database server has a large number of XML handles that are currently active. You determine
that the
XML is not being flushed from SQL Server memory.
You need to identify the system stored procedure to flush the XML from memory.
Which TransactSQL
statement should you use?