Online Access Free 70-768 Practice Test

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have a Microsoft SQL Server Analysis Services (SSAS) multidimensional database that stores customer and order data for customers in the United States only. The database contains the following objects:

You must create a KPI named Large Sales Target that uses the Traffic Light indicator to display status. The KPI must contain:

You need to create the KPI.
Solution: You set the value of the Status expression to:

Does the solution meet the goal?

• A.Yes
• B.No

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
A company has an e-commerce website. When a customer places an order, information about the transaction is inserted into tables in a Microsoft SQL Server relational database named OLTP1. The company has a SQL Server Analysis Services (SSAS) instance that is configured to use Tabular mode. SSAS uses data from OLTP1 to populate a data model.
Sales analysts build reports based on the SSAS model. Reports must be able to access data as soon as it is available in the relational database.
You need to configure and deploy an Analysis Services project to the Analysis Services instance that allows near real-time data source access.
Solution: In the Deployment Option property for the report, you set the Query Mode to DirectQuery with InMemory.
Does the solution meet the goal?

• A.Yes
• B.No

You are optimizing a Microsoft SQL Server Analysis Services (SSAS) multidimensional model over a SQL Server database.
You have a table named City which has several dimensions that do not contain a space in their names.
One dimension is named SalesTerritory rather than Sales Territory.
You need to ensure that Report developers can drag the attribute name to the report rather than having to re-label the attributes by implementing spaces.
You must minimize administrative effort and not break any upstream processes.
What should you do?

• A.In SQL Server Management Studio, navigate to the City table, expand the columns, press F2, and rename the columns in the base tables.
• B.In the SQL Server database, implement a view over the City table that aliases the columns in the tables.
• C.In the SQL Server database, run the system procedure sp_rename to rename the columns in the base tables with the target name.
• D.In the SQL Server database, implement a SYNONYM.

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.

What type of partitioning strategy should you implement to support the analysis of hourly Internet sales transactions?

• A.Create one partition per hour per day dynamically by running an SSIS package each hour to build the new partition. Load the data for the current hour by performing a Process Add, and then execute a Process Recalc on the partition
• B.Set the model to DirectQuery With In-Memory Mode. Define a sample partition for the Internet Sales table to view data during development.
• C.Convert the model to DirectQuery. Add columnstore indexes to the source tables. In the model, define a sample partition for all tables to view data during development.
• D.Create one partition per day dynamically by running an SSIS package daily to build the new partition. Load the data for the current day by performing a Process Full operation on the partition.