You need to modify the ON clause of the query to successfully perform a case-sensitive join
You administer a SQL Server 2008 instance.
You join two tables on a column named CompanyName by using the following query:
SELECT s.*,i.*
FROM SensitiveTb1 AS s
INNER JOIN Insensitive Tb1 AS iON i. CompanyName = s.CompanyName
When you execute the query, the following error is returned:
“Msg 468, Level 16, State 9, Line 17
Cannot resolve the collation conflict between ,SQL_Latinl_General_CPl_CS_AS’ and
‘SQL_Latin1_General_CP1_CI_AS’ in the equal to operation.”
You need to modify the ON clause of the query to successfully perform a case-sensitive join.
What should you do?
You need to ensure that Server2 can be managed by using Server Manager from Server1
HOTSPOT
You have two servers that run Windows Server 2012 R2. The servers are configured as shown in the
following table.
You need to ensure that Server2 can be managed by using Server Manager from Server1.
In the table below, identify which actions must be performed on Server1 and Server2.Make only one
selection in each row. Each correct selection is worth one point.
You need to provide a group named Group1 with the ability to manage Printer1
Your network contains an Active Directory domain named contoso.com. The domain contains a
server named Server1. Server1 runs Windows Server 2012 R2.
On Server1, you create a printer named Printer1. You share Printer1 and publish Printer1 in Active
Directory.
You need to provide a group named Group1 with the ability to manage Printer1.
What should you do?
You need to ensure that only the members of the Server Operators group, the Administrators group, and the Prin
You have a server named Print1 that runs Windows Server 2012 R2.
On Print1, you share a printer named Printer1.
You need to ensure that only the members of the Server Operators group, the Administrators group,
and the Print Operators group can send print jobs to Printer1.
What should you do?
You need to improve the query performance by ensuring that the effect on the disk space is minimized
You administer a SQL Server 2008 instance that contains a database named Sales. The
Sales database has a table named Products that stores information about all types of
products. Users frequently query the Products table based on the TelevisionSize column.
The TelevisionSize column has the NULL value for all products other than Televisions.
There is currently no index on the TelevisionSize column. You need to improve the query
performance by ensuring that the effect on the disk space is minimized. What should you
do?
You need to ensure that you can enable NTFS disk quotas for volume D
You have a server named Server1 that runs Windows Server 2012 R2.
A network technician installs a new disk on Server1 and creates a new volume. The properties of the
new volume are shown in the exhibit. (Click the Exhibit button.)
You need to ensure that you can enable NTFS disk quotas for volume D.
What should you do first?
Which query should you use?
You have a database that contains two tables named ProductCategory and ProductSubCategory.
You need to write a query that returns a list of product categories that contain more than ten
subcategories.
Which query should you use?
What should you identify?
HOTSPOT
You have a file server named Server1 that runs Windows Server 2012 R2. Server1 contains a folder
named Folder1.
A user named User1 is a member of Group1 and Group2. A user named User2 is a member of
Group2 and Group3.
You need to identify which actions the users can perform when they access the files in Share1.
What should you identify?
To answer, select the appropriate actions for each user in the answer area.
You need to ensure that you can manage Server2 by using the Computer Management console on Server1
Your network contains an Active Directory domain named contoso.com. The domain contains a
server named Server1 that runs Windows Server 2012 R2.
On a server named Server2, you perform a Server Core Installation of Windows Server 2012 R2. You
join Server2 to the contoso.com domain.
You need to ensure that you can manage Server2 by using the Computer Management console on
Server1.
What should you do on Server2?
Which actions should you perform on each server? To answer, select the appropriate server on which to perform
HOTSPOT
Your network contains an Active Directory domain named contoso.com. The domain contains
servers named Server1 and Server2 that run Windows Server 2012 R2.
You create a windows PowerShell script named Scriptl.psl that contains the following configuration:
You need to apply the configuration to Server1. The solution must ensure that the configuration on
Server1 can be updated by modifying a MOF file on Server2.
Which actions should you perform on each server?
To answer, select the appropriate server on which to perform each action in the answer area.
