70-466 · Question #80
You need to deploy the StandardReports project. What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
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.
Question
Exhibit
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.
How the community answered
(23 responses)- A91% (21)
- C4% (1)
- D4% (1)
Why each option
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.
SQL Server Data Tools includes a Deploy command that connects directly to the target Analysis Services instance and deploys the project in a single step, making it the correct choice for immediate deployment without any intermediate scripting or scheduling.
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.
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.
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
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/deploy-analysis-services-projects-ssdt
Topics
Community Discussion
No community discussion yet for this question.
