Exam Code: 70-466 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Implementing Data Models and Reports with Microsoft SQL Server 2012
Certification Provider: Microsoft
Free Today! Guaranteed Training- Pass 70-466 Exam.
Q1. HOTSPOT - (Topic 4)
You are designing a dimension named Employee for a SQL Server Analysis Services
multidimensional project.
The Employee dimension contains a DateOfBirth attribute and a MaritalStatus attribute.
You need to minimize the amount of time required to process the cube.
What should you do? To answer, select the appropriate relationship type for each attribute
in the answer area.
Answer:
114. DRAG DROP - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to add a calculated column to a table in the model.
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.)
Answer:
Q2. - (Topic 4)
You manage a SQL Server Reporting Services (SSRS) instance.
An application must pass credentials to the local security authority for Reporting Services.
You need to configure Reporting Services to issue a challenge/response when a
connection is made without credentials.
Which authentication type should you configure in the RSReportServer.config file?
A. RSWindowsKerberos
B. RSWindowsNegotiate
C. RSWindowsNTLM
D. RSWindowsBasic
Answer: A
Q3. - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) tabular database. To maximize performance, queries must be resolved only by using cache.
You need to configure the appropriate query mode.
Which query mode should you select?
A. DirectQuery with In-Memory
B. In-Memory with DirectQuery
C. In-Memory
D. DirectQuery
Answer: C
Q4. HOTSPOT - (Topic 4)
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.
Answer:
Q5. - (Topic 3)
You need to deploy the StandardReports project.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
A. Use the Analysis Services Deployment utility to create an XMLA deployment script.
B. Deploy the project from SQL Server Data Tools (SSDT).
C. Use the Analysis Services Deployment wizard to create an XMLA deployment script.
D. Use the Analysis Services Deployment wizard to create an MDX deployment script.
Answer: B,C
Q6. DRAG DROP - (Topic 4)
You are developing a SQL Server Analysis Services (S5AS) cube. The cube consists of a single measure group.
The measure group consists of one partition that uses MOLAP.
The proactive caching policy has the following requirements:
. The cache must be updated when data is changed in the table named tbIOrders. . Changes must be notified through the use of the XML for Analysis (XMLA) NotifyTableChange command.
You need to configure the proactive caching policy to meet the requirements.
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.)
Answer:
Q7. - (Topic 4)
You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates mobile phone usage data from a Microsoft Azure SQL Database database. The existing database contains a device dimension.
The Research and Development team has requested that capabilities be added to the database.
The capabilities must meet the following requirements:
...
A device member must be able to have multiple capability members.
A capability member must be able to belong to several device members.
The Research and Development team must be able to create new capabilities
every quarter in the data source.
You need to implement the appropriate solution to meet the requirements while ensuring that the amount of development and maintenance time is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a dimension named Capability Name and then configure a many-to-many relationship.
B. Add an attribute hierarchy for each capability to the customer dimension. Configure each hierarchy to have two members named Yes and No.
C. Create a dimension named Capability Name and then configure a regular relationship.
D. Add an attribute hierarchy named Capability Name to the customer dimension.
Answer: A
Q8. - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) cube.
The data warehouse has a table named FactStock that is used to track movements of stock. A column namedMovementQuantity contains quantities of stock. A positive quantity is used for input and negative quantity is used for output. A column named Movement Date is related to the time dimension. The quantity in stock, at a given point in time, can be evaluated as the sum of all MovementQuantity values at that point in time.
You need to create a measure that calculates the quantity in stock value.
What should you do?
A. Use role playing dimensions.
B. Use the Business Intelligence Wizard to define dimension intelligence.
C. Add a measure that uses the Count aggregate function to an existing measure group.
D. Add a measure that uses the DistinctCount aggregate function to an existing measure group.
E. Add a measure group that has one measure that uses the DistinctCount aggregate function.
F. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
G. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
H. Create several dimensions. Add each dimension to the cube.
I. Create a dimension. Then add a cube dimension and link it several times to the measure group.
J. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
K. Create a dimension with one attribute hierarchy. Set the IsAggrcgatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
L. Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
M. Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
N. Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.
O. Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
Answer: G
Q9. - (Topic 4)
You develop a SQL Server Analysis Services (SSAS) stored procedure.
You need to ensure that developers can create Multidimensional Expressions (MDX) calculations that use the stored procedure.
What should you do?
A. Register the assembly on the SSAS server instance.
B. Copy the assembly to the SSAS installation directory and register it by using the CREATE ASSEMBLY T-SQL command.
C. Register the assembly on the SSAS server by using regedit.exe.
D. Register the assembly on the SharePoint server by using regeditexe.
Answer: B
Q10. - (Topic 4)
You are developing a SQL Server Reporting Services (SSRS) sales summary report.
The report header consists of several images.
You need to ensure that the header of the report is hidden when a user exports the report to PDF format.
Which Hidden property expression should you use for the report header? {More than one answer choice may achieve the goal. Select the BEST answer.)
A. =(GlobalsIRenderFormat.IsInteractive = False)
B. = (Globals!RenderFormat.Name = "PDF")
C. =False
D. =True
Answer: B
Q11. - (Topic 3)
You need to identify the reports that produce the errors that Marc is receiving.
What should you do?
A. Write a query by using the Subscriptions table in the report server database.
B. Write a query by using the Execution Log 3 view in the report server database.
C. Use the Windows Event Viewer to search the Application log for errors.
D. Search the ReportServerService_<timestamp>.log file for errors.
Answer: B
Q12. - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?
A. Set the Type property of the partition's measure group to Forecast.
B. Implement the linked measure group as a local measure group.
C. Implement the local measure group as a linked measure group.
D. Set the StorageMode property of the linked measure group to Rolap.
Answer: B
Q13. DRAG DROP - (Topic 4)
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.)
Answer:
Q14. - (Topic 4)
You are creating a new report in SQL Server Report Builder. You add a Microsoft Azure SQL Database data source. Then you add a dataset that has four fields named Year. Country, Category, and Sales.
You must design a matrix as shown in the following table.
The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows {the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year.
You add a matrix to the report. You add a grouping of the Category field on the rows and a grouping of the Year field on the columns.
You need to add the countries on the rows of the matrix.
Which Row Group option should you select when you add the group?
A. Adjacent Below
B. Child Group
C. Parent Group
D. Adjacent Above
Answer: A
Q15. - (Topic 4)
You are modifying a SQL Server Analysis Services (SSAS) cube.
Users of the cube report that the precision for the TransactionCost measure is five digits.
You need to ensure that the TransactionCost measure stores values to two digits of precision.
What should you do?
A. Use the FormatString measure property to format TransactionCost as Currency.
B. Add a named calculation in the data source view that casts the data source column to two digits of precision. Bind the TransactionCost measure to the new column.
C. Add a named query in the data source view that casts the data source column to two digits of precision. Bind the TransactionCost measure to the new query.
D. Use the MeasureExpression measure property to change the precision of TransactionCost to two digits.
E. Use the FormatString measure property to format TransactionCost as #, ##0.00;-#,##0.00.
Answer: B
Q16. HOTSPOT - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) cube.
Revenue must be compared to a goal and described by a status and a trend. Revenue,
goal, status, and trend will be defined by Multidimensional Expressions (MDX) expressions.
You need to add the Revenue indicator.
Which tab should you select? (To answer, select the appropriate tab in the work area.)
Answer: