70-470 무료 덤프문제 온라인 액세스

You are redesigning a SQL Server Analysis Services (SSAS) database that contains a cube named Sales. Before the initial deployment of the cube, partition design was optimized for processing time. The cube currently includes five partitions named FactSalesl through FactSales5. Each partition contains from 1 million to 2 million rows.
The FactSales5 partition contains the current year's information. The other partitions contain information from prior years; one year per partition. Currently, no aggregations are defined on the partitions.
You remove fact rows that are more than five years old from the fact table in the data source and configure query logs on the SSAS server.
Several queries and reports are running very slowly.
You need to optimize the partition structure and design aggregations to improve query performance and minimize administrative overhead.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Use the Aggregation Design Wizard to create aggregations for the current partitions.
• B.Use the Usage-Based Optimization Wizard to create aggregations for the current partitions.
• C.Combine all the partitions into a single partition. Use the Aggregation Design Wizard to create aggregations.
• D.Combine all the partitions into a single partition. Use the Usage-Based Optimization Wizard to create aggregations.

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 with DirectQuery
• B.DirectQuery
• C.DirectQuery with In-Memory
• D.In-Memory

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year, MonthNumber, and InvCount. The report includes a table that displays the inventory count per year, as shown in the following diagram.

You need to modify the table to include a graphical item displaying the inventory count trend to the right of the Inv Count column.
What should you do?

• A.Add an Indicator item to a new column on the right of the Inv Count column. Select the Directional Indicator type and then assign the MonthNumber field to the Start property.
• B.Add a text box to a new column on the right of the Inv Count column. Then use a Go to report action to link to a separate report showing the monthly trend.
• C.Add a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Series Groups.
• D.Add an Indicator item to a new column on the right of the Inv Count column. Select the Directional Indicator type and then select the MonthNumber field for Value.
• E.Add a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Category Groups.

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named DimEmployee. The table contains employee details, including the sales territory for each employee. The table also defines a column named EmployeeAlias which contains the Active Directory Domain Services (AD DS) domain and logon name for each employee. You create a role named Employees.
You need to configure the Employees roles so that users can query only sales orders for their respective sales territory.
What should you do?

• A.Add a row filter that implements the LOOKUPVALUE and CUSTOMDATA functions.
• B.Add a row filter that implements only the USERNAME function.
• C.Add a row filter that implements only the CUSTOMDATA function.
• D.Add a row filter that implements the LOOKUPVALUE and USERNAME functions.

You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report.
You have an application that populates a table with user-specific subscription schedules and report formats.
You need to ensure that users can receive reports by email according to their preferences. Email messages will be sent via an internal mail server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Create a standard SSRS subscription for each subscription schedule.
• B.Create a standard SSRS subscription for each record in the table.
• C.Create one data-driven SSRS subscription. Schedule the subscription to frequently retrieve user preferences.
• D.Create a data-driven SSRS subscription for each record in the schedule table.