070-467 無料問題集「Microsoft Designing Business Intelligence Solutions with Microsoft SQL Server」
You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube.
The cube includes a Customer dimension that contains a Geography hierarchy and a Gender attribute hierarchy.
You need to return only the female customers in the Geography hierarchy.
Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
The cube includes a Customer dimension that contains a Geography hierarchy and a Gender attribute hierarchy.
You need to return only the female customers in the Geography hierarchy.
Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
正解：D
解答を投票する
You administer a SQL Server Reporting Services (SSRS) infrastructure. Data alerts are provisioned.
You need to monitor the number of report data feed processing events during every automated execution.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
You need to monitor the number of report data feed processing events during every automated execution.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
正解：
Explanation
Box 1:
Box 2:
Box 3:
Note:
* DeliverAlert
The runtime creates the data alert message and sends it to all recipients by email.
* GenerateAlert
The alerting runtime processes the report data feed, applies the rules specified in the data alert definition, determines whether to create an instance of the data alert, and if needed creates an instance of the data alert.
* Data Alert Manager lists alert definitions and error information that help information workers and alerting administrators understand why the failure occurred. Some common reasons for failure include:
The report data feed changed and columns that are used in the data alert definition rules are no longer included in the data feed.
Permission to view the report was revoked.
The data type in the underlying data source changed and the alert definition is no longer valid.
You are designing a self-service reporting solution based on published PowerPivot workbooks.
The reporting solution must allow users to perform the following tasks:
* Easily create reports.
* Create report queries by dragging and dropping fields.
* Create presentation-quality reports with minimal effort.
You need to choose a reporting tool that meets the requirements.
Which reporting tool should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)
The reporting solution must allow users to perform the following tasks:
* Easily create reports.
* Create report queries by dragging and dropping fields.
* Create presentation-quality reports with minimal effort.
You need to choose a reporting tool that meets the requirements.
Which reporting tool should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)
正解：B
解答を投票する
You are the administrator of a SQL Server Integration Services (SSIS) catalog. You have access to the original password that was used to create the SSIS catalog.
A full database backup of the SSISDB database on the production server is made each day. The server used for disaster recovery has an operational SSIS catalog.
Information that is encrypted in the SSISDB database must not be lost.
You need to document the disaster recovery solution that restores the production SSIS catalog to the disaster recovery server.
Which three steps should you document in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
A full database backup of the SSISDB database on the production server is made each day. The server used for disaster recovery has an operational SSIS catalog.
Information that is encrypted in the SSISDB database must not be lost.
You need to document the disaster recovery solution that restores the production SSIS catalog to the disaster recovery server.
Which three steps should you document in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解：
Explanation
Box 1: Restore the SSISDB database from the last backup.
Box 2: Restore the SSISDB master key.
Box 3: Open the SSISDB database master key
Note:
To Restore the SSIS Database
* Restore the SSISDB database from the backup by using the Restore Database dialog box in SQL Server Management Studio.
* Restore the master key (Use this method if you have the original password that was used to create SSISDB), open master key decryption by password = 'LS1Setup!' --'Password used when creating SSISDB'Alter Master Key Add encryption by Service Master Key
Your network contains a development environment, a staging environment, and a production environment.
You have a SQL Server Integration Services (SSIS) project. All of the packages in the project load data from files in a shared network folder. The packages use indirect XML configurations to set the location of the network folder.
The project is deployed to the three environments. Each environment has a different set of source files and a different network folder for the source files.
Currently, if an environment variable is missing, the package will use the network folder specified in the package, not the folder specified in the XML configuration file.
You need to ensure that each time a package is executed, the network folder location specified in the package is NOT used.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You have a SQL Server Integration Services (SSIS) project. All of the packages in the project load data from files in a shared network folder. The packages use indirect XML configurations to set the location of the network folder.
The project is deployed to the three environments. Each environment has a different set of source files and a different network folder for the source files.
Currently, if an environment variable is missing, the package will use the network folder specified in the package, not the folder specified in the XML configuration file.
You need to ensure that each time a package is executed, the network folder location specified in the package is NOT used.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解：
Explanation
Box 1:
Box 2:
Box 3:
You are the administrator of a SQL Server Integration Services (SSIS) catalog. You have access to the original password that was used to create the SSIS catalog.
A full database backup of the SSISDB database on the production server is made each day. The server used for disaster recovery has an operational SSIS catalog.
The production server that hosts the SSISDB database fails.
Sensitive data that is encrypted in the SSISDB database must not be lost.
You need to restore the production SSIS catalog to the disaster recovery server.
Which three steps should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
A full database backup of the SSISDB database on the production server is made each day. The server used for disaster recovery has an operational SSIS catalog.
The production server that hosts the SSISDB database fails.
Sensitive data that is encrypted in the SSISDB database must not be lost.
You need to restore the production SSIS catalog to the disaster recovery server.
Which three steps should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解：
Explanation
Box 1:
Box 2:
Box 3:
You have a Microsoft SharePoint Server 2013 deployment that contains a PowerPivot service application and a site that has a PowerPivot Gallery.
You need to recommend a solution to provide users with the ability to monitor usage and service health by using the built-in PowerPivot Management Dashboard. The solution must use the principle of least privilege.
Which permissions should you assign to the users?
You need to recommend a solution to provide users with the ability to monitor usage and service health by using the built-in PowerPivot Management Dashboard. The solution must use the principle of least privilege.
Which permissions should you assign to the users?
正解：C
解答を投票する