070-768 Exam Question 31

DRAG DROP
You need to create the cube processing job and the dimension processing job.
Which processing task should you use for each job? To answer, drag the appropriate processing tasks to the correct locations. Each processing task 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.

070-768 Exam Question 32

You are managing a SQL Server Analysis Services (SSAS) tabular database.
The database must meet the following requirements:
*
The processing must load data into partitions or tables.
*
The processing must not rebuild hierarchies or relationships.
*
The processing must not recalculate calculated columns.
You need to implement a processing strategy for the database to meet the requirements.
Which processing mode should you use?
  • 070-768 Exam Question 33

    Drag and Drop Question
    You are a business analyst for a retail company that uses a Microsoft SQL Server Analysis Services (SSAS) multidimensional database to track sales.
    The database contains the following objects:

    Your company is developing a promotional plaque to recognize the top resellers in the top 10 cities where the company does business. Each plaque must display the sales total for all resellers in the city. In addition, the plaque must display a total for all cities not in the top 10.
    You have the following requirements:
    You need to provide the information needed for the promotional plaques.
    How should you complete the MDX statement? To answer, drag the appropriate MDX segments to the correct locations. Each MDX segment 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. NOTE: Each correct selection is worth one point.

    070-768 Exam Question 34

    How can you enhance the model to support analysis by date?
  • 070-768 Exam Question 35

    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
    A company has an e-commerce website. When a customer places an order, information about the transaction is inserted into tables in a Microsoft SQL Server relational database named OLTP1. The company has a SQL Server Analysis Services (SSAS) instance that is configured to use Tabular mode. SSAS uses data from OLTP1 to populate a data model.
    Sales analysts build reports based on the SSAS model. Reports must be able to access data as soon as it is available in the relational database.
    You need to configure and deploy an Analysis Services project to the Analysis Services instance that allows near real-time data source access.
    Solution: In the Deployment Option property for the report, you set the Query Mode to DirectQuery with InMemory.
    Does the solution meet the goal?