Topic 1, ABC Solutions
General Overview
You are the Senior Database Administrator (DBA) for a software development company named
ABC Solutions.
Existing Environment – Active Directory
The network consists of an Active Directory Domain Services (AD DS) forest that includes a single
domain named CharnTech.com
All domain controllers run Windows Server 2008 R2 Service Pack 1 (SP1). A number of domain
member servers have been upgraded to Windows Server 2012. The remaining member servers
run Windows Server 2008 R2 Service Pack 1 (SP1). The client computers run either Windows 8
Professional or Windows 7 Professional with Service Pack 1 (SP1).
The functional level of the domain is Windows Server 2008 R2 and the functional level of the
forest is Windows Server 2008.
Existing Environment – SQL Servers
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLReporting01 runs SQL
Server 2008 R2 Reporting Services (SSRS). SQL Server on SQLReporting1 is configured to run in
Native Mode.
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLAnalysis01 runs SQL Server
2008 R2 Analysis Services (SSAS).
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLAnalysis02 runs SQL Server
2008 R2 Analysis Services (SSAS). SQLAnalysis01 and SQLAnalysis02 are configured as nodes
in a SQL Server active/passive failover cluster. SQLAnalysis01 is currently the active node in the
cluster.
Existing Environment – Databases
The SQL Server environment hosts the databases shown in the following table.

The databases have a full backup taken every day.
Existing Environment – Server Roles
SQLReporting01 contains 120 reports that are generated all day every day. The reports access
databases on the SSAS cluster for Sales and Production analysis. The reports are also used for
data modeling by analysts in the Development department.
A domain user account named SQLReporting01acc is used by the SSRS service on
SQLReporting01.
Planned Changes.
The company plans to upgrade the SQL Servers to SQL Server 2012. You will be working with the
Systems Administrator perform the upgrade. Downtime of the SQL Servers must be minimized
during the upgrade.
Two new servers will be implemented before the current SQL Servers are upgraded.
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLReporting02 will be joined to
the domain and configured to run SQL Server 2008 R2 Reporting Services (SSRS).
SQLReporting02 will host snapshots of business critical reports to ensure their availability during
the upgrade. You will use Reporting Services file-only installation mode to install SSRS on
SQLReporting02 and then restore and configure copies of the Reporting Services databases from
SQLReporting01 from backups taken every night. The configuration of SQLReporting02 including
configuration files and custom assemblies will be manually synchronized with SQLReporting01.
A Windows Server 2012 server named SSAS2012 will be installed and configured to run SQL
Server 2012 Analysis Services. This server will be used as a disaster recovery server in the event
of problems occurring during the upgrade of the SSAS cluster. All databases on the SSAS cluster
will be copied to this server prior to the upgrade. You need to minimize administrative effort and
downtime when moving the databases to SSAS2012. Client applications that connect to SQL
Server 2012 Analysis Services will be tested using this server.
SQLAnalysis01 and SQLAnalysis02 have been prepared for the upgrade to SQL Server 2012 by
having the shared components and SQL Server 2012 prerequisites upgraded.
As part of the upgrade to SQL Server 2012 Analysis Services, the Production, Sales, Customers
and Human Resources databases will be converted to tabular BI Semantic Models (BISMs).
The Development database will be detached from the SSAS cluster and attached to SSAS2012 to
ensure that it is available for modeling during the upgrade.

Requirements:
Technical Requirements:
All databases on the SSAS cluster must be backed up prior to the upgrade. To minimize the
processing time taken to restore the backups, the backups need to include just the aggregations,
metadata and partitioning. You need to minimize the storage space and processing time used by
the backups.
A DR (Disaster Recovery) plan must be designed for SQLReporting01. In the event of a system
failure, the minimum components required for reports to be available must be recovered as quickly
as possible.
Security Requirements:
A company security policy has stated the following requirements:
Kerberos delegation must be used by SQLReporting01 for connections to databases on the SSAS
cluster.
Client computers connecting to SQLReporting01 must use the most secure level of domain
security.
Reports distributed by email must be secured using SSL.
Reporting and Analysis requirements
The company has stated the following reporting and analysis requirements for after the upgrade:
Company users need to be able to use the Microsoft Excel PivotTable client to perform ad-hoc
analysis of SSAS databases. To facilitate this, you must deploy a cached data model that will
source data from an OData feed.
*************************************

You are using SQL Server Management Studio (SSMS) to configure the backup for ABC
Solutions. You need to meet the technical requirements.
Which two backup options should you configure? (Choose two).

Topic 1, ABC Solutions
General Overview
You are the Senior Database Administrator (DBA) for a software development company named
ABC Solutions.
Existing Environment – Active Directory
The network consists of an Active Directory Domain Services (AD DS) forest that includes a single
domain named CharnTech.com
All domain controllers run Windows Server 2008 R2 Service Pack 1 (SP1). A number of domain
member servers have been upgraded to Windows Server 2012. The remaining member servers
run Windows Server 2008 R2 Service Pack 1 (SP1). The client computers run either Windows 8
Professional or Windows 7 Professional with Service Pack 1 (SP1).
The functional level of the domain is Windows Server 2008 R2 and the functional level of the
forest is Windows Server 2008.
Existing Environment – SQL Servers
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLReporting01 runs SQL
Server 2008 R2 Reporting Services (SSRS). SQL Server on SQLReporting1 is configured to run in
Native Mode.
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLAnalysis01 runs SQL Server
2008 R2 Analysis Services (SSAS).
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLAnalysis02 runs SQL Server
2008 R2 Analysis Services (SSAS). SQLAnalysis01 and SQLAnalysis02 are configured as nodes
in a SQL Server active/passive failover cluster. SQLAnalysis01 is currently the active node in the
cluster.
Existing Environment – Databases
The SQL Server environment hosts the databases shown in the following table.

