070-768 Exam Question 46

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are developing Microsoft SQL Server Analysis Services (SSAS) tabular model.
The model must meet the following requirements:
You need to configure model.
What should you do?
  • 070-768 Exam Question 47

    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 InMemory with DirectQuery.
    Does the solution meet the goal?
  • 070-768 Exam Question 48

    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?
  • 070-768 Exam Question 49

    You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a SQL Azure database and an OData data feed.
    The model will be deployed to a server with significantly more memory than the total size of the source data.
    You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT).
    The model must meet the following requirements:
    - Maximize performance
    - Data latency of up to one month is acceptable
    You need to choose a project type and a data access mode to meet the requirements.
    What should you do?
  • 070-768 Exam Question 50

    What property do you set for each measure to improve the legibility of values in a client application?