Enterprise Data Interview Questions

Enterprise Data interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 9

1. Which of the following tools is used for enterprise information management ?

A. SSAS

B. SSIS

C. SSRS

D. All of the mentioned

Correct Answer is : All of the mentioned

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

Correct Answer is : SSIS provides a powerful, extensible platform for integrating data from various sources

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

Correct Answer is : SSDT

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

Correct Answer is : The BIDS paradigm for developing reports is based on the concept of distributed queries

5. Key component that help you build an EIM solution is:

A. SSRS

B. SSAS

C. SSIS

D. All of the mentioned

Correct Answer is : SSIS

6. Which of the following data tools comes installed with SQL Server 2012 ?

A. SSAS

B. SSRS

C. DQS

D. All of the mentioned

Correct Answer is : All of the mentioned

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

Correct Answer is : Export members for your supporting entities

8. Creation of a Derived Hierarchy requires permission to

A. System Administration

B. DQS

C. syschema

D. None of the mentioned

Correct Answer is : System Administration

9. Users need _________ permission to create collection model object in MDS.

A. Delete

B. Create

C. Update

D. Read

Correct Answer is : Update

Enterprise Data interview questions