This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Enterprise Data Management”.
1. Which of the following tools is used for enterprise information management?
a) SSAS
b) SSIS
c) SSRS
d) All of the mentioned
View Answer
Explanation: SSAS, SSIS and SSRS are part of SQL Server Business Intelligence flagship product.
2. Point out the correct statement.
a) SSIS provides a powerful, extensible platform for integrating data from various sources
b) DQS provides a central data hub that ensures that the integrity of information and consistency of data is constant across different applications
c) MDS enables you to cleanse, match, standardize, and enrich data, so you can deliver trusted information for business intelligence, a data warehouse, and transaction processing workloads
d) None of the mentioned
View Answer
Explanation: SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.
3. Which of the following SQL Server tools is used to enhance data management and governance?
a) SSIT
b) SSDT
c) OBEII
d) All of the mentioned
View Answer
Explanation: SSDT stands for SQL Server Data Tools and is available for data management and quality.
4. Which is the more preferred way tool of effective data management strategy and decision making?
a) BIDS
b) SSMS
c) Excel
d) SSRS
View Answer
Explanation: Business Intelligence Development Studio (BIDS) is the former IDE from Microsoft, and was used to develop data analysis and Business Intelligence solutions.
5. Point out the wrong statement.
a) Spotlight is quality tool for SQL Server Enterprise
b) The BIDS paradigm for developing reports is based on the concept of distributed queries
c) GeoFlow is data management tool for SQL Server
d) All of the mentioned
View Answer
Explanation: The BIDS paradigm for developing reports is based on the concept of projects and solutions.
6. Key component that help you build an EIM solution is ____________
a) SSRS
b) SSAS
c) SSIS
d) All of the mentioned
View Answer
Explanation: SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration task.
7. Which of the following data tools comes installed with SQL Server 2012?
a) SSAS
b) SSRS
c) DQS
d) All of the mentioned
View Answer
Explanation: SQL Server data tools includes SSAS and SSRS.
8. Which of the following action cannot be performed with MDS?
a) Create entities
b) Create attributes for your entities
c) Export members for your supporting entities
d) All of the mentioned
View Answer
Explanation: Begin populating your master data by using the staging process. You may want to start by importing the members for your supporting entities.
9. Creation of a Derived Hierarchy requires permission to ___________
a) System Administration
b) DQS
c) syschema
d) None of the mentioned
View Answer
Explanation: In Master Data Services, create a derived hierarchy when you want a level-based hierarchy that ensures that members exist at the correct level.
10. Users need _________ permission to create collection model object in MDS.
a) Delete
b) Create
c) Update
d) Read
View Answer
Explanation: Users can create collections in Master Data Manager if they have a minimum of Update permission to the collection model object and access to the Explorer functional area.
Sanfoundry Global Education & Learning Series – SQL Server.
To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.
- Practice Programming MCQs
- Apply for Programming Internship
- Check SQL Server Books
- Check Information Technology Books
