You need to activate Office 365 ProPlus on the Surface …
You manage client computing devices for a company. Office 365 was recently deployed for all employees in the
sales department. Company policy requires the installation of Office 365 ProPlus on all new client computing
devices for sales department employees.
The company recently purchased Surface Pro 2 devices for all sales department employees. You are testing a
new Office deployment for a specific user on a Surface Pro 2. You are unable to activate Office on the Surface
Pro 2. An error message states that the install limit has been reached.
You need to activate Office 365 ProPlus on the Surface Pro 2 for the user.
What should you do?
You need to help the employee activate Office on her ne…
Your company uses Office 365 and has an Enterprise E3 license plan. Employees are issued laptop computers
that are configured with a standard image. The image includes an installation of Office 365 ProPlus that must
be activated by the employees.
An employee recently received a new laptop computer to replace an older laptop. The older laptop will be
reimaged. When the employee attempts to start Word for the first time, she receives a message saying that
she cannot activate it because she has already activated five devices.
You need to help the employee activate Office on her new laptop computer.
What should you do?
Which requirements should you provide?
DRAG DROP
Your company uses Office 365. You are planning a user-driven deployment of Office 365 ProPlus.
You need to provide users with the minimum requirements for running Office 365 ProPlus.
Which requirements should you provide? To answer, drag the appropriate requirements to the correct targets.
Each requirement may be used once, more than once, or not at all. You may need to drag the split bar between
panes or scroll to view content.
Select and Place:
What should you recommend?
You need to recommend a solution to allow application users to perform UPDATE operations on the database
tables. The solution must meet the business requirements.
What should you recommend?
How should you complete the code?
DRAG DROP
You need to assign security to dev_role1.
How should you complete the code? To answer, drag the appropriate elements to the correct locations. Each
element may be used once, more than once, or not at all. You may need to drag the split bar between panes or
scroll to view content.
Select and Place:
What should you recommend?
DRAG DROP
You have an SQL Server 2014 server.
You plan to create four stored procedures that will use transactions. The stored procedures will be configured
as shown in the following table.
You need to recommend an isolation level for each stored procedure. The solution must support the
concurrency strategy of each stored procedure and must minimize locks.
What should you recommend? To answer, drag the appropriate isolation levels to the correct stored
procedures. Each isolation level may be used once, more than once, or not at all. You may need to drag the
split bar between panes or scroll to view content.
Select and Place:
You need to monitor the following events on SQL1: A dea…
You have an SQL Server 2014 server named SQL1.
You are designing a performance monitoring solution.
You need to monitor the following events on SQL1:
A deadlock graph
Missing column statistics
CPU performance statistics
A batch of completed Transact-SQL statements
Which two tools should you use? Each correct answer presents a complete solution.
What statement should you use?
DRAG DROP
You have a database named DB1. DB1 contains a table named Sales.SalesPerson that has an index named
AK_SalesPerson_rowguid. Queries that do not use the index take approximately 10 times longer to complete
than queries that use the index.
You discover that AK_SalesPerson_rowguid has severe fragmentation.
You need to recommend a solution to defragment the index. The solution must ensure that the index can be
used by queries during the defragmentation.
What statement should you use? To answer, drag the appropriate elements to the correct locations. Each
element may be used once, more than once, or not at all. You may need to drag the split bar between panes or
scroll to view content.
Select and Place:
Which permissions should you assign to Dba1?
You are using dynamic management views to monitor an SQL Server server named SQL1.
A database administrator named Dba1 must monitor the health of SQL1.
You need to ensure that Dba1 can access dynamic management views for SQL1. The solution must use the
principle of least privilege.
Which permissions should you assign to Dba1?
What should you recommend?
DRAG DROP
You define a table by using the following statement.
The Teachers table contains one million records. A sample record of the XML data output is as follows:
You plan to create queries against the table based on grade.
You need to recommend which indexes should be applied to the XML fields. The solution must meet the
following requirements:
Reduce the amount of time required to query the table based on grade.
Minimize the size of the index.
What should you recommend? To answer, drag the appropriate index types to the correct fields. Each index
type may be used once, more than once, or not at all. You may need to drag the split bar between panes or
scroll to view content.
Select and Place:
