Which code segment should you execute?
You have a SQL Server 2012 database named Database1. Database1 contains a table
named OrderDetails.
For a given sales order, you need to retrieve the OrderID, Quantity, and LineTotal columns
for all of the items in the OrderDetails table. The solution must ensure that the results can be
joined to other tables.
Which code segment should you execute?
How should you configure the report parameter properties?
HOTSPOT
You are using a new installation of SQL Server Reporting Services (SSRS) to create three
sales reports that consume data from a stored procedure. The stored procedure is defined in
a Windows Azure SQL Database.
All reports must pass USA to the Country parameter of the stored procedure. Users cannot
change the Country report parameter value.
You need to configure the report parameter properties.
How should you configure the report parameter properties? To answer, select the
appropriate setting or settings in the answer area.
You need to ensure that each salesperson has access to data from only the sales territory assigned to that sal
You are developing a SQL Server Analysis Services (SSAS) tabular project.
In the data warehouse, a table named Employee Security defines a relationship between a
salesperson’s name, logon ID, and assigned sales territory.
You need to ensure that each salesperson has access to data from only the sales territory
assigned to that salesperson. You also need to minimize the development effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
Which code segment should you run?
You create a view by using the following code:
Several months after you create the view, users report that the view has started to return
unexpected results.
You discover that the design of Table2 was modified since you created the view.
You need to ensure that the view returns the correct results.
Which code segment should you run?
You need to configure a data refresh schedule for the workbook that meets the requirements
You deploy a PowerPivot workbook to a PowerPivot Gallery in a Microsoft SharePoint site.
Workbook data comes from two different sources: Source A and Source B.
The workbook contains five tables with a total of 20 million rows from Source A, and three
small lookup tables from Source B. Data from Source A is updated throughout the day. Data
from Source B is updated at 3:00 P.M.
You have the following requirements:
Refresh the PowerPivot workbook with updated lookup data as soon as possible.
Minimize load on the source systems and the SharePoint environment during business
hours.
Minimize user involvement in the data refresh process.
You enable automatic data refresh for the workbook.
You need to configure a data refresh schedule for the workbook that meets the
requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
How should you define the impersonation information for the connection?
You develop a SQL Server Analysis Services (SSAS) tabular project.The tabular model
loads data from a SQL Server relational database each day.
You define a connection.
You need to ensure that the connection minimizes the attack surface area of the server.
How should you define the impersonation information for the connection? (More than one
answer choice may achieve the goal. Select the BEST answer.)
You need to create a distributed partitioned view
Your company has a main office in London and a branch office in New York.
Your network contains a server named Server5 that has SQL Server 2012 installed.
Serverscontains a database name ContentDB and a table named ContentTable.
You add an additional server named Server9 that runs SQL Server 2012.
You need to create a distributed partitioned view. The solution must minimize the amount of
network traffic.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
Which options should you identify?
DRAG DROP
You are planning two stored procedures named SProc1 and SProc2.
You identify the following requirements:
SProc1 must return a table.
SProc2 must return a scalar value.
You need to identify which option must be implemented for each stored procedure to return
the desired data.
Which options should you identify?
To answer, drag the appropriate option to the correct requirement in the answer area.
(Answer choices may be used once, more than once, or not at all.)
Which option should you select?
HOTSPOT
You are designing aggregations for a SQL Server Analysis Services (SSAS) cube.
You need to ensure that every aggregation excludes the Category attribute.
Which option should you select?
To answer, select the appropriate option in the answer area.
How should you write the calculation?
You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used
in the definition of a hierarchy. The City column exists in the Geography table that is related
to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?