Online Access Free 70-768 Practice Test

You are developing a tabular Business Intelligence Semantic Model (BISM) database based on a SQL Server database.
In the data source, the FactInternetSales table is partitioned by month. Data from the current month has been updated and new data has been inserted in the FactInternetSales table, in the DimProduct table, and in the DimCustomer table.
In the model, the FactInternetSales table is also partitioned by month. You need to ensure that the model has the most recent data while minimizing the processing time.
What should you do?

• A.Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Defrag processing option.
• B.Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Data processing option.
• C.Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Defrag processing option. Then process the database with the Process Recalc processing option.
• D.Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Recalc processing option.
• E.Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Full processing option.

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

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.Create four partitions for the Sales table. Use row filter queries for each partition.
• C.Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for all four tables.
• D.Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for each of the four tables.

Drag and Drop Question
You are a business analyst for a company that uses a Microsoft SQL Server Analysis Services (SSAS) tabular database for reporting. The database model contains the following tables:

You have been asked to write a query for a report that returns the total sales for each product subcategory, as well as for each product category.
You need to write the query to return the data for the report.
How should you complete the DAX statement? To answer, drag the appropriate DAX segment to the correct locations. Each DAX 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.

Correct Answer:

Explanation:
Box 1:EVALUATE
Box 2:SUMMERIZE
Box 3:ROLLUP
Box 4:'Product Subcategory' ['Product Subcategory Name]
Note: The behavior of SUMMARIZE is similar to the GROUP BY syntax of a SELECT statement in SQL. For example, consider the following query.
EVALUATE
SUMMARIZE(
'Internet Sales',
'Internet Sales'[Order Date],
"Sales Amount", SUM( 'Internet Sales'[Sales Amount] ) )
This query calculates the total of Sales Amount for each date in which there is at least one order, producing this result.

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