Microsoft Designing Business Intelligence Solutions with Microsoft SQL Server - 70-467무료 덤프문제 풀어보기
You need to select the appropriate mode for the Sales database.
Which mode should you select?
Which mode should you select?
정답: B
설명: (Fast2test 회원만 볼 수 있음)
You need to create the factCustomerContact table.
Which type of table should you create?
Which type of table should you create?
정답: C
You need to prepare the infrastructure for the planned implementation of Gallery1.
Which three actions should you perform? Each correct answer presents part of the solution,
Which three actions should you perform? Each correct answer presents part of the solution,
정답: B,E,F
You need to restrict access to data in the tables in the data warehouse.
What should you do?
What should you do?
정답: A
You are validating whether a SQL Server Integration Services (SSIS) package named Master.dtsx in the SSIS catalog is executing correctly.
You need to display the number of rows in each buffer passed between each data flow component of the package.
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 display the number of rows in each buffer passed between each data flow component of the package.
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
http://sqlblog.com/blogs/jamie_thomson/archive/2012/09/03/36994.aspx
You need to develop the LoadFactSales package to write the error messages to the SSIS catalog log.
Which components should you use?
To answer, drag the appropriate components to the correct location or locations in the answer area. (Use only components that apply.)
Which components should you use?
To answer, drag the appropriate components to the correct location or locations in the answer area. (Use only components that apply.)
정답:
Explanation
You need to implement the SalesCommission model to support the planned reports and queries.
What should you do?
What should you do?
정답: C
A school stores information about teachers, students, classes, and enrollments in a Microsoft Azure SQL Database database. The database includes a table that maps the user IDs of teachers to the subjects they teach.
Teachers access reports in a SQL Server Reporting Services (SSRS) instance by using their credentials.
You are developing a report that displays a table of class enrollments for a specific subject. The report will prompt teachers to select from their mapped subjects. The table is based on a dataset named ClassData. To minimize report execution time, the ClassData dataset has been configured to cache all class enrollment data.
You need to ensure that the report displays the correct class enrollment data.
Which item should you configure?
To answer, select the appropriate item in the answer area.
Teachers access reports in a SQL Server Reporting Services (SSRS) instance by using their credentials.
You are developing a report that displays a table of class enrollments for a specific subject. The report will prompt teachers to select from their mapped subjects. The table is based on a dataset named ClassData. To minimize report execution time, the ClassData dataset has been configured to cache all class enrollment data.
You need to ensure that the report displays the correct class enrollment data.
Which item should you configure?
To answer, select the appropriate item in the answer area.
정답:
Explanation
You are modifying a SQL Server Reporting Services (SSRS) report for a SQL Server Analysis Services (SSAS) cube. The report defines a report parameter of data type Date/Time with which users can filter the report by a single date. The parameter value cannot be directly used to filter the Multidimensional Expressions (MDX) query for the dataset.
You need to ensure that the report displays data filtered by the user-entered value. You must achieve this goal by using the least amount of development effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You need to ensure that the report displays data filtered by the user-entered value. You must achieve this goal by using the least amount of development effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
정답: D
You have a nightly process that loads millions of rows from an AS/400 system to a SQL Server Analysis Services (SSAS) cube. You need to design a partitioning strategy to ensure that new information can be added without reprocessing the entire cube. Which processing option should you use?
정답: B
You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube.
The cube includes a Product dimension that contains a Category hierarchy and a Color attribute hierarchy.
You need to return only the blue products in the Category hierarchy.
Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
The cube includes a Product dimension that contains a Category hierarchy and a Color attribute hierarchy.
You need to return only the blue products in the Category hierarchy.
Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
정답: A
A group of report writers develop reports. The report writers currently use Report Builder 1.0 and report models. The report writers are not trained on SQL Server query writing. Their report assignments come from various departments within the organization.
The company is upgrading to SQL Server 2012 with SQL Server Reporting Services (SSRS) in native mode.
After the upgrade, reports will retrieve data from a large new data warehouse that will reside on an instance of the SQL Server 2012 Database Engine. Reports for each department will retrieve data from only a subset of the data warehouse tables.
You are designing the data access strategy. You have the following requirements:
* Ensure that report writers can create only reports that display data which they have database permissions to view.
* Minimize the effort required to update connection strings for all reports developed by the report writers.
* Minimize the number of fields visible in a specific report for report writers who work for multiple departments.
You need to design the data access strategy.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
The company is upgrading to SQL Server 2012 with SQL Server Reporting Services (SSRS) in native mode.
After the upgrade, reports will retrieve data from a large new data warehouse that will reside on an instance of the SQL Server 2012 Database Engine. Reports for each department will retrieve data from only a subset of the data warehouse tables.
You are designing the data access strategy. You have the following requirements:
* Ensure that report writers can create only reports that display data which they have database permissions to view.
* Minimize the effort required to update connection strings for all reports developed by the report writers.
* Minimize the number of fields visible in a specific report for report writers who work for multiple departments.
You need to design the data access strategy.
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 deploying the Research model.
You need to ensure that the data contained in the model can be refreshed.
What should you do?
You need to ensure that the data contained in the model can be refreshed.
What should you do?
정답: A