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?

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-SSAS01 runs SQL Server 2012 Analysis Services (SSAS). The
company has a large data warehouse named CorpDW.
You need to create an SSAS cube to query CorpDW. The cube will use the
multidimensional OLAP (MOLAP) storage mode.
You need to recommend a solution that will automate the collection of aggregation tuning
workloads. Any manual tuning of aggregations must minimize the performance impact of
queries that have already been tuned and the effort required must be minimized.
Which of the following steps should you include in your solution?

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

You have a database named CorpDB1. You need to create a fact table in CorpDB1 that will
expand to contain billions of rows.
You need to design the most efficient table to maximize the performance of queries. Users
must be able to choose up to 12 dimension tables and up to a maximum of 4 facts for any
query. Measures will be aggregated by the queries by using any of the 12 dimensions. You
need to include a columnstore index for the table.
Which three of the following configurations would best meet these requirements? (Choose
three)

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure that includes SQL Server
Analysis Services (SSAS).
The company has a large data warehouse named CorpDW. Terabytes of data are stored in
the fact tables in CorpDW.
The company requires a data model for CorpDW that supports advanced calculations in the
definition of the data model and complex attribute relationships. Advanced calculations
must also be supported in the data model using logic contained in a custom assembly.
You need to design the data model.
Which three of the following options 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.
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. You need to configure the
solution to support partitions and role-based security whilst minimizing development
effort.
Which four of the following should you include in your design? (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 SQL Server Analysis Services (SSAS) cube named MaintenanceCube1.
You are using Multidimensional Expressions (MDX) to define a named set in
MaintenanceCube1.
The Engineer dimension in MaintenanceCube1 contains a hierarchy named Location and
an attribute hierarchy named Availability.
You need to configure the MDX to return all the engineers in the Location hierarchy with
the availability value of Available.
Which of the following should you use for the named set?