The databases have a full backup taken every day.
Existing Environment – Server Roles
SQLReporting01 contains 120 reports that are generated all day every day. The reports access
databases on the SSAS cluster for Sales and Production analysis. The reports are also used for
data modeling by analysts in the Development department.
A domain user account named SQLReporting01acc is used by the SSRS service on
SQLReporting01.
Planned Changes.
The company plans to upgrade the SQL Servers to SQL Server 2012. You will be working with the
Systems Administrator perform the upgrade. Downtime of the SQL Servers must be minimized
during the upgrade.
Two new servers will be implemented before the current SQL Servers are upgraded.
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLReporting02 will be joined to
the domain and configured to run SQL Server 2008 R2 Reporting Services (SSRS).
SQLReporting02 will host snapshots of business critical reports to ensure their availability during
the upgrade. You will use Reporting Services file-only installation mode to install SSRS on
SQLReporting02 and then restore and configure copies of the Reporting Services databases from
SQLReporting01 from backups taken every night. The configuration of SQLReporting02 including
configuration files and custom assemblies will be manually synchronized with SQLReporting01.
A Windows Server 2012 server named SSAS2012 will be installed and configured to run SQL
Server 2012 Analysis Services. This server will be used as a disaster recovery server in the event
of problems occurring during the upgrade of the SSAS cluster. All databases on the SSAS cluster
will be copied to this server prior to the upgrade. You need to minimize administrative effort and
downtime when moving the databases to SSAS2012. Client applications that connect to SQL
Server 2012 Analysis Services will be tested using this server.
SQLAnalysis01 and SQLAnalysis02 have been prepared for the upgrade to SQL Server 2012 by
having the shared components and SQL Server 2012 prerequisites upgraded.
As part of the upgrade to SQL Server 2012 Analysis Services, the Production, Sales, Customers
and Human Resources databases will be converted to tabular BI Semantic Models (BISMs).
The Development database will be detached from the SSAS cluster and attached to SSAS2012 to
ensure that it is available for modeling during the upgrade.

Requirements:
Technical Requirements:
All databases on the SSAS cluster must be backed up prior to the upgrade. To minimize the
processing time taken to restore the backups, the backups need to include just the aggregations,
metadata and partitioning. You need to minimize the storage space and processing time used by
the backups.
A DR (Disaster Recovery) plan must be designed for SQLReporting01. In the event of a system
failure, the minimum components required for reports to be available must be recovered as quickly
as possible.
Security Requirements:
A company security policy has stated the following requirements:
Kerberos delegation must be used by SQLReporting01 for connections to databases on the SSAS
cluster.
Client computers connecting to SQLReporting01 must use the most secure level of domain
security.
Reports distributed by email must be secured using SSL.
Reporting and Analysis requirements
The company has stated the following reporting and analysis requirements for after the upgrade:
Company users need to be able to use the Microsoft Excel PivotTable client to perform ad-hoc
analysis of SSAS databases. To facilitate this, you must deploy a cached data model that will
source data from an OData feed.
*************************************

You need to convert the Production, Sales, Customers and Human Resources databases to
tabular BI Semantic Models (BISMs).
Which two of the following actions should you perform? (Choose two)

Topic 1, ABC Solutions
General Overview
You are the Senior Database Administrator (DBA) for a software development company named
ABC Solutions.
Existing Environment – Active Directory
The network consists of an Active Directory Domain Services (AD DS) forest that includes a single
domain named CharnTech.com
All domain controllers run Windows Server 2008 R2 Service Pack 1 (SP1). A number of domain
member servers have been upgraded to Windows Server 2012. The remaining member servers
run Windows Server 2008 R2 Service Pack 1 (SP1). The client computers run either Windows 8
Professional or Windows 7 Professional with Service Pack 1 (SP1).
The functional level of the domain is Windows Server 2008 R2 and the functional level of the
forest is Windows Server 2008.
Existing Environment – SQL Servers
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLReporting01 runs SQL
Server 2008 R2 Reporting Services (SSRS). SQL Server on SQLReporting1 is configured to run in
Native Mode.
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLAnalysis01 runs SQL Server
2008 R2 Analysis Services (SSAS).
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLAnalysis02 runs SQL Server
2008 R2 Analysis Services (SSAS). SQLAnalysis01 and SQLAnalysis02 are configured as nodes
in a SQL Server active/passive failover cluster. SQLAnalysis01 is currently the active node in the
cluster.
Existing Environment – Databases
The SQL Server environment hosts the databases shown in the following table.

