Microsoft
70-466 · Question #80
70-466 Question #80: Real Exam Question with Answer & Explanation
The correct answer is A: Deploy the project from SQL Server Data Tools (SSDT).. Deploying an Analysis Services project immediately is done directly from SSDT using its built-in Deploy command. Creating a deployment script via the wizard is a deferred method, not an immediate one.
Configure and maintain an analysis services database
Question
You need to deploy the StandardReports project. What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
Options
- ADeploy the project from SQL Server Data Tools (SSDT).
- BUse the Analysis Services Deployment utility to create an XMLA deployment script.
- CUse the Analysis Services Deployment wizard to create an MDX deployment script.
- DUse the Analysis Services Deployment wizard to create an XMLA deployment script.
Explanation
Deploying an Analysis Services project immediately is done directly from SSDT using its built-in Deploy command. Creating a deployment script via the wizard is a deferred method, not an immediate one.
Common mistakes.
- B. The Analysis Services Deployment utility generates a command-line XMLA script but does not directly execute the deployment - a separate step is still required to run the script against the server.
- C. The Analysis Services Deployment wizard generates XMLA scripts, not MDX scripts; MDX is a query and expression language and has no role in Analysis Services deployment scripting.
- D. The Analysis Services Deployment wizard saves an XMLA script to disk but does not execute the deployment automatically; running that script against the server is a separate manual step.
Concept tested. Immediate Analysis Services project deployment from SSDT
Topics
#SSAS deployment#XMLA deployment script#SSDT deployment#Analysis Services Deployment wizard
Community Discussion
No community discussion yet for this question.