You need to ensure that every time a new row is added to the Orders table, a user-defined function is called t
You are creating a table named Orders.
You need to ensure that every time a new row is added to the Orders table, a user-defined
function is called to validate the row before the row is added to the table.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.
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 and
average class level by student.
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 Reports Writer role can view and modify report caching parameters
You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An
item role named Reports Writer is present on the server.
The Reports Writer role cannot view and modify report caching parameters.
You need to ensure that the Reports Writer role can view and modify report caching
parameters.
What should you do?
Which code segment should you execute?
You have a SQL Azure database.
You execute the following code:
The Sales.Customers table will contain 100,000 rows. You expect the FaxNumber column to
contain a null value for 70 percent of the rows.
You need to create an index to support Sales.CustomersByFaxNumber. The solution must
minimize the disk storage requirements.
Which code segment should you execute?
You need to modify the schema
You are modifying a star schema data mart that feeds order data from a SQL Azure
database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two
large tables that include flags and indicators for some orders. There are 100 different flag
columns, each with 10 different indicator values. Some flags reuse indicators. The tables
both have a granularity that matches the fact table.
You have the following requirements:
Allow users to slice data by all flags and indicators.
Modify the date dimension table to include a surrogate key of a numeric data type and add
the surrogate key to the fact table.
Use the most efficient design strategy for cube processing and queries.
You need to modify the schema.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
You need to create a strategy for implementing this process
DRAG DROP
You are designing a self-service business intelligence and reporting environment.
Business analysts will create and publish PowerPivot for Microsoft Excel workbooks and
create reports by using SQL Server Reporting Services (SSRS) and Power View. When the
data models become more complex and the data volume increases, the data models will be
replaced by IT-hosted server-based models.
You have the following requirements:
Maintain the self-service nature of the reporting environment.
Reuse existing reports.
Add calculated columns to the data models.
You need to create a strategy for implementing this process.
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 create a dimension to allow users to view and compare data by scenario
You are developing a SQL Server Analysis Services (SSAS) multidimensional project.
A fact table is related to a dimension table named DimScenario by a column named
ScenarioKey.
The dimension table contains three rows for the following scenarios:
Actual
Budget Q1
Budget Q3
You need to create a dimension to allow users to view and compare data by scenario.
What should you do?
Which data type should you recommend?
You plan to create a new column in a table. The column must meet the following
requirements:
Be able to store images that are larger than 1 MB each.
Be able to access the images from Microsoft .NET Framework applications.
You need to recommend which data type must be used in the column.
Which data type should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
Which set should you use?
You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube.
The cube includes a Product dimension that contains a Category hierarchy and a Color
attribute hierarchy.
You need to return only the blue products in the Category hierarchy.
Which set should you use? (More than one answer choice may achieve the goal. Select the
BEST answer.)
You need to create a measure that calculates the quantity in stock value
You are developing a SQL Server Analysis Services (SSAS) cube.
The data warehouse has a table named FactStock that is used to track movements of stock.
A column namedMovementQuantity contains quantities of stock. A positive quantity is used
for input and negative quantity is used for output. A column named Movement Date is
related to the time dimension. The quantity in stock, at a given point in time, can be
evaluated as the sum of all MovementQuantity values at that point in time.
You need to create a measure that calculates the quantity in stock value.
What should you do?