The databases have a full backup taken every day.
Existing Environment – Server Roles
SQLReporting01 contains 120 reports that are generated all day every day. The reports access
databases on the SSAS cluster for Sales and Production analysis. The reports are also used for
data modeling by analysts in the Development department.
A domain user account named SQLReporting01acc is used by the SSRS service on
SQLReporting01.
Planned Changes.
The company plans to upgrade the SQL Servers to SQL Server 2012. You will be working with the
Systems Administrator perform the upgrade. Downtime of the SQL Servers must be minimized
during the upgrade.
Two new servers will be implemented before the current SQL Servers are upgraded.
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLReporting02 will be joined to
the domain and configured to run SQL Server 2008 R2 Reporting Services (SSRS).
SQLReporting02 will host snapshots of business critical reports to ensure their availability during
the upgrade. You will use Reporting Services file-only installation mode to install SSRS on
SQLReporting02 and then restore and configure copies of the Reporting Services databases from
SQLReporting01 from backups taken every night. The configuration of SQLReporting02 including
configuration files and custom assemblies will be manually synchronized with SQLReporting01.
A Windows Server 2012 server named SSAS2012 will be installed and configured to run SQL
Server 2012 Analysis Services. This server will be used as a disaster recovery server in the event
of problems occurring during the upgrade of the SSAS cluster. All databases on the SSAS cluster
will be copied to this server prior to the upgrade. You need to minimize administrative effort and
downtime when moving the databases to SSAS2012. Client applications that connect to SQL
Server 2012 Analysis Services will be tested using this server.
SQLAnalysis01 and SQLAnalysis02 have been prepared for the upgrade to SQL Server 2012 by
having the shared components and SQL Server 2012 prerequisites upgraded.
As part of the upgrade to SQL Server 2012 Analysis Services, the Production, Sales, Customers
and Human Resources databases will be converted to tabular BI Semantic Models (BISMs).
The Development database will be detached from the SSAS cluster and attached to SSAS2012 to
ensure that it is available for modeling during the upgrade.

Requirements:
Technical Requirements:
All databases on the SSAS cluster must be backed up prior to the upgrade. To minimize the
processing time taken to restore the backups, the backups need to include just the aggregations,
metadata and partitioning. You need to minimize the storage space and processing time used by
the backups.
A DR (Disaster Recovery) plan must be designed for SQLReporting01. In the event of a system
failure, the minimum components required for reports to be available must be recovered as quickly
as possible.
Security Requirements:
A company security policy has stated the following requirements:
Kerberos delegation must be used by SQLReporting01 for connections to databases on the SSAS
cluster.
Client computers connecting to SQLReporting01 must use the most secure level of domain
security.
Reports distributed by email must be secured using SSL.
Reporting and Analysis requirements
The company has stated the following reporting and analysis requirements for after the upgrade:
Company users need to be able to use the Microsoft Excel PivotTable client to perform ad-hoc
analysis of SSAS databases. To facilitate this, you must deploy a cached data model that will
source data from an OData feed.
*************************************

ABC users report that they are not receiving report subscriptions from SQLReporting01.
You confirm that the report subscriptions are not being delivered.
Which of the following actions should you perform to resolve the issue?

Topic 1, ABC Solutions
General Overview
You are the Senior Database Administrator (DBA) for a software development company named
ABC Solutions.
Existing Environment – Active Directory
The network consists of an Active Directory Domain Services (AD DS) forest that includes a single
domain named CharnTech.com
All domain controllers run Windows Server 2008 R2 Service Pack 1 (SP1). A number of domain
member servers have been upgraded to Windows Server 2012. The remaining member servers
run Windows Server 2008 R2 Service Pack 1 (SP1). The client computers run either Windows 8
Professional or Windows 7 Professional with Service Pack 1 (SP1).
The functional level of the domain is Windows Server 2008 R2 and the functional level of the
forest is Windows Server 2008.
Existing Environment – SQL Servers
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLReporting01 runs SQL
Server 2008 R2 Reporting Services (SSRS). SQL Server on SQLReporting1 is configured to run in
Native Mode.
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLAnalysis01 runs SQL Server
2008 R2 Analysis Services (SSAS).
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLAnalysis02 runs SQL Server
2008 R2 Analysis Services (SSAS). SQLAnalysis01 and SQLAnalysis02 are configured as nodes
in a SQL Server active/passive failover cluster. SQLAnalysis01 is currently the active node in the
cluster.
Existing Environment – Databases
The SQL Server environment hosts the databases shown in the following table.

The databases have a full backup taken every day.
Existing Environment – Server Roles
SQLReporting01 contains 120 reports that are generated all day every day. The reports access
databases on the SSAS cluster for Sales and Production analysis. The reports are also used for
data modeling by analysts in the Development department.
A domain user account named SQLReporting01acc is used by the SSRS service on
SQLReporting01.
Planned Changes.
The company plans to upgrade the SQL Servers to SQL Server 2012. You will be working with the
Systems Administrator perform the upgrade. Downtime of the SQL Servers must be minimized
during the upgrade.
Two new servers will be implemented before the current SQL Servers are upgraded.
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLReporting02 will be joined to
the domain and configured to run SQL Server 2008 R2 Reporting Services (SSRS).
SQLReporting02 will host snapshots of business critical reports to ensure their availability during
the upgrade. You will use Reporting Services file-only installation mode to install SSRS on
SQLReporting02 and then restore and configure copies of the Reporting Services databases from
SQLReporting01 from backups taken every night. The configuration of SQLReporting02 including
configuration files and custom assemblies will be manually synchronized with SQLReporting01.
A Windows Server 2012 server named SSAS2012 will be installed and configured to run SQL
Server 2012 Analysis Services. This server will be used as a disaster recovery server in the event
of problems occurring during the upgrade of the SSAS cluster. All databases on the SSAS cluster
will be copied to this server prior to the upgrade. You need to minimize administrative effort and
downtime when moving the databases to SSAS2012. Client applications that connect to SQL
Server 2012 Analysis Services will be tested using this server.
SQLAnalysis01 and SQLAnalysis02 have been prepared for the upgrade to SQL Server 2012 by
having the shared components and SQL Server 2012 prerequisites upgraded.
As part of the upgrade to SQL Server 2012 Analysis Services, the Production, Sales, Customers
and Human Resources databases will be converted to tabular BI Semantic Models (BISMs).
The Development database will be detached from the SSAS cluster and attached to SSAS2012 to
ensure that it is available for modeling during the upgrade.

