You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
The company has a database named CorpDB and a data warehouse named CorpDW.
You need to create an ETL process to update a large fact table in CorpDW with the prior
day’s data from CorpDB and to remove data that is more than 24 months old from CorpDW.
You need to configure the ETL process to add the new data as quickly as possible,
minimize the amount of logging in the transaction log and minimize the risk of locked
records during the update process.
You partition the fact table by date.
How should you add the new records and remove the old data from the fact table? (Choose
two).

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis
Services (SSAS). You have an SSAS cube named SalesCube1.
Users in the Sales department are members of an Active Directory global group named
SalesUsers.
You need to grant the users in the Sales department write access to SalesCube1. You open
SQL Server Management Studio (SSMS).
Which four of the following actions should you perform next? (Choose four)

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis
Services (SSAS).
You are creating a BI Semantic Model (BISM). The graphic below shows the schema that
the BISM will be based on.

You are planning the data model. Your data model must support queries to display the
average number of employee years of service by factory and the average output by
employee.
Which three of the following should you include in your design? (Choose three).

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.

PowerPivot for Microsoft Excel workbooks and SQL Server Reporting Services (SSRS)
reports have been created and published to provide a self-service data analysis and
reporting environment.
Due to the increasing volume of data, you need to create server-based data models to
continue to provide the self-service data analysis and reporting environment.
You need to configure a solution that can support the addition of calculated columns and
use the existing SSRS reports.
Which of the following steps should you perform to create and implement your solution?
(Choose all that apply).

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A SQL Server Analysis Services (SSAS) cube named SalesCube1 is loaded with daily sales
data from a SQL Server data mart named DMSales. The source data is read from a SQL
Server 2012 database. The DMSales data mart uses a star schema.
Two tables in DMSales include a total of 80 flag columns. The tables containing the flag
columns have the same granularity as the fact table. The flag columns each have 12
different indicators values which are reused by some flags.
You need to modify the DMSales schema to maximize cube processing and query
performance and to enable users to use all flags and indicators to slice the data.

The table used for the date dimension needs to be modified to include a numeric surrogate
key and the surrogate key needs to be added to the fact table.
Which two of the following schema modifications should you perform? (Choose two)

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
The company has a SQL Server Analysis Services (SSAS) cube named ProductsCube1.
You are using Multidimensional Expressions (MDX) to define a named set in
ProductsCube1.
The Product dimension in ProductsCube1 contains a hierarchy named Type and an
attribute hierarchy named Size.
You need to configure the MDX to return all the products in the Type hierarchy with the size
value of Large.
Which of the following should you use for the named set?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A server named ABC-SSAS1 runs SQL Server Analysis Services (SSAS). You are
developing a cube on ABC-SSAS1.
The cube includes a dimension named Type which is based on a table named DimType.
The following image shows a portion of the data source view.

You need to configure a relationship between the Orders measure group and the Type
dimension.
Which of the following relationship types should you select?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.

The company has a data warehouse named CorpDW. CorpDW is updated with
approximately 100 million new records every week outside business hours.
Data is sometimes queried at month level but more often is queried at the week level using
cube processing and reports.
CorpDW contains a large fact table. You need to configure the table partitioning to ensure
that the performance of the queries is maximized.
Which two of the following options describe how you should you partition the table?
(Choose two).

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis
Services (SSAS). You have an SSAS cube named FinanceCube1.
Users in the Finance department are members of an Active Directory global group named
FinanceUsers.
You need to grant the users in the Finance department read access to FinanceCube1. You
open SQL Server Management Studio (SSMS).
Which four of the following actions should you perform next? (Choose four)

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
The company has a large data warehouse named CorpDW. New data is added to a fact
table named CurrentInfo in the data warehouse throughout the day.
A server named ABC-SSAS01 runs SQL Server 2012 Analysis Services (SSAS). You have
an SSAS cube named ABC-Cube1 which contains a measure group supported by the
CurrentInfo fact table.
You need to configure the partitioning for the cube to optimize query performance across
all aggregation levels whilst ensuring the cube is available as much as possible and
displays the most up-to-date data as quickly as possible.
You plan to create a single partition to host the current day’s data.
How should you configure the partition?