Developing SQL Data Models — Question 25

You are responsible for installing new database server instances.
You must install Microsoft SQL Server Analysis Services (SSAS) to support deployment of the following projects. You develop both projects by using SQL Server
Data Tools.
✑ Project1 uses the tabular data model.
✑ Project2 uses SQL Server data mining to predict customer-purchasing intentions by using the Decision Trees algorithm.
You need to install the appropriate services to support both projects.
Which two actions should you perform? Each correct answer presents part of the solution.

Answer options

• A. Install one tabular instance of SSAS and enable the Data Mining Extensions.
• B. Install one multidimensional instance of SSAS.
• C. Install one tabular instance of SSAS.
• D. Install a multidimensional instance and a Power Pivot instance of SSAS on the same server.
• E. Install two separate tabular instances of SSAS.

Correct answer: B, C

Explanation

The correct answers are B and C. Installing a multidimensional instance of SSAS (B) is necessary to support the data mining capabilities required by Project2, while installing a tabular instance of SSAS (C) is essential for Project1's tabular data model. The other options either do not provide the necessary support for both project types or are redundant, such as installing multiple instances of the same type.