21.
Which tool do you use to give a user access to Integration Services?
- A.SQL Server Management Studio
- B.SQL Server Configuration Manager
- C.SQL Server Data Tools
- D.DCOM Configuration Tool (Dcomcnfg.exe)
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
|
A. Incorrect. You cannot use SQL Server Management Studio to give a user access to
Integration Services. B. Incorrect. You cannot use SQL Server Configuration Manager to give a user access to Integration Services. C. Incorrect. SQL Server Data Tools enables you to create Analysis Services, Integration Services, and Report Server projects, but it cannot be used to give a user access to Integration Services. D. Correct. Dcomcnfg.exe is the tool you can use to give non-administrative users access to Integration Services. |
22.
Which tool do you use to change the Reporting Services execution account?
- A.SQL Server Management Studio
- B.Reporting Services Configuration Manager
- C.SQL Server Configuration Manager
- D.SQL Server Installation Center
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
|
A. Incorrect. You cannot use SQL Server Management Studio to change the
Reporting Services execution account. B. Correct. You use Reporting Services Configuration Manager to change the Reporting Services execution account. C. Incorrect. You cannot use SQL Server Configuration Manager to change the Reporting Services execution account. D. Incorrect. You cannot use SQL Server Installation Center to change the Reporting Services execution account. |
23.
What is the maximum number of full-text indexes that you can configure for a partitioned
table?
- A.1
- B.32
- C.1024
- D.2048
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
|
A. Correct. The maximum number of full-text indexes for a table is 1. B. Incorrect. The maximum number of full-text indexes for a table is 1. You cannot have 32 full-text indexes for a partitioned table. C. Incorrect. The maximum number of full-text indexes for a table is 1. You cannot have 1,024 full-text indexes for a partitioned table. D. Incorrect. The maximum number of full-text indexes for a table is 1. You cannot have 2,048 full-text indexes for a partitioned table. |
24.
Which of the following steps must you take to enable FILESTREAM on a SQL Server
2012 instance that has both the Database Engine and Analysis Services features
installed? (Each correct answer presents part of the solution. Choose two.)
- A.Edit the properties of the SQL Server service in SQL Server Configuration Manager.
- B.Edit the properties of the Analysis Services service in SQL Server Configuration Manager.
- C.Run sp_configure filestream_access_level, 2.
- D.Run sp_configure filestream_access_level, 0.
- Answer & Explanation
- Report
Answer : [A, C]
Explanation :
Explanation :
|
A. Correct. To enable FILESTREAM, you must edit the properties of the SQL Server
service in SQL Server Configuration Manager. B. Incorrect. You do not have to edit the properties of the Analysis Services service in SQL Server Configuration Manager to enable FILESTREAM. C. Correct. You must run the sp_configure filestream_access_level, X, with a non-zero value of X to enable FILESTREAM. D. Incorrect. Running sp_configure filestream_access_level, 0, disables FILESTREAM. |
25.
Which statement would you use to add a filegroup to an existing database?
- A.ALTER DATABASE
- B.CREATE DATABASE
- C.ALTER TABLE
- D.CREATE TABLE
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
|
A. Correct. You can add a filegroup to an existing database by using the ALTER
DATABASE statement. B. Incorrect. The CREATE DATABASE statement enables you to create a new database but not to alter an existing database. C. Incorrect. The ALTER TABLE statement enables you to modify a table but not a database. D. Incorrect. The CREATE TABLE statement enables you to create a table but not to modify a database. |
|
|
||||||||||||||||||||||||||||
