70-466 · Question #81
You need to deploy the StandardReports project at the end of the current business day. What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
The correct answer is C. Use the Analysis Services Deployment wizard to create an XMLA deployment script and run it at the end of the day.. Scheduling an Analysis Services deployment for a future time requires the Deployment Wizard to export an XMLA script, which can then be executed via SSMS or SQL Server Agent at the desired time.
Question
Options
- AUse the Analysis Services Deployment utility to create an XMLA deployment script and run it at the end of the day.
- BUse the Analysis Services Deployment wizard to create an MDX deployment script and run it at the end of the day.
- CUse the Analysis Services Deployment wizard to create an XMLA deployment script and run it at the end of the day.
- DDeploy the project from SQL Server Data Tools (SSDT) at the end of the day.
How the community answered
(25 responses)- A4% (1)
- B8% (2)
- C88% (22)
Why each option
Scheduling an Analysis Services deployment for a future time requires the Deployment Wizard to export an XMLA script, which can then be executed via SSMS or SQL Server Agent at the desired time.
While the Analysis Services Deployment utility can generate XMLA scripts from a command line, the correct tool for this wizard-based scripting scenario is the Deployment Wizard, not the utility - making A a distractor that references the wrong tool.
The Analysis Services Deployment Wizard generates XMLA scripts, not MDX scripts; MDX is a query language used to retrieve data from cubes and cannot serve as a deployment script format.
The Analysis Services Deployment Wizard includes an option to save the deployment as an XMLA script file rather than executing it immediately. This script can be stored and later executed in SSMS or scheduled via SQL Server Agent, making it the correct approach for a deferred end-of-day deployment.
SSDT's Deploy command initiates an immediate deployment at the moment it is invoked and does not offer a built-in scheduling mechanism to defer the deployment to a specific future time.
Concept tested: Deferred XMLA deployment script creation with Analysis Services Wizard
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.