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?

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-SSIS01 runs SQL Server 2012 Integration
Services (SSIS).
You need to determine which package configuration to use for SSIS packages. You need
to select a package configuration option that will allow you to store multiple configuration
properties/values and ensure that all the properties/values are loaded.
Which of the five package configuration options should you use?

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-SSIS01 runs SQL Server 2012 Integration
Services (SSIS).
You need to determine which package configuration to use for SSIS packages. You need
to select a package configuration option that will allow you to store multiple configuration
properties/values and support encryption using EFS (Encrypted File System).
Which of the five package configuration options should you use?

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 data mart named DMMarketing which contains historical
data for use by the Marketing department.
You need to create a package in SQL Server Integration Services (SSIS) to load data into
DMMarketing. The data will come from multiple Online Transactional Processing (OLTP)
data sources.
Your solution must be able to analyze the data for problems by reporting on column-length
value distribution, null values in selected columns and duplicate values in potential key
columns. Users must be able to generate an XML report that lists any exceptions.
Which two of the following options describe the solution that would require the minimum
development effort? (Choose two).

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure which includes SQL Server
Integration Services (SSIS).
You need to create a project in SSIS that will contain multiple SSIS packages.
The variables and connection managers will be the same for all SSIS packages within the
project. You need to parameterize the connection manager strings to enable the properties
to be updated for subsequent package runs.
You need to ensure that your solution includes the automatic logging of events in the
Analysis Services database.
Which two of the following options describe the solution that meets the requirements and
maximizes performance? (Choose two).