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

A database named DB2 uses the InMemory query mode. Users frequently run the following query:

You need to ensure no users see the PriorYearSales measure in the field list for the Sales table.
What should you do?

• A.Create a perspective, and ensure that the PriorYearSales measure is not added to the perspective.
  Ensure that users connect to the model by using the perspective.
• B.Create a role using Read permissions, and define a DAX expression to filter out the PriorYearSales measure. Add all users to the role.
• C.Remove the PriorYearSales measure from the default field set of the Sales table.
• D.Set the Display Folder property for PriorYearSales toHidden.

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?

• A.Calculate Non Empty Begin
• B.Get Data From Aggregation
• C.Progress Report Begin
• D.Query Subcube
• E.Execute MDX Script Begin
• F.Query Begin

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 administer a Microsoft SQL Server Analysis Services (SSAS) tabular model for a travel agency that specializes in vacation packages. Vacation bookings and packages are stored in a SQL Server database. You use the model as the basis for customer emails that highlight vacation packages that are currently underbooked, or projected to be underbooked.
The company plans to incorporate cruise ship vacation packages. Cruise ship vacation packages include new features such as region availability and cruise line specialties that require changes to the tabular model.
You must ensure that the tabular model reflects the new vacation packages.
You need to configure the tabular data model.
What should you do?

• A.Process the model in Process Defrag mode.
• B.Process the model in Process Full mode.
• C.Ensure that the Transactional Deployment property is set to False.
• D.Ensure that DirectQuery is enabled for the model.
• E.Ensure that the Transactional Deployment property is set to True.
• F.Process the model in Process Data mode.
• G.Ensure that DirectQuery is disabled for the model.

You are designing a SQL Server Analysis Services (SSAS) cube.You need to create a measure to count unique customers.What should you do?

• A.Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.
• B.Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• C.Create several dimensions. Add each dimension to the cube.
• D.Create a dimension. Then add a cube dimension and link it several times to the measure group.

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.