最新的Microsoft Designing Business Intelligence Solutions with Microsoft SQL Server - 70-467免費考試真題
You are designing a self-service reporting solution based on SQL Server Analysis Services (SSAS) tabular data models. 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.
* 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.
正確答案: C
You need to identify the reasons that data alert notifications are not being sent.
Which of the following reasons are possible? (Each correct answer presents a complete solution. Choose al that apply.)
Which of the following reasons are possible? (Each correct answer presents a complete solution. Choose al that apply.)
正確答案: D,E
說明：（僅 Fast2test 成員可見）
You are designing a SQL Server Reporting Services (SSRS) solution.
An existing report aggregates data from a SQL Azure database in a chart.
You need to use the chart in a new report and ensure that other users can use the chart in their reports.
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,)
An existing report aggregates data from a SQL Azure database in a chart.
You need to use the chart in a new report and ensure that other users can use the chart in their reports.
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:
* In Report Designer, after you create tables, charts, and other report items in a project, you can publish them asreport partsto a report server or SharePoint site integrated with a report server so that you and others can reuse them in other reports.
* . By using Report Builder, you can customize and update reports that were created in SQL Server Data Tools (SSDT) Report Designer.
* InReport Builder, IT pros and power users can create powerful operational reports, and reusable report parts and shared datasets.
Incorrect:
* (incorrect) Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and presentation experience. It provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from data models based on PowerPivot workbooks published in a PowerPivot Gallery, or tabular models deployed to SQL Server 2012 Analysis Services (SSAS) instances. Power View is a browser-based Silverlight application launched from SharePoint Server 2010 that enables users to present and share insights with others in their organization through interactive presentations.
Reference: Getting Started with Report Builder
Reference: Report Parts in Report Designer (SSRS)
You have a SQL Server Reporting Services (SSRS) 2012 instance integrated with a Microsoft SharePoint
2010 farm.
You need to upgrade to SSRS 2014 with the minimum downtime and hardware requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
2010 farm.
You need to upgrade to SSRS 2014 with the minimum downtime and hardware requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
正確答案: D
說明：（僅 Fast2test 成員可見）
You have a business intelligence (BI) solution that uses SQL Server Integration Services (SSIS). The BI solution includes an extract transformation, and load (ETL) system.
You are designing a logging and auditing strategy for the ETL system.
You need to ensure that an ETL administrator can view the row counts of any data flow path for each package 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 are designing a logging and auditing strategy for the ETL system.
You need to ensure that an ETL administrator can view the row counts of any data flow path for each package 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:
You need to recommend a partitioning strategy that meets the performance requirements for CUBE1.
What should you include in the recommendation?
What should you include in the recommendation?
正確答案: B
You are designing a multidimensional OLAP (MOLAP) cube.
The MOLAP cube must meet the following requirements:
* Ensure that workloads for aggregation tuning can be automatically collected.
* Require the least amount of effort to perform manual aggregation tuning.
* Minimize impact on the performance of previously tuned queries.
You need to design a MOLAP cube that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
The MOLAP cube must meet the following requirements:
* Ensure that workloads for aggregation tuning can be automatically collected.
* Require the least amount of effort to perform manual aggregation tuning.
* Minimize impact on the performance of previously tuned queries.
You need to design a MOLAP cube that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
正確答案: A
You have a SQL Server data warehouse. The data warehouse contains four tables configured as shown in the following table.
The appropriate foreign key relationships exist. Each account can be associated with one or more patients, and each patient can be associated with one or more accounts.
You need to recommend a design for a SQL Server Analysis Services (SSAS) multidimensional cube. The cube must provide you with the ability to sum office visits by patient for each of their accounts, or by account for all of the patients associated with that account.
What should you recommend? To answer, select the appropriate options in the answer area.
The appropriate foreign key relationships exist. Each account can be associated with one or more patients, and each patient can be associated with one or more accounts.
You need to recommend a design for a SQL Server Analysis Services (SSAS) multidimensional cube. The cube must provide you with the ability to sum office visits by patient for each of their accounts, or by account for all of the patients associated with that account.
What should you recommend? To answer, select the appropriate options in the answer area.
正確答案:
You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report.
You have an application that populates a table with user-specific subscription schedules and report formats.
You need to ensure that users can receive reports by email according to their preferences.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You have an application that populates a table with user-specific subscription schedules and report formats.
You need to ensure that users can receive reports by email according to their preferences.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
正確答案: D
You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report.
You have an application that populates a table with user-specific subscription schedules and report formats.
You need to ensure that users can receive reports by email according to their preferences. Email messages will be sent via an internal mail server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You have an application that populates a table with user-specific subscription schedules and report formats.
You need to ensure that users can receive reports by email according to their preferences. Email messages will be sent via an internal mail server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
正確答案: D
說明：（僅 Fast2test 成員可見）
You are redesigning a SQL Server Analysis Services (SSAS) database that contains a cube named Sales.
Before the initial deployment of the cube, partition design was optimized for processing time. The cube currently includes five partitions named FactSalesl through FactSales5. Each partition contains from 1 million to 2 million rows.
The FactSales5 partition contains the current year's information. The other partitions contain information from prior years; one year per partition. Currently, no aggregations are defined on the partitions.
You remove fact rows that are more than five years old from the fact table in the data source and configure query logs on the SSAS server.
Several queries and reports are running very slowly.
You need to optimize the partition structure and design aggregations to improve query performance and minimize administrative overhead.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Before the initial deployment of the cube, partition design was optimized for processing time. The cube currently includes five partitions named FactSalesl through FactSales5. Each partition contains from 1 million to 2 million rows.
The FactSales5 partition contains the current year's information. The other partitions contain information from prior years; one year per partition. Currently, no aggregations are defined on the partitions.
You remove fact rows that are more than five years old from the fact table in the data source and configure query logs on the SSAS server.
Several queries and reports are running very slowly.
You need to optimize the partition structure and design aggregations to improve query performance and minimize administrative overhead.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
正確答案: C
You are designing a SQL Server 2012 Integration Services (SSIS) deployment strategy. You currently have many SQL Server 2008 SSIS packages that require upgrading.
The production environment includes SSIS 2012 and SSIS 2008. The environment includes existing command shell scripts that invoke the dtutil command-line utility.
You need to design a deployment strategy that supports existing deployment strategies and requires the minimum amount of effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
The production environment includes SSIS 2012 and SSIS 2008. The environment includes existing command shell scripts that invoke the dtutil command-line utility.
You need to design a deployment strategy that supports existing deployment strategies and requires the minimum amount of effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
正確答案: C
You need to develop the tabular project to support the date analysis requirements.
What should you do?
What should you do?
正確答案: C