You need to ensure that the indexes which include the CompanyName column are case-sensitive
You administer a SQL Server 2008 instance that contains a database named Sales. The
Sales database contains a table named Customers that has a column named
CompanyName.
The current database collation is SQL_Latin1_General_Cp1_CI_AS. You need to ensure
that the indexes which include the CompanyName column are case-sensitive.
You also need to ensure that other case-insensitive queries are unaffected.
What should you do?
You need to configure Active Directory replication between Site1 and Site2
You have an existing Active Directory site named Site1. You create a new Active Directory site and
name it Site2. You need to configure Active Directory replication between Site1 and Site2. You install
a new domain controller.
You create the site link between Site1 and Site2.
What should you do next?
What should be the next step?
You are configuring Service Broker to process messages within a single database. You have
performed the following steps.
1. CREATE MESSAGE TYPE
2. CREATE CONTRACT
3. CREATE QUEUE
You need to complete the Service Broker configuration. What should be the next step?
You need to list the account names
Catalog Servers. Your domain structure contains one root domain and one child domain. You modify
the folder permissions on a file server that is in the child domain. You discover that some Access
Control entries start with S-1-5-21 and that no account name is listed.
You need to list the account names. What should you do?
You need to access the Active Directory Schema snap-in
Your company has an Active Directory domain. You log on to the domain controller. The Active
Directory Schema snap-in is not available in the Microsoft Management Console (MMC).
You need to access the Active Directory Schema snap-in. What should you do?
You need to reduce how long it takes until stale records are deleted from the zone
Your network contains a domain controller that is configured as a DNS server. The server hosts an
Active Directory-integrated zone for the domain.
You need to reduce how long it takes until stale records are deleted from the zone. What should you
do?
You need to protect the customer data such that data files, log files, and subsequent backups are as secure as
You maintain a SQL Server 2008 instance that contains a database named CustomerDB.
The CustomerDB database stores customer data for the company. The customers use a
Web application to access their profile data.
You need to protect the customer data such that data files, log files, and subsequent
backups are as secure as possible even if the backup media is lost. You want to achieve this
goal without affecting the Web application.
What should you do?
You need to ensure that the stale resource records are automatically removed from the contoso.com zone
You have an Active Directory domain named contoso.com. You have a domain controller named
Server1 that is configured as a DNS server. Server1 hosts a standard primary zone for contoso.com.
The DNS configuration of Server1 is shown in the exhibit.
You discover that stale resource records are not automatically removed from the contoso.com zone.
You need to ensure that the stale resource records are automatically removed from the
contoso.com zone.
What should you do?
What should you create?
You have a server that runs Windows Server 2012 R2. The server contains the disks configured as
shown in the following table.
You need to create a volume that can store up to 3 TB of user files. The solution must ensure that
the user files are available if one of the disks in the volume fails. What should you create?
Which TransactSQL statement should you use?
You have a database named Contoso. The Contoso database has a Service Broker queue named
VacationRequestQueue.
The Contoso database has been restored to a new server. Since restoring the database, Service
Broker
is no longer able to send new messages.
You need to configure Service Broker in order to resolve the issue.
Which TransactSQL
statement should you use?