070-466 무료 덤프문제 온라인 액세스

DRAG DROP
You need to optimize the Regions dimension.
How should you configure the attribute relationships? (To answer, drag the appropriate attribute from the list of attributes to the correct location in the hierarchy relationship. Use only attributes that apply.)

정답:

You are creating a SQL Server Analysis Services (SSAS) cube.
You need to create a time dimension. It must be linked to a measure group named Sales at the day granularity level. It must also be linked to a measure group named Salary at the month granularity level.
What should you do?

• A.Use role playing dimensions.
• B.Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.
• C.Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
• D.Create several dimensions. Add each dimension to the cube.
• E.Add a measure that uses the Count aggregate function to an existing measure group.
• F.Create a dimension. Then add a cube dimension and link it several times to the measure group.
• G.Add a measure group that has one measure that uses the DistinctCount aggregate function.
• H.Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• I.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
• J.Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• K.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
• L.Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• M.Use the Business Intelligence Wizard to define dimension intelligence.
• N.Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
• O.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.

You have a SQL Server 2012 database named DB1. You have a backup device named Device1.
You discover that the log file for the database is full. You need to ensure that DB1 can complete transactions.
The solution must not affect the chain of log sequence numbers (LSNs).
Which code segment should you execute?

• A.BACKUP LOG DB1 TO Device1 WITH NCRECCVERY
• B.BACKUP LOG DB1 TO Device1
• C.BACKUP LOG D31 TO Device1 WITH TRUNCATE ONLY
• D.BACKUP LCG DB1 TO Device1 WITH COPY_ONLY

HOTSPOT
You have a database named DB1. DB1 contains three tables named FactSales, DimCustomer, and DimEmployee. A sample from DimEmployee is shown in the following table.

A sample from DimCustomer is shown in the following table.

A sample from FactSales is shown in the following table.

You create a cube named Sales that uses the three tables. FactSales is used as a fact table, DimCustomer is used to create a dimension named Customer, and DimEmployee is used to create a dimension named Employee.
Users report the following issues:
* When browsing the Customer dimension, the users see a blank member in the state hierarchy under United Kingdom.
* When browsing the Employee dimension, the sales data for Sales Managers and Sales Supervisors is NOT displayed.
You need to resolve the issues by configuring the properties of the dimension attributes.
What should you do? To answer, select the appropriate value for each property in the answer area.

정답:

You are working with multiple tabular models deployed on a single SQL Server Analysis Services (SSAS) instance.
You need to ascertain the memory consumed by each object in the SSAS instance.
What should you do?

• A.Use SQL Server Profiler to review session events for active sessions.
• B.Use the Usage Based Optimization wizard to design appropriate aggregations.
• C.Use the Performance Counter group named Processing.
• D.Use the $System.discover_object_memory_usage dynamic management view.