Ensurepass

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.

 

70-467-demo-55

 

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.

     

     

    QUESTION 70

    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).

     

    1. Enable encryption of the backup file.

    2. Enable compression of the backup file.

    3. Disable encryption of the backup file.

    4. Disable compression of the backup file.

     

    Correct Answer: BC

     

     

    QUESTION 71

    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)

     

    1. You should select the tabular mode option when upgrading the databases using the Database Sync
      hronization Wizard.

    2. You should select the tabular mode destination option when copying the databases using SQL Server Integration Services (SSIS).

    3. You should select the tabular mode option during the installation of SQL Server Analysis Services.

    4. You should redevelop the projects and deploy them using SQL Server Data Tools (SSDT).

     

    Correct Answer: AD

     

     

    QUESTION 72

    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?

     

    1. You should run the SQL Server 2012 Setup executable on SQLReporting01 to generate a configuration file.

    2. You should reset the password of the SQL Server Service account.

    3. You should manually fail over the SSAS cluster.

    4. You should restore the ReportServer database on SQLReporting01.

     

    Correct Answer: C

     

     

    QUESTION 73

    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?

     

    1. You should run the SQL Server 2012 Upgrade Wizard to upgrade the active node of the

    2. SSAS cluster.

    3. You should start the SQL Server Agent on the active node of the SSAS cluster.

    4. You should restore the ReportServerTempDB database on SQLReporting01.

    5. You should start the SQL Server Agent on SQLReporting01.

     

    Correct Answer: D

     

     

    QUESTION 74

    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?

     

    1. You should detach the databases from the SSAS cluster by using SQL Server Management Studio (SSMS) then attach the databases on SSAS2012.

    2. You should copy the database files from the SSAS cluster to SSAS2012.

    3. You should export the databases from the SSAS cluster by using SQL Server Management Studio (SSMS) then import the databases on SSAS2012.

    4. You should restore a copy of the databases from the most recent backup.

     

    Correct Answer: D

     

     

    QUESTION 75

    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)

     

    1. Create a multidimensional project.

    2. Create a tabular project.

    3. Use the use hybrid OLAP (HOLAP) storage mode for the cube.

    4. Set the model DirectQuery mode to Off.

    5. Set the model DirectQuery mode to On.

    6. Select DirectQuery for the project query mode.

    7. Select In-Memory with DirectQuery for the project query mode.

     

    Correct Answer: BEG

     

     

    QUESTION 76

    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).

     

    1. Set the authentication type option to Custom on SQLReporting01.

    2. Restart the SQL Server service on SQLReporting01.

    3. Restart the IIS Server service on SQLReporting01.

    4. Register a service principle name (SPN) with Active Directory for the Reports Server service.

    5. Set the authentication type option to Negotiate on SQLReporting01.

    6. Register a service principle name (SPN) with Active Directory for the Analysis Services service.

     

    Correct Answer: CEF

     

     

    QUESTION 77

    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?

     

    1. The Windows System Application Log.

    2. The Report Server HTTP Log.

    3. The Report Server Service Trace Log.

    4. The Report Server Execution Log.

     

    Correct Answer: B

     

    Instant Access to Download Latest Complete Collection of Microsoft MCP 70-467 Real Exam

    Try Microsoft MCP 70-467 Free Demo

Comments are closed.