Microsoft Implementing Data Models and Reports with Microsoft SQL Server - 070-466 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

You need to modify the environment before you create the QuarterSales report.
What should you do?

A. Configure SSAS to use a server time dimension. B. Configure a time dimension by using the Time Intelligence Wizard. C. Add a date table to the model that contains columns for the fiscal and calendar quarters. D. Add a date table to the model that contains measures for the fiscal and calendar quarters.

Discussion 0

Correct Answer: B Vote an answer

Question 2

You need to create the AD Sales measure.
Which aggregation function should you use?

A. AverageOfChildren B. ByAccount C. Sum D. Average

Discussion 0

Correct Answer: A Vote an answer

Question 3

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?

A. Add a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Series Groups. B. Add a Sparkline item to a new column on the right of the Inv Count column. Then select the InvCount field for Values and the MonthNumber field for Category Groups. C. Add an Indicator item to a new column on the right of the Inv Count column. Select the Directional Indicator type and then assign the MonthNumber field to the Start property. D. Add an Indicator item to a new column on the right of the Inv Count column. Select the Directional Indicator type and then select the MonthNumber field for Value. E. Add a text box to a new column on the right of the Inv Count column. Then use a Go to report action to link to a separate report showing the monthly trend.

Discussion 0

Correct Answer: B Vote an answer

Question 4

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?

A. Select the tabular project type and use the DirectQuery query mode. B. Select the multidimensional project type and use the MOLAP storage mode. C. Select the tabular project type and use the In-Memory query mode. D. Select the multidimensional project type and use the ROLAP storage mode.

Discussion 0

Correct Answer: C Vote an answer

Question 5

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. Use SQL Server Management Studio to create a role. Then create a Multidimensional Expressions (MDX) filter. B. Use SQL Server Management Studio to create a role. Then create a Data Analysis Expressions (DAX) filter. C. Create a member and then create a Data Analysis Expressions (DAX) filter. D. Create a member and then create a Multidimensional Expressions (MDX) filter.

Discussion 0

Correct Answer: B Vote an answer

Question 6

HOTSPOT
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.

Discussion 0

Correct Answer:

Question 7

You are developing a SQL Server Analysis Services (SSAS) cube.
You must create a four-level hierarchy for the employee dimension. Each level must be associated with an attribute in the employee dimension table. Two thirds of the dimension data contain values for all four attributes. The remainder of the dimension data contains values for the first three of the four attributes only.
You need to create the hierarchy so that logically missing members will not be shown by the reporting tool.
Which type of hierarchy should you create?

A. A sparse hierarchy B. A balanced hierarchy C. A ragged hierarchy D. A parent-child hierarchy

Discussion 0

Correct Answer: C Vote an answer

Question 8

You need to recommend a solution to meet the requirements for the
ManufacturingIssues.rdl report.
What is the best solution that you should include in the recommendation? More than one answer choice may achieve the goal. Choose the BEST answer.

A. Add a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Add a dataset for each parameter created. Configure each parameter to use the values in the dataset. B. Add a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Use the default display for the parameters. C. Add a dataset to the report that uses a stored procedure. Configure the dataset to include the parameters required for the different views. Update each parameter to use a set of values from Report Designer. D. Add a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Update each parameter to use a set of values from Report Designer.

Discussion 0

Correct Answer: B Vote an answer

Question 9

You need to create the KPI in the AdhocReports project in time for the next production release cycle.
What should you do?

A. Create a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value. Check in the changes before the next release cycle. B. Create a measure by using the SUM([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value. Check in the changes before the next release cycle. C. Create a measure by using the SUM((OrderQuantity]) expression. Then use the CREATE KPI CURRENTCUBE statement to define the KPI and target value. Check in the changes before the next release cycle. D. Create a KPI based on the OrderQuantity column and then set the target value. Check in the changes before the next release cycle.

Discussion 0

Correct Answer: C Vote an answer

Question 10

You are developing a multidimensional project that includes a dimension named Organization.
The dimension is based on the DimOrganization table in the data warehouse.
The following diagram illustrates the table design.

The Organization dimension includes a parent-child hierarchy named Organizations.
The dimension includes the following dimension attributes:
Organization, which is a key attribute
Organizations, which defines the parent-child hierarchy
Currency Code, which is a regular attribute
When users browse the dimension, three hierarchies are visible to them.
You need to ensure that the Organization hierarchy is not visible to users.
What should you do?

A. Delete the Organization attribute. B. Set the AttributeHierarchyEnabled property to False for the Organization attribute. C. Set the AttributeHierarchyVisible property to False for the Organization attribute. D. Set the AttributeHierarchyDisplayFolder property to Null for the Organization attribute.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 11

Question 12

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 wizard to create an MDX deployment script. B. Deploy the project from SQL Server Data Tools (SSDT). C. Use the Analysis Services Deployment utility to create an XMLA deployment script. D. Use the Analysis Services Deployment wizard to create an XMLA deployment script.

Discussion 0

Correct Answer: B,D Vote an answer

Question 13

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?

A. Write a Data Mining Extensions (DMX) command to drop the dimension from the database. B. Write a T-SQL command to drop the dimension from the database. C. Delete the dimension by using SQL Server Management Studio Object Explorer. D. Write a Multidimensional Expressions (MDX) command to drop the dimension from the database.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).