Free 70-768 Braindumps


  • Exam Number: 70-768
  • Provider: Microsoft
  • Questions: 50
  • Updated On: 22-Jan-2021

Question: 1

You need to configure the server to optimize the afternoon report generation based on the OrderAnalysis cube.
Which property should you configure?

  1. LowMemoryLimit
  2. VertiPaqPagingPolicy
  3. TotalMemoryLimit
  4. VirtualMemoryLimit

Answer(s): A

Explanation:

LowMemoryLimit: For multidimensional instances, a lower threshold at which the server first begins releasing memory allocated to infrequently used objects.
From scenario: Reports that are generated based on data from the OrderAnalysis cube take more time to complete when they are generated in the afternoon each day. You examine the server and observe that it is under significant memory pressure.

Question: 2

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 have a Microsoft SQL Server Analysis Services (SSAS) instance that is configured to use multidimensional mode. You create the following cube:

Users need to be able to analyze sales by product and color.
You need to create the dimension.
Which relationship type should you use between the InternetSales table and the new dimension?

  1. no relationship
  2. regular
  3. fact
  4. referenced
  5. many-to-many
  6. data mining

Answer(s): D

Explanation:

A reference dimension relationship between a cube dimension and a measure group exists when the key column for the dimension is joined indirectly to the fact table through a key in another dimension table, as shown in the following illustration.

You can create two dimensions related to the InternetSales measure group: a dimension based on the Customer table, and a dimension based on the Geography table. You can then relate the Geography dimension to the InternetSales measure group using a reference dimension relationship using the Customer dimension.

Question: 3

You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance, sales, and marketing teams.
The sales team reports that the model is too complex and difficult to use. The sales team does not need any information other than sales-related resources in the tabular model. The finance and marketing teams need to see all the resources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing development and administrative effort.
What should you do?

  1. Create a separate partition for each team.
  2. Create a separate data source for each team.
  3. Create a perspective for the sales team.
  4. Enable client side security to filter non-sales data.

Answer(s): C

Question: 4

You are developing a SQL Server Analysis Services (SSAS) cube.
Revenue must be compared to a goal and described by a status and a trend. Revenue, goal, status, and trend will be defined by Multidimensional Expressions (MDX) expressions.
You need to add the Revenue indicator.
Which tab should you select? (To answer, select the appropriate tab in the work area.)

  1. Please refer to Exhibit B for the answer.

Answer(s): A

Question: 5

You are deploying a multidimensional Microsoft SQL Server Analysis Services (SSAS) project. You add two new role-playing dimensions named Picker and Salesperson to the cube. Both of the cube dimensions are based upon the underlying dimension named Employee in the data source view.
Users report that they are unable to differentiate the Salesperson attributes from the Picker attributes.
You need to ensure that the Salesperson and Picker attributes in each dimension use unique names.
In the table below, identify an option that you would use as part of the process to alter the names of the attributes for each of the dimensions.
NOTE: Make only one selection in each column.

  1. Please refer to Exhibit B for the answer.

Answer(s): A

Explanation:

A named query is a SQL expression represented as a table. In a named query, you can specify an SQL expression to select rows and columns returned from one or more tables in one or more data sources. A named query is like any other table in a data source view (DSV) with rows and relationships, except that the named query is based on an expression.
A named query lets you extend the relational schema of existing tables in DSV without modifying the underlying data source.


Reference:

https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/define-named-queries-in-a-data-source-view-analysis-services

Question: 6

You are troubleshooting query performance for a SQL Server Analysis Services (SSAS) cube.
A user reports that a Multidimensional Expressions (MDX) query is very slow.
You need to identify the MDX query statement in a trace by using SQL Server Profiler.
Which event class should you use?

  1. Get Data From Aggregation
  2. Query Subcube
  3. Query Begin
  4. Progress Report Begin
  5. Calculate Non Empty Begin
  6. Execute MDX Script Begin

Answer(s): C

Question: 7

You are responsible for installing new database server instances.
You must install Microsoft SQL Server Analysis Services (SSAS) to support deployment of the following projects. You develop both projects by using SQL Server Data Tools.
You need to install the appropriate services to support both projects.
Which two actions should you perform? Each correct answer presents part of the solution.

  1. Install one tabular instance of SSAS and enable the Data Mining Extensions.
  2. Install one multidimensional instance of SSAS.
  3. Install one tabular instance of SSAS.
  4. Install a multidimensional instance and a Power Pivot instance of SSAS on the same server.
  5. Install two separate tabular instances of SSAS.

Answer(s): B,C

Explanation:

Analysis Services can be installed in one of three server modes: Multidimensional and Data Mining (default), Power Pivot for SharePoint, and Tabular.


Reference:

https://docs.microsoft.com/en-us/sql/analysis-services/comparing-tabular-and-multidimensional-solutions-ssas

Question: 8

You are a database administrator in a company that uses Microsoft SharePoint Server for all intranet sites. You are responsible for the installation of new database server instances.
You must install Microsoft SQL Server Analysis Server (SSAS) to support deployment of the following projects. You develop both projects by using SQL Server Data Tools.
You need to install the appropriate services to support both projects.
What should you do? In the table below, select the appropriate services for each project.
NOTE: Make only one selection in each column. Each correct selection is worth one point.