6.
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?
- A.Database Engine
- B.SQL Server Reporting Services
- C.SQL Server Analysis Services
- D.Client Tools SDK
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
|
A. Correct: Integration Services stores packages in an instance of the Database
Engine and uses SQL Server Agent for scheduling those packages. If you do not
have a local instance of the Database Engine, SSIS packages will run on the server
on which they were started. B. Incorrect: SSRS is not required to run SSIS packages locally on an ETL server that has SSIS installed. You must install a local instance of the Database Engine to run SSIS packages locally. C. Incorrect: SSAS is not required to run SSIS packages locally on an ETL server that has SSIS installed. You must install a local instance of the Database Engine to run SSIS packages locally. D. Incorrect: The Client Tools SDK is not required to run SSIS packages locally on an ETL server that has SSIS installed. You must install a local instance of the Database Engine to run SSIS packages locally. |
7.
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?
- A.Client Tools SDK
- B.Data Quality Client
- C.SQL Server Data Tools
- D.Client Tools Backwards Compatibility
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
|
A. Incorrect: The Client Tools SDK includes the software development kit that has
resources for programmers. It does not allow you to run SSIS packages in 32-bit
mode on a computer running a 64-bit operating system. B. Incorrect: The Data Quality Client allows you to perform data quality operations against Data Quality Server. You can’t use this feature to run SSIS packages in 32-bit mode on a computer running a 64-bit operating system. C. Correct: Installing the SQL Server Data Tools shared feature allows you to run SSIS packages in 32-bit mode on a computer running a 64-bit operating system. D. Incorrect: Client Tools Backwards Compatibility enables backward compatibility for packages created in previous versions of the product but does not enable you to run SSIS packages in 32-bit mode on a computer running a 64-bit operating system. |
8.
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?
- A.C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn \sqlservr.exe
- B.C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\bin \msmdsrv.exe
- C.C:\Program Files\Microsoft SQL Server\110\DTS\Binn\MsDtsSrvr.exe
- D.C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services \ReportServer\bin\ReportingServicesService.exe
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
|
A. Incorrect: This path is used by the Database Engine, not by Analysis Services. B. Correct: Use this path when configuring a program-based firewall rule for Analysis Services. C. Incorrect: This path is used by Integration Services, not by Analysis Services. D. Incorrect: This path is used by Reporting Services, not by Analysis Services. |
9.
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?
- A.SQL Server Management Studio
- B.SQL Server Configuration Manager
- C.Add/Remove Programs in Control Panel
- D.SQL Server Installation Center
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
|
A. Incorrect: You cannot use SQL Server Management Studio to remove installed
features from an SQL Server 2012 deployment. B. Incorrect: You cannot use SQL Server Configuration Manager to remove installed features from an SQL Server 2012 deployment. C. Correct: You use either Add/Remove Programs in Control Panel or the Setup.exe command-line utility to remove an installed feature. D. Incorrect: You cannot use SQL Server Installation Center to remove installed features from an SQL Server 2012 deployment. You can use SQL Server Installation Center to add new features to an existing deployment. |
10.
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?
- A.Configuration.xml
- B.Setup.ini
- C.Setup.xml
- D.ConfigurationFile.ini
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
|
A. Incorrect: SQL Server Setup generates a file named ConfigurationFile.ini to store
installation settings. Setup does not generate a file named Configuration.xml. B. Incorrect: SQL Server Setup generates a file named ConfigurationFile.ini to store installation settings. Setup does not generate a file named Setup.ini. C. Incorrect: SQL Server Setup generates a file named ConfigurationFile.ini to store installation settings. Setup does not generate a file named Setup.xml. D. Correct: SQL Server Setup generates a file named ConfigurationFile.ini to store installation settings. |
|
|
||||||||||||||||||||||||||||
