70-768 試験問題を無料オンラインアクセス

You are a business analyst for a retail company that uses a Microsoft SQL Server Analysis Services (SSAS) multidimensional database for reporting.
The database contains the following objects:

You must create a report that shows, for each month, the Internet sales for that month and the total Internet sales for the calendar year up to and including the current month.
You create the following MDX statement (Line numbers are included for reference only.):

You need to complete the MDX statement to return data for the report.
Which MDX segment should you use in line 01?

• A.
• B.
• C.
• D.

Drag and Drop Question
You are writing a MDX query to retrieve data from a Microsoft SQL Server Analysis Services (SSAS) cube named Channel Sales. The cube defines two measures named Sales and Cost.
The cube also defines a Date dimension and a Product dimension.
You need to retrieve profit values for a year named CY2016.
How should you complete the MDX statement? To answer, drag the appropriate MDX segment 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.

正解：

Explanation:
Box 1:WITH MEMBER...
Box 2:WHERE ([Date].[Year].[CY2016])
https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/mdx/working- with-members-tuples-and-sets-mdx

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.
You deploy a tabular data model to an instance of Microsoft SQL Server Analysis Services (SSAS). The model uses an in-memory cache to store and query data.
The data set is already the same size as the available RAM on the server. Data volumes are likely to continue to increase rapidly.
Your data model contains multiple calculated tables.
The data model must begin processing each day at 2:00 and processing should be complete by
4:00 the same day.
You observe that the data processing operation often does not complete before 7:00. This is adversely affecting team members.
You need to improve the performance.
Solution: Enable Buffer Cache Extensions.
Does the solution meet the goal?

• A.No
• B.Yes

You are developing a SQL Server Analysis Services (SSAS) tabular database.
To maximize performance, queries must be resolved only by using cache.
You need to configure the appropriate query mode.
Which query mode should you select?

• A.In-Memory
• B.In-Memory with DirectQuery
• C.DirectQuery
• D.DirectQuery with In-Memory

You are developing a SQL Server Analysis Services (SSAS) tabular project.
In the data warehouse, a table named Sales Persons and Territories 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 need to use the least amount of development effort to achieve this goal.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Add the Sales Persons and Territories table to the model, define the relationships, and then implement dynamic security by using row filters.
  Grant each salesperson access to the model.
• B.Create a separate tabular model for each sales territory and assign each tabular model a corresponding sales territory name.
  Grant each salesperson access to the corresponding tabular model of the assigned sales territory.
• C.Create a new Active Directory Domain Services (AD DS) security group and add each salesperson as a member.
  Then create a new role named Sales Persons with Read permission.
  Add the group as a member to the new role.
• D.Create a new role named Sales Persons with Read permission.
  Add each salesperson's logon as a member to the role.