70-466 Exam
How Does Exambible Microsoft 70-466 test questions Work?
Want to know Pass4sure 70-466 Exam practice test features? Want to lear more about Microsoft Implementing Data Models and Reports with Microsoft SQL Server 2012 certification experience? Study Validated Microsoft 70-466 answers to Latest 70-466 questions at Pass4sure. Gat a success with an absolute guarantee to pass Microsoft 70-466 (Implementing Data Models and Reports with Microsoft SQL Server 2012) test on your first attempt.
Q51. - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) multidimensional database. The underlying data source does not have a time dimension table.
You need to implement a time dimension.
What should you do?
A. Use the SQL Server Data Tools Dimension Wizard and generate a time table on the server.
B. Create a CSV file with time data and use the DMX IMPORT statement to import data from the CSV file.
C. Create a time dimension by using the Define dimension intelligence option in the Business Intelligence Wizard.
D. Create a time dimension by using the Define time intelligence option in the Business Intelligence Wizard.
Answer: A
Q52. - (Topic 4)
You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A system role named Developer Support is present on the server.
Members of the Developer Support role cannot modify the report execution timeout period.
You need to enable members of the Developer Support role to modify the report execution timeout period.
Which task should you add to the Developer Support role?
A. Manage report server properties
B. Manage shared schedules
C. Execute report definitions
D. Manage jobs
Answer: A
Q53. DRAG DROP - (Topic 4)
You are using Multidimensional Expressions (MDX) to query a SQL Server Analysis Services (SSAS) cube.
You need to compute the aggregate value of the 10 most-ordered produces in the Product Categories hierarchy. The Product level is the lowest in the hierarchy.
Which functions should you use to complete the MDX query? (To answer, drag the appropriate functions from the list of functions to the correct locations in the answer area.)
Answer:
Q54. DRAG DROP - (Topic 4)
You are making changes to a cube named Sales.
You must increase the value of the measure named Sales Amount by 10%. The increase must be applied only to the children of the member named East in the dimension named Customer.
You need to complete the Multidimensional Expressions (MDX) statement in the calculations section of the Sales cube.
Which statement fragments should you use? (To answer, drag the appropriate statement component to the correct location or locations in the answer area. Use only components that apply.)
Answer:
Q55. - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Profit and includes a table named Date. The table includes year, semester, quarter, month, and date columns. The Date column is of data type Date. The table contains a set of contiguous dates.
You need to create a measure to report on year-over-year growth of profit.
What should you do? (Each answer presents a complete solution. Choose all that apply.)
A. Option A
B. Option B
C. Option C
D. Option D
Answer: C,D
Q56. HOTSPOT - (Topic 4)
A SQL Server Analysis Services (SSAS) cube has roles to define dimension data security. A role named USA allows users to browse data pertaining to the United States. A role named Canada allows users to browse data pertaining to Canada.
A user can browse sales data pertaining to the United States but cannot browse sales data pertaining to Canada. You validate that the user belongs to the USA and Canada roles.
You need to reproduce the issue in SQL Server Management Studio (SSMS).
Which option should you select? To answer, select the appropriate action in the answer area.
Answer:
Q57. - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power View solution.
You need to grant permission for salespersons to view only the data based on their sales territory.
What should you do?
A. Create a member and then create a Data Analysis Expressions (DAX) filter.
B. Create a member and then create a Multidimensional Expressions (MDX) filter.
C. Use SQL Server Management Studio to create a role. Then create a Data Analysis Expressions (DAX) filter.
D. Use SQL Server Management Studio to create a role. Then create a Multidimensional Expressions (MDX) filter.
Answer: C
Q58. - (Topic 4)
You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a Microsoft Azure SQL Database database.
The report must use a map to display the location and status of the ATMs as shown in the following exhibit. (Click the Exhibit button.)
You need to ensure that the report displays only a user selected map region.
Which source of spatial data should you use for the map?
A. SQL Server spatial query
B. Map gallery
C. ESRI shape file
D. Bing Maps layer
Answer: A
Q59. - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) cube named Sales Planning. The cube consists of two measure groups named Sales and Planning. Each measure group is based on a data warehouse fact table and consists of a single MOLAP partition that has the same name as its measure group.
The Planning measure group consists of two measures:
. Forecast, which uses the Sum aggregate function
. Forecast Count, which uses the Count aggregate function
Users contribute planning values by using a legacy application. An extract, transform, load (ETL) process is scheduled to periodically transfer the planning values from the database of the legacy application to the data warehouse.
Financial analysts query the Sales Planning cube and report that the planning values are sometimes out of date. A new company requirement mandates that the planning values be entered directly into the cube by using Microsoft Excel 2010 PivotTable What-If Analysis.
You need to write-enable the Planning partition.
What should you do before write-enabling the partition?
A. Set the StorageMode property of the Planning partition to Rolap
B. Set the ProcessingMode property of the Planning partition to LazyAggregations.
C. Set the ProcessingMode property of the Planning measure group to LazyAggregations.
D. Remove the Forecast Count measure.
E. Set the Type property of the Planning measure group to Budget.
F. Convert the Planning measure group to a linked measure group.
Answer: D
Q60. - (Topic 4)
You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 28 GB of RAM.
The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk space and is doubling in size every month. The model will be queried by staff in the accounting department by using Microsoft Excel 2010.
You need to ensure the highest query performance and scalability for the accounting department queries.
Which project type should you choose?
A. Tabular project that uses the In-Memory query mode
B. PowerPivot workbook deployed to SharePoint
C. Tabular project that uses the DirectQuery query mode
D. Multidimensional project
Answer: D