Which code segment should you use?
You have a SQL Server 2012 instance.
You plan to create an application that uses spatial data.
You need to create an object that will support the representation of the surface area of all the oceans.
Which code segment should you use?
Which configuration type should you use?
HOTSPOT
You are designing a SQL Server Integration Services (SSIS) package configuration strategy.
The package configuration must meet the following requirements:
Include multiple properties in a configuration.
Force packages to load all settings in the configuration.
Support Encrypting File System (EFS) formats.
You need to select the appropriate configuration.
Which configuration type should you use?
To answer, select the appropriate option from the drop-down list in the dialog box.
Which MDX function should you use in line 03?
HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube.
You are writing the following Multidimensional Expressions (MDX) statement for use by a
calculated measure. The measure computes the sales amount for the same time period of
the previous year. (Line numbers are included for reference only.)
You need to complete the MDX statement.
Which MDX function should you use in line 03? To answer, select the appropriate MDX
function in the functions list.
which three actions should you perform in sequence?
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a measure group from a different database.
In SQL Server Data Tools (SSDT), which three actions should you perform in sequence? (To
answer, move the appropriate actions from the list of actions to the answer area and arrange
them in the correct order.)
Which three actions should you perform in sequence?
DRAG DROP
You are developing a SQL Server PowerPivot model to monitor the rate of production of
defective products.
The PowerPivot model contains many tables. The FactProduction table is configured as
shown in the following diagram.
The model requires a key performance indicator (KPI) named Defective Units to measure
the rate of production of defective units. The rate of production of defective units is
calculated by dividing the sum of the Defects column by the sum of the Units column.
The KPI has the following requirements.
If the rate of production of defective products equals or exceeds 5% then the KPI must report
a status of off target (red).
If the rate of production of defective products is less than 5% and equals or exceeds 2%
then the KPI must report a status of slightly off target (yellow).
If the rate of production of defective products less than 2% then the KPI must report a status
of on target (green).
You need to develop the KPI to meet the requirements.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Which transaction isolation level should you use in sp1?
You use SQL Server 2012 to store data used by an e-commerce application.
You develop a stored procedure named sp1. Sp1 is used to read the price of all the products
sold on the e-commerce site.
You need to ensure that sp1 can read data even while another transaction is modifying the
price of a product. Sp1 must only read committed data.
Which transaction isolation level should you use in sp1?
You need to design the SSIS solution to meet the requirements
You are designing a SQL Server Integration Services (SSIS) solution that will load multiple
Online Transactional Processing (OLTP) data sources into a SQL Server data mart.
You have the following requirements:
Ensure that the process supports the creation of an exception report that details possible
duplicate key values, null ratios within columns, and column-length distributions of values.
Ensure that users can generate the exception report in an XML format.
Use the minimum development effort.
You need to design the SSIS solution to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You need to implement a time dimension
You are developing a SQL Server Analysis Services (SSAS) multidimensional database.
The underlying data source does not have a time dimension table.
You need to implement a time dimension.
What should you do?
Which advanced server option should you modify?
You have a SQL Server 2012 instance that hosts a single-user database.
The database does not contain user-created stored procedures or user-created functions.
You need to minimize the amount of memory used for query plan caching.
Which advanced server option should you modify?
You need to create one index to minimize the amount of time it takes to execute the query
DRAG DROP
You have a database that contains three tables. The tables are configured as shown in the following table.
You have the following query:
The execution plan for the query is shown in the exhibit. (Click the Exhibit button.)
You need to create one index to minimize the amount of time it takes to execute the query.
What should you do?
To answer, drag the appropriate columns to the correct locations in the answer area.
(Answer choices may be used once, more than once, or not at all.)