Which of the following actions should you take?
You are employed as a software tester at ABC.com. ABC.com has a single Active Directory
domain, named ABC.com. ABC.com makes use of Microsoft Test Manager (MTM) for testing
purposes.
You have created a test suite that only contains test cases that are not ready to be executed yet.
You are required to configure the state of the test suite.
Which of the following actions should you take?
Which of the following actions should you take?
You are employed as a developer at ABC.com. ABC.com has ABC.com has a single Active
Directory domain, named ABC.com. ABC.com makes use of Microsoft Visual Studio 2012 for
development purposes.
You have been tasked with developing a solution that allows for early user feedback, bug-free
software releases, and the most recent role specific best-of-breed tools.
Which of the following actions should you take?
You need to make the SSAS databases available on SSAS2012 to enable testing from client applications
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?
Which of the following actions should you take?
You are employed as a software tester at ABC.com. ABC.com has a single Active Directory
domain, named ABC.com. ABC.com makes use of Microsoft Test Manager (MTM) for testing
purposes.
You have been informed that ABC.com will not be supporting a certain configuration an application
that is currently being tested. You have been tasked with making sure that the test configuration
option cannot be accessed in a test plan.
Which of the following actions should you take?
Which of the following is an action you should also take?
You are employed as a developer at ABC.com. ABC.com has ABC.com has a single Active
Directory domain, named ABC.com. ABC.com makes use of Microsoft Visual Studio 2012 for
development purposes.
ABC.com’s business analysts provide the development team with substantial, exceedingly
thorough requirements specifications. When certain business analysts complain that developers
are not meeting these requirements, you are instructed to make sure that requirements
management and delivery is strengthened.
You are planning to gather feedback from the business analysts on a regular basis using the
Feedback Manager tool.
Which of the following is an action you should also take?
Which of the following is TRUE with regards to static test suites?
You are employed as a software tester at ABC.com. ABC.com has a single Active Directory
domain, named ABC.com. ABC.com makes use of Microsoft Test Manager (MTM) for testing
purposes.
You have recently created a query-based test suite.
Which of the following is TRUE with regards to static test suites?
Which of the following actions should you take?
You are employed as a developer at ABC.com. ABC.com has ABC.com has a single Active
Directory domain, named ABC.com. ABC.com makes use of Microsoft Visual Studio 2012 for
development purposes.
You have been assigned as the project manager of a new ABC.com application development
project. You are preparing to illustrate requirements for the project.
Which of the following actions should you take?
Which of the following actions should you take?
You are employed as a software tester at ABC.com. ABC.com has a single Active Directory
domain, named ABC.com. ABC.com makes use of Microsoft Test Manager (MTM) for testing
purposes.
You have been instructed to make sure that only the test plans that are being used at present are
shown in the list that is displayed when the Home button is selected. The list is at this point in time
very long as a result of outdated test plans.
Which of the following actions should you take?
Which of the following can be ascertained by viewing this report?
You are employed as a developer at ABC.com. ABC.com has ABC.com has a single Active
Directory domain, named ABC.com. ABC.com makes use of Microsoft Visual Studio 2012 for
development purposes.
ABC.com is making use of Scrum as the process framework for new projects. You have opened
the Sprint Burndown report.
Which of the following can be ascertained by viewing this report? (Choose all that apply.)
Which of the following should you include in your solution?
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)