Requirements:
Technical Requirements:
All databases on the SSAS cluster must be backed up prior to the upgrade. To minimize the
processing time taken to restore the backups, the backups need to include just the aggregations,
metadata and partitioning. You need to minimize the storage space and processing time used by
the backups.
A DR (Disaster Recovery) plan must be designed for SQLReporting01. In the event of a system
failure, the minimum components required for reports to be available must be recovered as quickly
as possible.
Security Requirements:
A company security policy has stated the following requirements:
Kerberos delegation must be used by SQLReporting01 for connections to databases on the SSAS
cluster.
Client computers connecting to SQLReporting01 must use the most secure level of domain
security.
Reports distributed by email must be secured using SSL.
Reporting and Analysis requirements
The company has stated the following reporting and analysis requirements for after the upgrade:
Company users need to be able to use the Microsoft Excel PivotTable client to perform ad-hoc
analysis of SSAS databases. To facilitate this, you must deploy a cached data model that will
source data from an OData feed.
*************************************

You need to make the SSAS databases available on SSAS2012 to enable testing from client
applications. Your solution must minimize server downtime and maximize database
availability.
What should you do?

Topic 1, ABC Solutions
General Overview
You are the Senior Database Administrator (DBA) for a software development company named
ABC Solutions.
Existing Environment – Active Directory
The network consists of an Active Directory Domain Services (AD DS) forest that includes a single
domain named CharnTech.com
All domain controllers run Windows Server 2008 R2 Service Pack 1 (SP1). A number of domain
member servers have been upgraded to Windows Server 2012. The remaining member servers
run Windows Server 2008 R2 Service Pack 1 (SP1). The client computers run either Windows 8
Professional or Windows 7 Professional with Service Pack 1 (SP1).
The functional level of the domain is Windows Server 2008 R2 and the functional level of the
forest is Windows Server 2008.
Existing Environment – SQL Servers
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLReporting01 runs SQL
Server 2008 R2 Reporting Services (SSRS). SQL Server on SQLReporting1 is configured to run in
Native Mode.
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLAnalysis01 runs SQL Server
2008 R2 Analysis Services (SSAS).
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLAnalysis02 runs SQL Server
2008 R2 Analysis Services (SSAS). SQLAnalysis01 and SQLAnalysis02 are configured as nodes
in a SQL Server active/passive failover cluster. SQLAnalysis01 is currently the active node in the
cluster.
Existing Environment – Databases
The SQL Server environment hosts the databases shown in the following table.

The databases have a full backup taken every day.
Existing Environment – Server Roles
SQLReporting01 contains 120 reports that are generated all day every day. The reports access
databases on the SSAS cluster for Sales and Production analysis. The reports are also used for
data modeling by analysts in the Development department.
A domain user account named SQLReporting01acc is used by the SSRS service on
SQLReporting01.
Planned Changes.
The company plans to upgrade the SQL Servers to SQL Server 2012. You will be working with the
Systems Administrator perform the upgrade. Downtime of the SQL Servers must be minimized
during the upgrade.
Two new servers will be implemented before the current SQL Servers are upgraded.
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLReporting02 will be joined to
the domain and configured to run SQL Server 2008 R2 Reporting Services (SSRS).
SQLReporting02 will host snapshots of business critical reports to ensure their availability during
the upgrade. You will use Reporting Services file-only installation mode to install SSRS on
SQLReporting02 and then restore and configure copies of the Reporting Services databases from
SQLReporting01 from backups taken every night. The configuration of SQLReporting02 including
configuration files and custom assemblies will be manually synchronized with SQLReporting01.
A Windows Server 2012 server named SSAS2012 will be installed and configured to run SQL
Server 2012 Analysis Services. This server will be used as a disaster recovery server in the event
of problems occurring during the upgrade of the SSAS cluster. All databases on the SSAS cluster
will be copied to this server prior to the upgrade. You need to minimize administrative effort and
downtime when moving the databases to SSAS2012. Client applications that connect to SQL
Server 2012 Analysis Services will be tested using this server.
SQLAnalysis01 and SQLAnalysis02 have been prepared for the upgrade to SQL Server 2012 by
having the shared components and SQL Server 2012 prerequisites upgraded.
As part of the upgrade to SQL Server 2012 Analysis Services, the Production, Sales, Customers
and Human Resources databases will be converted to tabular BI Semantic Models (BISMs).
The Development database will be detached from the SSAS cluster and attached to SSAS2012 to
ensure that it is available for modeling during the upgrade.

