Which tool should you use to perform each task?
DRAG DROP
Your network contains an Active Directory forest. The forest contains two domains named
contoso.com and fabrikam.com.
You plan to decommission the fabrikam.com domain.
You need to perform the following migration tasks:
Copy user accounts from the fabrikam.com domain to the contoso.com domain.
Move the client computers from fabrikam.com to contoso.com.
The solution must ensure that all of the user profiles are associated to the migrated user
accounts.
Which tool should you use to perform each task?
To answer, drag the appropriate tool to the correct migration task in the answer area. Each
tool may be used once, more than once, or not at all. Additionally, you may need to drag the
split bar between panes or scroll to view content.
What should you include in the recommendation?
You are designing an Active Directory forest for a company named Contoso, Ltd. Contoso
identifies the following administration requirements for the design:
User account administration and Group Policy administration will be performed by network
technicians. The technicians will be added to a group named OUAdmins.
IT staff who are responsible for backing up servers will have user accounts that are
members of the Backup Operators group in the domain.
All user accounts will be located in an organizational unit (OU) named AllEmployees.
You run the Delegation of Control Wizard and assign the OUAdmins group full control to all
of the objects in the AllEmployeesOU.
After delegating the required permissions, you discover that the user accounts of some of
the IT staff have inconsistent permissions on the objects in AllEmployees.
You need to recommend a solution to ensure that the members of OUAdmins can manage
all of the objects in AllEmployees.
What should you include in the recommendation?
Which is the correct answer?
You are a database administrator for your company. There are four automated testing areas
for finished items in the company’s manufacturing floor. SQL Server 2008 is used to reserve
testing results for every testing area. You should create a replication method to make sure
that test results flow from the testing areas to the SQL Server quickly. The results of testing
will be used on reporting. Which is the correct answer?
Which collation should you select?
You plan to add a new column named SmallKey to the Sales.Product table that will be used in a
unique constraint. You are required to ensure that the following information is applied when adding
the
new column:
‘a1’ and ‘A1’ are treated as different values
‘a’ and ‘A’ sort before ‘b’ and ‘B’ in an ORDER BY clause
You need to select the collation that meets the requirements for the new column. Which collation
should you select?
What should you recommend?
Your network contains an Active Directory forest named contoso.com. The forest contains
one domain.
Your company plans to open a new division named Division1. A group named
Division1Admins will administer users and groups for Division1.
You identify the following requirements for Division1:
All Division1 users must have a complex password that is 14 characters.
Division1Admins must be able to manage the user accounts for Division1.
Division1Admins must be able to create groups, and then delete the groups that they create.
Division1Admins must be able to reset user passwords and force a password change at the
next logon for all Division1 users.
You need to recommend changes to the forest to support the Division1 requirements.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
What should you include in the recommendation?
Your company, which is named Contoso, Ltd., has a main office and two branch offices. The
main office is located in North America. The branch offices are located in Asia and Europe.
You plan to design an Active Directory forest and domain infrastructure.
You need to recommend an Active Directory design to meet the following requirements:
The contact information of all the users in the Europe office must not be visible to the users
in the other offices.
The administrators in each office must be able to control the user settings and the computer
settings of the users in their respective office.
The solution must use the least amount of administrative effort.
What should you include in the recommendation?
You need to provide User1 access to execute Procedure1 by allocating only the required permissions
You administer a SQL Server 2008 instance that contains a database named DB1.
The DB1 database contains the following stored procedure. (Line numbers are included for
reference only.)
When a user named User1 attempts to invoke Procedure1, the following exception is raised:
“Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission
denied in database ‘DB1’.”
You need to provide User1 access to execute Procedure1 by allocating only the required
permissions.
What should you do?
Does this meet the goal?
Your network contains 50 servers that run Windows Server 2003 and 50 servers that run
Windows Server 2008.
You plan to implement Windows Server 2012 R2.
You need to create a report that includes the following information:
The servers that run applications and services that can be moved to Windows Server 2012
R2
The servers that have hardware that can run Windows Server 2012 R2
The servers that are suitable to be converted to virtual machines hosted on Hyper-V hosts
that run Windows Server 2012 R2
Solution: From an existing server, you run the Microsoft Application Compatibility Toolkit
(ACT).
Does this meet the goal?
Does this meet the goal?
Your network contains an Active Directory domain named contoso.com. The domain
contains multiple sites.
You plan to deploy DirectAccess.
The network security policy states that when client computers connect to the corporate
network from the Internet, all of the traffic destined for the Internet must be routed through
the corporate network.
You need to recommend a solution for the planned DirectAccess deployment that meets the
security policy requirement.
Solution: You enable force tunneling.
Does this meet the goal?
Which data type is compatible with the SPARSE option?
You have multiple tables that represent properties of the same kind of entities. The property values
are comprised of text, geometry, varchar(max), and userdefined
types specified as ‘bit NOT NULL’ data types. You plan to consolidate the data from multiple tables
into a single table. The table will use semi structured storage by taking advantage of the SPARSE
option.
You are tasked to identify the data types that are compatible with the SPARSE option.
Which data type is compatible with the SPARSE option?