C249_Ch1

1.

1 point

You are planning on deploying a server that will be dedicated for ETL (Extraction, Transformation, and Loading) processes. You want to ensure that SSIS (SQL Server Integration Services) packages will run on this dedicated ETL server and not on any other server on which they were started. Which of the following features must you install on the ETL server in addition to SSIS to accomplish this goal?

SQL Server Reporting Services

SQL Server Analysis Services

Database Engine

Client Tools SDK

2.

1 point

You want to reproduce the same SQL Server 2012 installation configuration across five servers. Which of the following files will you generate by using SQL Server Setup to accomplish this goal?

Setup.xml

Configuration.xml

ConfigurationFile.ini

Setup.ini

3.

1 point

What is the minimum recommended amount of RAM for SQL Server 2012 Enterprise?

8 GB

2 GB

4 GB

512 MB

1 GB

4.

1 point

On which of the following operating systems can you deploy the 64-bit version of SQL Server 2012 Enterprise edition? (Choose all that apply.)

Windows Server 2008 SP2 (x64) Enterprise edition

Windows 7 Ultimate (x64) edition

Windows Server 2003 R2 (x64) Enterprise edition

Windows Server 2008 R2 SP1 (x64) Standard edition

5.

1 point

You have installed the SQL Server Integration Services (SSIS) feature on a server running Windows Server 2008 R2 SP1. Which of the following features must you install if you want to ensure that you can run packages in 32-bit mode?

SQL Server Data Tools

Data Quality Client

Client Tools SDK

Client Tools Backwards Compatibility

6.

1 point

Which of the following features can you install if you are installing SQL Server 2012 Enterprise edition on a computer running Windows Server 2008 R2 SP1 Enterprise edition in the Server Core configuration? (Choose all that apply.)

Analysis Services

SQL Server Replication

Reporting Services

Database Engine Services

7.

1 point

You want to simulate read, write, checkpoint, backup, sort, and read-ahead activities for your organization’s SQL Server 2012 deployment. Which of the following tools would you use to accomplish this goal?

SQLIOSim

SQLIOStress

chkdsk

SQLIO

8.

1 point

Which of the following editions of SQL Server 2012 can you run on a computer that is running the Windows 7 Professional (x64) operating system?
(Choose all that apply.)

SQL Server 2012 (x64) Standard edition

SQL Server 2012 (x64) Enterprise edition

SQL Server 2012 (x64) Web edition

SQL Server 2012 (x64) Developer edition

9.

1 point

What is the minimum recommended amount of RAM for SQL Server 2012 Express?

512 MB

2 GB

4 GB

1 GB

10.

1 point

You want to remove SQL Server Integration Services from a server running the
Windows Server 2008 R2 operating system that also has the Database Engine and SQL Server Analysis Services installed. Which of the following tools can you use to accomplish this goal?

SQL Server Management Studio

Add/Remove Programs in Control Panel

SQL Server Configuration Manager

SQL Server Installation Center

11.

1 point

You want to allow access to SQL Server Analysis Services on a server running Windows Server 2008 R2 for a client running SQL Server Management Studio on Windows 7. You have installed SQL Server Analysis Services in the default location. Which of the following paths should you use when creating the firewall rule by using Windows Firewall With Advanced Security?

C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn \sqlservr.exe

C:\Program Files\Microsoft SQL Server\110\DTS\Binn\MsDtsSrvr.exe

C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\bin \msmdsrv.exe

C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services \ReportServer\bin\ReportingServicesService.exe

C249_Ch1_L1