Requirements:
Technical Requirements:
All databases on the SSAS cluster must be backed up prior to the upgrade. To minimize the
processing time taken to restore the backups, the backups need to include just the aggregations,
metadata and partitioning. You need to minimize the storage space and processing time used by
the backups.
A DR (Disaster Recovery) plan must be designed for SQLReporting01. In the event of a system
failure, the minimum components required for reports to be available must be recovered as quickly
as possible.
Security Requirements:
A company security policy has stated the following requirements:
Kerberos delegation must be used by SQLReporting01 for connections to databases on the SSAS
cluster.
Client computers connecting to SQLReporting01 must use the most secure level of domain
security.
Reports distributed by email must be secured using SSL.
Reporting and Analysis requirements
The company has stated the following reporting and analysis requirements for after the upgrade:
Company users need to be able to use the Microsoft Excel PivotTable client to perform ad-hoc
analysis of SSAS databases. To facilitate this, you must deploy a cached data model that will
source data from an OData feed.
*************************************

You need to create a BISM to meet the Reporting and Analysis requirements.
Which of the following should you include in your solution? (Choose all that apply)

Topic 1, ABC Solutions
General Overview
You are the Senior Database Administrator (DBA) for a software development company named
ABC Solutions.
Existing Environment – Active Directory
The network consists of an Active Directory Domain Services (AD DS) forest that includes a single
domain named CharnTech.com
All domain controllers run Windows Server 2008 R2 Service Pack 1 (SP1). A number of domain
member servers have been upgraded to Windows Server 2012. The remaining member servers
run Windows Server 2008 R2 Service Pack 1 (SP1). The client computers run either Windows 8
Professional or Windows 7 Professional with Service Pack 1 (SP1).
The functional level of the domain is Windows Server 2008 R2 and the functional level of the
forest is Windows Server 2008.
Existing Environment – SQL Servers
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLReporting01 runs SQL
Server 2008 R2 Reporting Services (SSRS). SQL Server on SQLReporting1 is configured to run in
Native Mode.
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLAnalysis01 runs SQL Server
2008 R2 Analysis Services (SSAS).
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLAnalysis02 runs SQL Server
2008 R2 Analysis Services (SSAS). SQLAnalysis01 and SQLAnalysis02 are configured as nodes
in a SQL Server active/passive failover cluster. SQLAnalysis01 is currently the active node in the
cluster.
Existing Environment – Databases
The SQL Server environment hosts the databases shown in the following table.

The databases have a full backup taken every day.
Existing Environment – Server Roles
SQLReporting01 contains 120 reports that are generated all day every day. The reports access
databases on the SSAS cluster for Sales and Production analysis. The reports are also used for
data modeling by analysts in the Development department.
A domain user account named SQLReporting01acc is used by the SSRS service on
SQLReporting01.
Planned Changes.
The company plans to upgrade the SQL Servers to SQL Server 2012. You will be working with the
Systems Administrator perform the upgrade. Downtime of the SQL Servers must be minimized
during the upgrade.
Two new servers will be implemented before the current SQL Servers are upgraded.
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLReporting02 will be joined to
the domain and configured to run SQL Server 2008 R2 Reporting Services (SSRS).
SQLReporting02 will host snapshots of business critical reports to ensure their availability during
the upgrade. You will use Reporting Services file-only installation mode to install SSRS on
SQLReporting02 and then restore and configure copies of the Reporting Services databases from
SQLReporting01 from backups taken every night. The configuration of SQLReporting02 including
configuration files and custom assemblies will be manually synchronized with SQLReporting01.
A Windows Server 2012 server named SSAS2012 will be installed and configured to run SQL
Server 2012 Analysis Services. This server will be used as a disaster recovery server in the event
of problems occurring during the upgrade of the SSAS cluster. All databases on the SSAS cluster
will be copied to this server prior to the upgrade. You need to minimize administrative effort and
downtime when moving the databases to SSAS2012. Client applications that connect to SQL
Server 2012 Analysis Services will be tested using this server.
SQLAnalysis01 and SQLAnalysis02 have been prepared for the upgrade to SQL Server 2012 by
having the shared components and SQL Server 2012 prerequisites upgraded.
As part of the upgrade to SQL Server 2012 Analysis Services, the Production, Sales, Customers
and Human Resources databases will be converted to tabular BI Semantic Models (BISMs).
The Development database will be detached from the SSAS cluster and attached to SSAS2012 to
ensure that it is available for modeling during the upgrade.

Requirements:
Technical Requirements:
All databases on the SSAS cluster must be backed up prior to the upgrade. To minimize the
processing time taken to restore the backups, the backups need to include just the aggregations,
metadata and partitioning. You need to minimize the storage space and processing time used by
the backups.
A DR (Disaster Recovery) plan must be designed for SQLReporting01. In the event of a system
failure, the minimum components required for reports to be available must be recovered as quickly
as possible.
Security Requirements:
A company security policy has stated the following requirements:
Kerberos delegation must be used by SQLReporting01 for connections to databases on the SSAS
cluster.
Client computers connecting to SQLReporting01 must use the most secure level of domain
security.
Reports distributed by email must be secured using SSL.
Reporting and Analysis requirements
The company has stated the following reporting and analysis requirements for after the upgrade:
Company users need to be able to use the Microsoft Excel PivotTable client to perform ad-hoc
analysis of SSAS databases. To facilitate this, you must deploy a cached data model that will
source data from an OData feed.
*************************************

You need to configure the servers to meet the security requirements for SQLReporting01
connections to the SSAS cluster. Downtime must be minimized during the configuration.
Which three of the following actions should you perform? (Choose three).

