You need to ensure that the RODC is configured to meet the following requirements: Cache passwords for all of
Your company has a main office and a branch office.
The network contains an Active Directory domain named contoso.com. The domain contains
three domain controllers. The domain controllers are configured as shown in the following
table.
The domain contains two global groups. The groups are configured as shown in the
following table.
You need to ensure that the RODC is configured to meet the following requirements:
Cache passwords for all of the members of Branch1Users.
Prevent the caching of passwords for the members of Helpdesk.
What should you do?
Which TransactSQL statement should you use?
You have a SQL Server 2008 database named Contoso with a table named Invoice. The primary key
of
the table is InvoiceId, and it is populated by using the identity property. The Invoice table is related
to the InvoiceLineItem table. You remove all constraints from the Invoice table during a data load to
increase load speed. You notice that while the constraints were removed, a row with InvoiceId = 10
was removed from the database. You need to reinsert
the row into the Invoice table with the same InvoiceId value.
Which TransactSQL statement should you use?
You need to ensure that the CountryCode attribute is replicated to the global catalog
Your network contains an Active Directory forest named contoso.com. The forest contains
five domains. You need to ensure that the CountryCode attribute is replicated to the global
catalog.
What should you do?
You need to ensure that this company policy is enforced
You are a database administrator for your company. The company uses a SQL Server 2008
database that includes a table named Inventory.
The table contains a column named Price. A company policy states that the value in the
Price column cannot be decreased by more than 10 percent in any single database
operation.
Updates to the Price column are made by various means, including by using ad hoc queries.
You need to ensure that this company policy is enforced. What should you do?
What should you recommend?
Your company has three offices. The offices are located in New York, Chicago, and Atlanta.
The network contains an Active Directory domain named contoso.com that has three Active
Directory sites named Site1, Site2,and Site3. The New York office is located in Site1. The
Chicago office is located in Site2. The Atlanta office is located in Site3. There is a local IT
staff to manage the servers in each site. The current domain controllers are configured as
shown in the following table.
The company plans to open a fourth office in Montreal that will have a corresponding Active
Directory site. Because of budget cuts, a local IT staff will not be established for the Montreal
site.
The Montreal site has the following requirements:
Users must be able to authenticate locally.
Users must not have the ability to log on to the domain controllers.
Domain account passwords must not be obtained from servers in the Montreal site.
Network bandwidth between the Montreal site and the other sites must be minimized.
Users in the Montreal office must have access to applications by using Remote Desktop
Services (RDS).
You need to recommend a solution for the servers in the Montreal site.
What should you recommend?
You need to design the Active Directory site topology to meet the following requirements:
Your network contains an Active Directory domain named contoso.com. The domain
contains three Active Directory sites. The Active Directory sites are configured as shown in
the following table.
The sites connect to each other by using the site links shown in the following table.
You need to design the Active Directory site topology to meet the following requirements:
Ensure that all replication traffic between Site2 and Site3 replicates through Site1 if a domain
controller in Site1 is available.
Ensure that the domain controllers between Site2 and Site3 can replicate if all of the domain
controllers in Site1 are unavailable.
What should you do?
What two commands should you run?
HOTSPOT
Your network contains an Active Directory forest name fabrikam.com. The forest contains
two domains named fabrikam.com and contoso.com. All servers run Windows Server 2012
R2.
The forest contains a DHCP server named Server1 and a DNS server named Server2.
You need to recommend a solution to ensure that any computers that are neither members
of contoso.com nor fabrikam.com receive a DNS suffix of guest.fabrikam.com.
What two commands should you run? To answer, select the appropriate options in the
answer area.
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 DB1. DB1 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. Your solution must not
affect the Web application or impact performance.
What should you do?
What should you recommend?
Your company has three offices. The offices are located in Montreal, Toronto, and
Vancouver.
The network contains two Active Directory forests named contoso.com and adatum.com.
The contoso.com forest contains one domain. The adatum.com forest contains two domains.
All of the servers in adatum.com are located in the Toronto office. The servers in
contoso.com are located in the Montreal and Vancouver offices. All of the servers in both of
the forests run Windows Server 2012 R2.
A two-way, forest trusts exists between the forests.
Each office contains DHCP servers and DNS servers.
You are designing an IP Address Management (IPAM) solution to manage the network.
You need to recommend a solution for the placement of IPAM servers to manage all of the
DHCP servers and all of the DNS servers in both of the forests. The solution must minimize
the number of IPAM servers deployed.
What should you recommend?
Which method should you use?
You are developing a new database. The database contains two tables named SalesOrderDetail and
Product. You need to ensure that all products referenced in the SalesOrderDetail table have a
corresponding record in the Product table.
Which method should you use?