Which tool should you use?
You maintain SQL Server Analysis Services (SSAS) instances.
You need to configure an installation of PowerPivot for Microsoft SharePoint in a SharePoint
farm.
Which tool should you use? (Each correct answer presents a complete solution. Choose all
that apply.)
Which four actions should you perform in sequence?
DRAG DROP
You install a SQL Server Analysis Services (SSAS) instance in tabular mode on a server.
While processing a very large tabular model, you receive an out-of-memory error. You
identify that the amount of physical memory in the server is insufficient. Additional physical
memory cannot be installed in the server.
You need to configure the server to allow paging to disk by using the operating system page
file (pagefile.sys).
Which four actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Which code segment should you add at line 06?
You have a database hosted on SQL Azure.
You are developing a script to create a view that will be used to update the data in a table.
The following is the relevant portion of the script. (Line numbers are included for reference only.)
You need to ensure that the view can update the data in the table, except for the data in Column1.
Which code segment should you add at line 06?
You need to ensure that the model has the most recent data while minimizing the processing time
You are developing a tabular Business Intelligence Semantic Model (BISMJ database based
on a SQL Server database.
In the data source, the FactlnternetSales table is partitioned by month. Data from the current
month has been updated and new data has been inserted in the FactlnternetSales table, in
the DimProduct table, and in the DimCustomer table.
In the model, the FactlnternetSales table is also partitioned by month.
You need to ensure that the model has the most recent data while minimizing the processing
time.
What should you do?
You need to ensure that HR.Employees is always updated when up_employees executes
You have a Microsoft SQL Azure database.
You have the following stored procedure:
You discover that the stored procedure periodically fails to update HR.Employees.
You need to ensure that HR.Employees is always updated when up_employees executes.
The solution must minimize the amount of time required for the stored procedure to execute
and the number of locks held.
What should you do?
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 status code.
You need to identify which options must be implemented to meet each stored procedure
requirement.
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 processing option should you use?
HOTSPOT
You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was
developed with default settings.
The model has one cube and the cube has one measure group. The measure group is
based on a very large fact table and is partitioned by month. The fact table is incrementally
loaded each day with approximately 800,000 new rows.
You need to ensure that all rows are available in the cube while minimizing the processing
time.
Which processing option should you use? (To answer, select the appropriate option in the answer area.)
What should you change Proc1 to do?
You have a database named Database1. Database1 has two stored procedures named
Proc1 and Proc2 and a table named Table1. Table1 has millions of rows.
Proc1 updates data in Table1. Proc2 reads data from Table1.
You discover that when Proc1 is executed to update more than 4,000 rows, Proc2 is
blocked. The book affects all rows, including those that are not being updated by Proc1.
You need to ensure that when Proc1 is executing, Proc2 can access the data in Table1 that
Proc1 is not updating.
What should you change Proc1 to do?
More than one answer choice may achieve the goal. Select the BEST answer.
You need to delete the dimension
You are modifying a SQL Server Analysis Services (SSAS) multidimensional database.
You have identified a dimension that is no longer used by any cubes.
You need to delete the dimension.
What should you do?
What should you add next to the beginning of each stored procedure?
You need to implement a solution that meets the data recovery requirements.
You update each stored procedure to accept a parameter named @transactionID.
What should you add next to the beginning of each stored procedure?