Topic 1, ABC Solutions
General Overview
You are the Senior Database Administrator (DBA) for a software development company named
ABC Solutions.
Existing Environment – Active Directory
The network consists of an Active Directory Domain Services (AD DS) forest that includes a single
domain named CharnTech.com
All domain controllers run Windows Server 2008 R2 Service Pack 1 (SP1). A number of domain
member servers have been upgraded to Windows Server 2012. The remaining member servers
run Windows Server 2008 R2 Service Pack 1 (SP1). The client computers run either Windows 8
Professional or Windows 7 Professional with Service Pack 1 (SP1).
The functional level of the domain is Windows Server 2008 R2 and the functional level of the
forest is Windows Server 2008.
Existing Environment – SQL Servers
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLReporting01 runs SQL
Server 2008 R2 Reporting Services (SSRS). SQL Server on SQLReporting1 is configured to run in
Native Mode.
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLAnalysis01 runs SQL Server
2008 R2 Analysis Services (SSAS).
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLAnalysis02 runs SQL Server
2008 R2 Analysis Services (SSAS). SQLAnalysis01 and SQLAnalysis02 are configured as nodes
in a SQL Server active/passive failover cluster. SQLAnalysis01 is currently the active node in the
cluster.
Existing Environment – Databases
The SQL Server environment hosts the databases shown in the following table.

The databases have a full backup taken every day.
Existing Environment – Server Roles
SQLReporting01 contains 120 reports that are generated all day every day. The reports access
databases on the SSAS cluster for Sales and Production analysis. The reports are also used for
data modeling by analysts in the Development department.
A domain user account named SQLReporting01acc is used by the SSRS service on
SQLReporting01.
Planned Changes.
The company plans to upgrade the SQL Servers to SQL Server 2012. You will be working with the
Systems Administrator perform the upgrade. Downtime of the SQL Servers must be minimized
during the upgrade.
Two new servers will be implemented before the current SQL Servers are upgraded.
A Windows Server 2008 R2 Service Pack 1 (SP1) server named SQLReporting02 will be joined to
the domain and configured to run SQL Server 2008 R2 Reporting Services (SSRS).
SQLReporting02 will host snapshots of business critical reports to ensure their availability during
the upgrade. You will use Reporting Services file-only installation mode to install SSRS on
SQLReporting02 and then restore and configure copies of the Reporting Services databases from
SQLReporting01 from backups taken every night. The configuration of SQLReporting02 including
configuration files and custom assemblies will be manually synchronized with SQLReporting01.
A Windows Server 2012 server named SSAS2012 will be installed and configured to run SQL
Server 2012 Analysis Services. This server will be used as a disaster recovery server in the event
of problems occurring during the upgrade of the SSAS cluster. All databases on the SSAS cluster
will be copied to this server prior to the upgrade. You need to minimize administrative effort and
downtime when moving the databases to SSAS2012. Client applications that connect to SQL
Server 2012 Analysis Services will be tested using this server.
SQLAnalysis01 and SQLAnalysis02 have been prepared for the upgrade to SQL Server 2012 by
having the shared components and SQL Server 2012 prerequisites upgraded.
As part of the upgrade to SQL Server 2012 Analysis Services, the Production, Sales, Customers
and Human Resources databases will be converted to tabular BI Semantic Models (BISMs).
The Development database will be detached from the SSAS cluster and attached to SSAS2012 to
ensure that it is available for modeling during the upgrade.

Requirements:
Technical Requirements:
All databases on the SSAS cluster must be backed up prior to the upgrade. To minimize the
processing time taken to restore the backups, the backups need to include just the aggregations,
metadata and partitioning. You need to minimize the storage space and processing time used by
the backups.
A DR (Disaster Recovery) plan must be designed for SQLReporting01. In the event of a system
failure, the minimum components required for reports to be available must be recovered as quickly
as possible.
Security Requirements:
A company security policy has stated the following requirements:
Kerberos delegation must be used by SQLReporting01 for connections to databases on the SSAS
cluster.
Client computers connecting to SQLReporting01 must use the most secure level of domain
security.
Reports distributed by email must be secured using SSL.
Reporting and Analysis requirements
The company has stated the following reporting and analysis requirements for after the upgrade:
Company users need to be able to use the Microsoft Excel PivotTable client to perform ad-hoc
analysis of SSAS databases. To facilitate this, you must deploy a cached data model that will
source data from an OData feed.
*************************************

You modify the ReportingServicesService.exe.config file on the reporting servers to enable
logging.
Which log contains the ClientIP and ServerPort fields to determine which IP address and
port numbers are used to connect to the reports server?

