Microsoft 070-466 Actual Free Exam Questions & Community Discussion
You are designing a SQL Server Reporting Services (SSRS) report.
The report defines a single SQL Server data source and dataset.
You need to include additional data sourced from a Microsoft Azure SQL Database in the report.
What should you do?
The report defines a single SQL Server data source and dataset.
You need to include additional data sourced from a Microsoft Azure SQL Database in the report.
What should you do?
Correct Answer: A
Vote an answer
You are restructuring an existing cube. One of the measures in the cube is Amount. The Sum aggregation function is used for the Amount measure. The cube includes a dimension named Account and the dimension's Type property is set to Accounts. The Account dimension includes an account type attribute.
You need to ensure that the Amount measure aggregates correctly according to the account type classification. Development effort must be minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You need to ensure that the Amount measure aggregates correctly according to the account type classification. Development effort must be minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Correct Answer: B
Vote an answer
HOTSPOT
You have a database named DB1. DB1 contains three tables named FactSales, DimCustomer, and DimEmployee. A sample from DimEmployee is shown in the following table.
A sample from DimCustomer is shown in the following table.
A sample from FactSales is shown in the following table.
You create a cube named Sales that uses the three tables. FactSales is used as a fact table, DimCustomer is used to create a dimension named Customer, and DimEmployee is used to create a dimension named Employee.
Users report the following issues:
* When browsing the Customer dimension, the users see a blank member in the state hierarchy under United Kingdom.
* When browsing the Employee dimension, the sales data for Sales Managers and Sales Supervisors is NOT displayed.
You need to resolve the issues by configuring the properties of the dimension attributes.
What should you do? To answer, select the appropriate value for each property in the answer area.
You have a database named DB1. DB1 contains three tables named FactSales, DimCustomer, and DimEmployee. A sample from DimEmployee is shown in the following table.
A sample from DimCustomer is shown in the following table.
A sample from FactSales is shown in the following table.
You create a cube named Sales that uses the three tables. FactSales is used as a fact table, DimCustomer is used to create a dimension named Customer, and DimEmployee is used to create a dimension named Employee.
Users report the following issues:
* When browsing the Customer dimension, the users see a blank member in the state hierarchy under United Kingdom.
* When browsing the Employee dimension, the sales data for Sales Managers and Sales Supervisors is NOT displayed.
You need to resolve the issues by configuring the properties of the dimension attributes.
What should you do? To answer, select the appropriate value for each property in the answer area.
Correct Answer:
You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year Month Number, and InvCount. The report includes a table that displays the inventory count per year, as shown in the following table.
You need to modify the table to include a graphical item displaying the inventory count trend to the right of the Inv Count column.
What should you do?
You need to modify the table to include a graphical item displaying the inventory count trend to the right of the Inv Count column.
What should you do?
Correct Answer: B
Vote an answer
You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a Microsoft Azure SQL Database database and an OData data feed. The model will be deployed to a server with significantly more memory than the total size of the source data.
You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT).
The model must meet the following requirements:
*Maximize performance
*Data latency of up to one month is acceptable
You need to choose a project type and a data access mode to meet the requirements.
What should you do?
You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT).
The model must meet the following requirements:
*Maximize performance
*Data latency of up to one month is acceptable
You need to choose a project type and a data access mode to meet the requirements.
What should you do?
Correct Answer: B
Vote an answer
You deploy a tabular model in DirectQuery mode to a server named Server1. Server1 has SQL Server Analysis Services (SSAS) installed. The model uses a relational data source named DB1.
You need to ensure that Server1 passes the credentials of the current user browsing the model to DB1.
What should you do?
You need to ensure that Server1 passes the credentials of the current user browsing the model to DB1.
What should you do?
Correct Answer: A
Vote an answer
You are developing a SQL Server Analysis Services (SSAS) tabular database.
To maximize performance, the queries must be resolved by using cache unless otherwise specified in the connection string.
You need to configure the appropriate query mode.
Which query mode should you select?
To maximize performance, the queries must be resolved by using cache unless otherwise specified in the connection string.
You need to configure the appropriate query mode.
Which query mode should you select?
Correct Answer: D
Vote an answer
You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was developed with default settings.
The model has one cube and the cube has one measure group. The measure group is based on a very large fact table and is partitioned by month. The fact table is incrementally loaded each day with approximately 800,000 new rows.
You need to ensure that all rows are available in the cube while minimizing the processing time.
Which processing option should you use?
The model has one cube and the cube has one measure group. The measure group is based on a very large fact table and is partitioned by month. The fact table is incrementally loaded each day with approximately 800,000 new rows.
You need to ensure that all rows are available in the cube while minimizing the processing time.
Which processing option should you use?
Correct Answer: F
Vote an answer
DRAG DROP
You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade the instance to SQL Server 2014.
You need to import an existing PowerPivot workbook to create a tabular project.
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 single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade the instance to SQL Server 2014.
You need to import an existing PowerPivot workbook to create a tabular project.
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.)
Correct Answer:
Explanation:
Box 1:
Box 2:
Box 3:
Note:
* To create a new tabular model project from a PowerPivot for Excel file
* In SQL Server Data Tools, on theFilemenu, clickNew, and then clickProject.
(box 2)
* In theNew Projectdialog box, underInstalled Templates, clickBusiness Intelligence, and then clickImport from PowerPivot.(box 3)
* InName, type a name for the project, then specify a location and solution name, and then clickOK.
* In theOpendialog box, select the PowerPivot for Excel file that contains the model metadata and data you want to import, and then clickOpen.
Box 1:
* When creating a new tabular model project by importing from a PowerPivot workbook, the metadata that defines the structure of the workbook is used to create and define the structure of the tabular model project in SQL Server Data Tools. Objects such as tables, columns, measures, and relationships are retained and will appear in the tabular model project as they are in the PowerPivot workbook.
* Analysis Services provides three different approaches for creating a business intelligence semantic model: tabular, multidimensional, and PowerPivot. Tabular solutions use relational modeling constructs such as tables and relationships for modeling data, and the xVelocity in-memory analytics engine for storing and calculating data
DRAG DROP
You are planning the installation of PowerPivot for SharePoint.
You install SharePoint Server 2010 Enterprise Edition with Service Pack 1.
You need to install the PowerPivot for SharePoint instance. Then you need to configure the Default Account username used to provision shared services in the SharePoint farm.
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 planning the installation of PowerPivot for SharePoint.
You install SharePoint Server 2010 Enterprise Edition with Service Pack 1.
You need to install the PowerPivot for SharePoint instance. Then you need to configure the Default Account username used to provision shared services in the SharePoint farm.
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.)
Correct Answer:
You are modifying a SQL Server Analysis Services (SSAS) multidimensional database.
You have identified a dimension that is no longer used by any cubes.
You need to delete the dimension.
What should you do?
You have identified a dimension that is no longer used by any cubes.
You need to delete the dimension.
What should you do?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
0
0
0
10