MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
CREATION_OF_A_DERIVED_HIERARCHY_REQUIRES_PERMISSION_TO?$ |
| A. | System Administration |
| B. | DQS |
| C. | syschema |
| D. | None of the mentioned |
| Answer» B. DQS | |
| 2. |
Users_need___________permission_to_create_collection_model_object_in_MDS.$ |
| A. | Delete |
| B. | Create |
| C. | Update |
| D. | Read |
| Answer» D. Read | |
| 3. |
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 |
| Answer» D. All of the mentioned | |
| 4. |
Which of the following data tools comes installed with SQL Server 2012 ? |
| A. | SSAS |
| B. | SSRS |
| C. | DQS |
| D. | All of the mentioned |
| Answer» E. | |
| 5. |
Key component that help you build an EIM solution is: |
| A. | SSRS |
| B. | SSAS |
| C. | SSIS |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 6. |
Which is the more preferred way tool of effective data management strategy and decision making? |
| A. | BIDS |
| B. | SSMS |
| C. | Excel |
| D. | SSRS |
| Answer» B. SSMS | |
| 7. |
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 |
| Answer» C. OBEII | |
| 8. |
Which of the following tools is used for enterprise information management ? |
| A. | SSAS |
| B. | SSIS |
| C. | SSRS |
| D. | All of the mentioned |
| Answer» E. | |