Topic 2, Westbridge Industries
General Overview
You have been hired as a Data Architect by a company named Westbridge Industries.
The company has recently hired a team of Business Analysts to analyze and report on sales and
financial data trends. You have been hired to design and implement a data warehouse and cube
to aid the Business Analysts in their reporting and data analysis.
Existing Environment – SQL Servers
DB1: A Windows Server 2012 server named DB1 runs SQL Server 2012 Enterprise Edition.
DB1 hosts the following SQL Server roles:
SQL Server Database Engine (single default instance)
DB2: A Windows Server 2012 server named DB2 runs SQL Server 2012 Enterprise Edition. This
server will be used to host the data warehouse and the cube.
DB2 hosts the following SQL Server roles:
SQL Server Database Engine (single default instance).
SQL Server Reporting Services (SSRS)
SQL Server Integration Services (SSIS)
SQL Server Analysis Services (SSAS) in multidimensional mode
DB3: A Windows Server 2012 server named DB3 runs SQL Server 2012 Enterprise Edition.
This server will be used as a scale-out server when the number of SSAS users on DB2 reaches a
specified limit.
DB3 hosts the following SQL Server roles:
SQL Server Analysis Services (SSAS) in multidimensional mode
Existing Environment – Databases
All production databases are hosted on DB1. The main Sales and Financial database is named
CorpDB. This is the database that will serve as the data source for the data warehouse.
The CorpDB database has one large table and several small tables. The large table is named
Orders and contains information about every order processed by the company in the last 5 years.
The Orders table is nearly 1 TB in size and is partitioned by month. The Orders table is anticipated
to expand to 3 TB.
CorpDB includes the following smaller tables: ProductName, ProductType, Customers,
SalesRegion, SalesPerson and SalesRegionFilter. Each of these tables consists of a single
partition and is less than 10MB in size.
Access to database information will be restricted to company users and sales people based on
Sales Region. The SalesRegionFilter table lists the regions that each user is permitted to access.
Cube Requirements
The company has identified the following requirements for the cube:
An SSIS package must be used to process the cube.
The time taken to respond to queries must be minimized.

Ad-hoc reporting and analysis must be possible.
Disk space used by the cube must be minimized.
The cube must contain data from the prior day up to 7:00 P.M.
To ensure redundancy and availability, a copy of the cube must exist and be available on both
DB2 and DB3.
A product dimension containing a hierarchy of product name and product type will be added to the
cube.
The cube will store only aggregations of the Orders table due to the large size of the table. The
detailed Orders data will be stored in the data warehouse.
The data warehouse will be the only data source for the cube.
When the cube is initially deployed, it should include aggregation designs.
The cube data must be available for reports when the office opens at 9:00 A.M.
The most current information available must be returned in the reports.
Microsoft SharePoint Server 2010 PerformancePoint Services, Microsoft Excel and SQL Server
Reporting Services (SSRS) will be used to access the cube.
Date Warehouse Requirements
The company has identified the following requirements for the data warehouse:
Disk space used by the data warehouse must be minimized.
The table design of the data warehouse should be as denormalized as possible.
The schema of the data warehouse must be a star design.
The data warehouse tables will be directly accessed by the Business Analysts.
Security must be configured to ensure that Order queries return data relevant to only the sales
regions that the users are permitted to access.
ETL Process Requirements
The company has identified the following requirements for the Extract, Transform and Load (ETL)
process:
The data warehouse will be updated by an ETL process that runs overnight. The ETL process
must start no earlier than 7:00 P.M. and finish no later than 4:00 A.M. the following morning.
A single project containing multiple SSIS packages will be developed and used to load data in the
data warehouse. A database connection string that is set at execution time will be used by the
SSIS packages to connect to the CorpDB database. Development effort used to create the SSIS
packages must be minimized.
*******************************

One of the cube requirements states that the cube should include aggregation designs.
How should you meet this requirement?

Topic 2, Westbridge Industries
General Overview
You have been hired as a Data Architect by a company named Westbridge Industries.
The company has recently hired a team of Business Analysts to analyze and report on sales and
financial data trends. You have been hired to design and implement a data warehouse and cube
to aid the Business Analysts in their reporting and data analysis.
Existing Environment – SQL Servers
DB1: A Windows Server 2012 server named DB1 runs SQL Server 2012 Enterprise Edition.
DB1 hosts the following SQL Server roles:
SQL Server Database Engine (single default instance)
DB2: A Windows Server 2012 server named DB2 runs SQL Server 2012 Enterprise Edition. This
server will be used to host the data warehouse and the cube.
DB2 hosts the following SQL Server roles:
SQL Server Database Engine (single default instance).
SQL Server Reporting Services (SSRS)
SQL Server Integration Services (SSIS)
SQL Server Analysis Services (SSAS) in multidimensional mode
DB3: A Windows Server 2012 server named DB3 runs SQL Server 2012 Enterprise Edition.
This server will be used as a scale-out server when the number of SSAS users on DB2 reaches a
specified limit.
DB3 hosts the following SQL Server roles:
SQL Server Analysis Services (SSAS) in multidimensional mode
Existing Environment – Databases
All production databases are hosted on DB1. The main Sales and Financial database is named
CorpDB. This is the database that will serve as the data source for the data warehouse.
The CorpDB database has one large table and several small tables. The large table is named
Orders and contains information about every order processed by the company in the last 5 years.
The Orders table is nearly 1 TB in size and is partitioned by month. The Orders table is anticipated
to expand to 3 TB.
CorpDB includes the following smaller tables: ProductName, ProductType, Customers,
SalesRegion, SalesPerson and SalesRegionFilter. Each of these tables consists of a single
partition and is less than 10MB in size.
Access to database information will be restricted to company users and sales people based on
Sales Region. The SalesRegionFilter table lists the regions that each user is permitted to access.
Cube Requirements
The company has identified the following requirements for the cube:
An SSIS package must be used to process the cube.
The time taken to respond to queries must be minimized.

