You need to configure the storage mode for each cube partition
HOTSPOT
You have an OLAP cube named Cube1. Cube1 has two partitions named partition1 and
partition2.
You need to configure the storage mode for each cube partition.
The solution must meet the following requirements:
Users must be able to retrieve aggregate data from partition1 as quickly as possible.
The processing time for partition1 and partition2 must be minimized.
The least possible amount of storage must be used for partition2.
What should you do? To answer, select the appropriate storage mode for each partition in
the answer area.
Which project types should you use?
You are developing a BI Semantic Model (BISM) based on a simple and small dataset
sourced from SQL Server. The data size and complexity of the data relationships will not
change. The model will be used to produce reports in Power View. The reports will show the
relationship between product sales and rainfall over time.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all
that apply.)
Which three actions should you perform in sequence?
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to add a calculated column to a table in the model.
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.)
What should you recommend creating?
Your network contains a server that has SQL Server 2014 installed.
You create a table by using the following script:
You need to recommend a solution to ensure that each combination of ProductName and
ProductManufacturer is not duplicated.
What should you recommend creating?
Which five code segments should you use?
DRAG DROP
You create a disk-based table that contains the following script:
You need to prevent duplicate values in the SKU field.
Which five code segments should you use?
To answer, move the appropriate code segments from the list of code segments to the
answer area and arrange them in the correct order.
How should you complete the table definition to reduce contention on the table structure?
DRAG DROP
You administer a SQL Server 2014 instance.
You have been assigned to determine the cause of frequent long-running transactions that
have been tracked to the dbo.Account table, where there are many cases of blocking and
deadlocks. The dbo.Account table contains more than one million rows.
Users and processes frequently search for and update data by using the AccountId column,
and less frequently the AccountNumber and GovernmentId columns, all of which contain
only unique values. Users frequently get lists of AccountNumber values by searching on Last
Name and then First Name.
You need to modify the structure of the dbo.Account table to alleviate the issues.
How should you complete the table definition to reduce contention on the table structure? To
answer, drag the appropriate code snippets to the correct locations in the CREATE TABLE
statement. Each code snippet 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.
What should you add to the Data Flow task?
The Sales database includes a table named Products that contains 42 columns, and two
tables that record all product sales transactions. The database does not store aggregated
data. The database is continually maintained to provide optimal indexing. The database
server is sized appropriately.
The Marketing department requests a delimited text file that includes seven fields containing
product information from the Products table.
You have the following requirements:
Display the ProductID in the first column. Organize the remaining columns alphabetically by
column heading.
Sort rows in ProductID order.
Aggregate product units sold.
Minimize the time required to return the results.
You create a SQL Server Integration Services (SSIS) package and add the appropriate
connection managers and a Data Flow task.
You need to develop the Data Flow task.
What should you add to the Data Flow task? (More than one answer choice may achieve the
goal. Select the BEST answer.)
Which three actions should you perform in sequence?
DRAG DROP
You install SQL Server Integration Services (SSIS) and develop an SSIS project to load a
data warehouse. The project defines 10 parameters that have different values for the
development, test and production environments. Some packages have additional
parameters defined.
You plan to deploy the SSIS packages to one server. The server will also host the
production data warehouse.
You need to deploy and configure the packages.
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 develop a SQL Server Integration Services (SSIS) project named Project1 by using
SQL Server Data Tools (SSDT). Project1 contains a package named Package1.
You add a project parameter named EnvironmentText to Project1.
In SQL Server Management Studio (SSMS), you create the SSIS catalog.
You have the following requirements:
Configure Package1 so it can run within either a development environment or a test environment.
Pass the value of an SSIS environment variable to the EnvironmentText project parameter.
The value of the environment variable must be different for each SSIS environment.
You need to deploy the SSIS project and configure the SSIS environment.
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.)
You need to select the appropriate model type and partitioning strategy to meet the requirements
You work in the Business Intelligence (BI) department of a multinational company.
To share its sales data between the various subsidiaries, the company has requested a new
corporate BI solution that meets the following requirements:
The solution must use SQL Server Analysis Services (SSAS) multidimensional or tabular
Business Intelligence Semantic Model (BISM).
The model must incrementally add 10 million fact rows of sales data per month.
The model must be translated to English, German, Chinese, or Spanish based on users’
locale.
The model must be able to contain the most recent 36 months of data, in order to let users
query the data.
You need to select the appropriate model type and partitioning strategy to meet the
requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)