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

Which of the following object types do you add to the cube?

• A.Calculated member set
• B.Calculated measure
• C.Dynamic named set
• D.Static named set

You are building a Microsoft SQL Server Analysis Services multidimensional model over a SQL Server database.
In a cube named OrderAnalysis, there is a standard cube dimension named Stock Item.
This dimension has the following attributes:
Users report that the attributes Stock Item Key and Photo are distracting and are not providing any value.
They have asked for the attributes to be removed. However, these attributes are needed by other cubes.
You need to hide the specified attributes from the end users of the OrderAnalysis cube. You do not want to change the structure of the dimension.
Which change should you make to the properties for the Stock Item Key and Photo attributes?

• A.Set the AttributeHierarchyDisplayFolder property to Hidden.
• B.Set the AttributeVisibility property to Hidden.
• C.Set the AttributeHierarchyVisible property to False.
• D.Set the AttributeHierarchyEnabledproperty to False.
• E.Set the Usage property to Regular.

What property do you set to hide the phone number attribute in the customer dimension from slicing and dicing operations, but allows it to be included in the dimension as a member property?

• A.IsAggregatable
• B.AttributeHierarchyOrdered
• C.AttributeHierarchyVisible
• D.AttributeHierarchyEnabled

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

• A.TotalMemoryLimit
• B.VirtualMemoryLimit
• C.VertiPaqPagingPolicy
• D.LowMemoryLimit

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named Sales.
The Sales table includes a single date column.
The Sales table must meet the following requirements:
- Queries must be able to return all rows.
- Must be able to support four different processing schedules for
different date ranges.
- Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.What should you do?

• A.Create four partitions for the Sales table. Create four roles. Use the same row filter queries for each role and partition.
• B.Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for each of the four tables.
• C.Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for all four tables.
• D.Create four partitions for the Sales table. Use row filter queries for each partition.