Ad-hoc reporting and analysis must be possible.
Disk space used by the cube must be minimized.
The cube must contain data from the prior day up to 7:00 P.M.
To ensure redundancy and availability, a copy of the cube must exist and be available on both
DB2 and DB3.
A product dimension containing a hierarchy of product name and product type will be added to the
cube.
The cube will store only aggregations of the Orders table due to the large size of the table. The
detailed Orders data will be stored in the data warehouse.
The data warehouse will be the only data source for the cube.
When the cube is initially deployed, it should include aggregation designs.
The cube data must be available for reports when the office opens at 9:00 A.M.
The most current information available must be returned in the reports.
Microsoft SharePoint Server 2010 PerformancePoint Services, Microsoft Excel and SQL Server
Reporting Services (SSRS) will be used to access the cube.
Date Warehouse Requirements
The company has identified the following requirements for the data warehouse:
Disk space used by the data warehouse must be minimized.
The table design of the data warehouse should be as denormalized as possible.
The schema of the data warehouse must be a star design.
The data warehouse tables will be directly accessed by the Business Analysts.
Security must be configured to ensure that Order queries return data relevant to only the sales
regions that the users are permitted to access.
ETL Process Requirements
The company has identified the following requirements for the Extract, Transform and Load (ETL)
process:
The data warehouse will be updated by an ETL process that runs overnight. The ETL process
must start no earlier than 7:00 P.M. and finish no later than 4:00 A.M. the following morning.
A single project containing multiple SSIS packages will be developed and used to load data in the
data warehouse. A database connection string that is set at execution time will be used by the
SSIS packages to connect to the CorpDB database. Development effort used to create the SSIS
packages must be minimized.
*******************************

You need to configure the cube partitioning to manage the expected increase in size.
How should you configure the partitioning?

Topic 2, Westbridge Industries
General Overview
You have been hired as a Data Architect by a company named Westbridge Industries.
The company has recently hired a team of Business Analysts to analyze and report on sales and
financial data trends. You have been hired to design and implement a data warehouse and cube
to aid the Business Analysts in their reporting and data analysis.
Existing Environment – SQL Servers
DB1: A Windows Server 2012 server named DB1 runs SQL Server 2012 Enterprise Edition.
DB1 hosts the following SQL Server roles:
SQL Server Database Engine (single default instance)
DB2: A Windows Server 2012 server named DB2 runs SQL Server 2012 Enterprise Edition. This
server will be used to host the data warehouse and the cube.
DB2 hosts the following SQL Server roles:
SQL Server Database Engine (single default instance).
SQL Server Reporting Services (SSRS)
SQL Server Integration Services (SSIS)
SQL Server Analysis Services (SSAS) in multidimensional mode
DB3: A Windows Server 2012 server named DB3 runs SQL Server 2012 Enterprise Edition.
This server will be used as a scale-out server when the number of SSAS users on DB2 reaches a
specified limit.
DB3 hosts the following SQL Server roles:
SQL Server Analysis Services (SSAS) in multidimensional mode
Existing Environment – Databases
All production databases are hosted on DB1. The main Sales and Financial database is named
CorpDB. This is the database that will serve as the data source for the data warehouse.
The CorpDB database has one large table and several small tables. The large table is named
Orders and contains information about every order processed by the company in the last 5 years.
The Orders table is nearly 1 TB in size and is partitioned by month. The Orders table is anticipated
to expand to 3 TB.
CorpDB includes the following smaller tables: ProductName, ProductType, Customers,
SalesRegion, SalesPerson and SalesRegionFilter. Each of these tables consists of a single
partition and is less than 10MB in size.
Access to database information will be restricted to company users and sales people based on
Sales Region. The SalesRegionFilter table lists the regions that each user is permitted to access.
Cube Requirements
The company has identified the following requirements for the cube:
An SSIS package must be used to process the cube.
The time taken to respond to queries must be minimized.

Ad-hoc reporting and analysis must be possible.
Disk space used by the cube must be minimized.
The cube must contain data from the prior day up to 7:00 P.M.
To ensure redundancy and availability, a copy of the cube must exist and be available on both
DB2 and DB3.
A product dimension containing a hierarchy of product name and product type will be added to the
cube.
The cube will store only aggregations of the Orders table due to the large size of the table. The
detailed Orders data will be stored in the data warehouse.
The data warehouse will be the only data source for the cube.
When the cube is initially deployed, it should include aggregation designs.
The cube data must be available for reports when the office opens at 9:00 A.M.
The most current information available must be returned in the reports.
Microsoft SharePoint Server 2010 PerformancePoint Services, Microsoft Excel and SQL Server
Reporting Services (SSRS) will be used to access the cube.
Date Warehouse Requirements
The company has identified the following requirements for the data warehouse:
Disk space used by the data warehouse must be minimized.
The table design of the data warehouse should be as denormalized as possible.
The schema of the data warehouse must be a star design.
The data warehouse tables will be directly accessed by the Business Analysts.
Security must be configured to ensure that Order queries return data relevant to only the sales
regions that the users are permitted to access.
ETL Process Requirements
The company has identified the following requirements for the Extract, Transform and Load (ETL)
process:
The data warehouse will be updated by an ETL process that runs overnight. The ETL process
must start no earlier than 7:00 P.M. and finish no later than 4:00 A.M. the following morning.
A single project containing multiple SSIS packages will be developed and used to load data in the
data warehouse. A database connection string that is set at execution time will be used by the
SSIS packages to connect to the CorpDB database. Development effort used to create the SSIS
packages must be minimized.
*******************************

You need to configure the environment for the scale-out of SQL Server Analysis Services
(SSAS).
How should you meet this requirement?