You need to minimize disk contention caused by change data capture
You have a database named DB1.
You plan to configure change data capture on the existing tables in DB1.
The database file settings for the DB1 are shown in the exhibit. (Click the Exhibit button.)
You need to minimize disk contention caused by change data capture.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.
Which calculation should you use?
You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube.
For Product A, Projected Revenue is defined as 150 percent of the Total Sales of the
product. For all other products, Projected Revenue is defined as 110 percent of the Total
Sales of the product.
You need to calculate the Projected Revenue as efficiently as possible.
Which calculation should you use? (More than one answer choice may achieve the goal.
Select the BEST answer.)
You need to choose the correct SSAS design strategy
DRAG DROP
You are designing a SQL Server Analysis Services (SSAS) data model on a very large data
warehouse.
The fact tables in the data warehouse contain terabytes of data in tens of billions of rows.
You must support the following features:
Complex attribute/column relationships
Advanced calculations in the data model definition
Advanced calculations using logic deployed in a custom assembly
You need to choose the correct SSAS design strategy.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the
answer area. (Answer choices may be used once, more than once, or not all.)
You need to select a storage mode for each measure group
HOTSPOT
You are designing a SQL Server Analysis Services (SSAS) cube that contains two measure
groups named Sales History and Current Sales.
The Sales History measure group has the following characteristics:
Data changes on a monthly basis.
The measure group contains a very high data volume.
Queries that use the measure group only reference aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
The Current Sales measure group has the following characteristics:
Data changes frequently.
The measure group contains a low data volume.
Queries that use the measure group often reference non-aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
You need to select a storage mode for each measure group. The solution must meet the
following requirements:
For the Sales History measure group, query performance must be optimized over data
latency.
For the Current Sales measure group, data latency must be optimized over query
performance.
What should you do? To answer, select the appropriate storage mode for each measure
group in the answer area.
What should you create?
You have a SQL Server 2012 database named DB1 that is accessed by 650 concurrent
users.
You need to log all of the queries to DB1 that become deadlocked. The solution must
minimize the impact on the server.
What should you create?
You need to design the data model
You are developing the database schema for a SQL Server Analysis Services (SSAS) BI
Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic.
You have the following requirements:
Ensure that queries of the data model correctly display average student age by class.
Ensure that the solution supports role-based security and partitions.
Minimize development effort.
You need to design the data model.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
You need to ensure that the SalesAmount measure stores values to two digits of precision
You are modifying a SQL Server Analysis Services (SSAS) cube.
Users of the cube report that the precision for the SalesAmount measure is four digits. You
need to ensure that the SalesAmount measure stores values to two digits of precision.
What should you do?
Which code segment should you use to replace line 03?
You have a database named Database1.
You execute the following code:
You have the following query. (Line numbers are included for reference only.)
Users report that the query takes a long time to complete.
You create a full-text index for the Notes column.
You need to recommend changes to the query to reduce the amount of time it takes for the
query to complete.
Which code segment should you use to replace line 03?
Which set should you use?
You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube.
The cube includes a Customer dimension that contains a Geography hierarchy and a
Gender attribute hierarchy.
You need to return only the female customers in the Geography hierarchy.
Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
You need to ensure that the Organization and PercentageOfOwnership hierarchies are not visible to users
You are developing a multidimensional project that includes a dimension named
Organization. The dimension is based on the DimOrganization table in the data warehouse.
The following diagram illustrates the table design.
The Organization dimension includes a parent-child hierarchy named Organizations. The
dimension includes the following dimension attributes:
Organization, which is a key attribute
Organizations, which defines the parent-child hierarchy
Currency Code, which is a regular attribute
PercentageOfOwnership, which is a regular attribute
When users browse the dimension, four hierarchies are visible to them.
You need to ensure that the Organization and PercentageOfOwnership hierarchies are not
visible to users.
What should you do?