Microsoft 70-466 Study Guides 2021

NEW QUESTION 1
You need to configure a hierarchy for DimProduct that meets the technical requirements. What should you do?

• A. Set ProductName as the parent of ProductSubCategory and set ProductSubcategory as the parent of ProductCategor
• B. For ProductSubcategory, click Hide if Name Equals Parent.
• C. Set ProductCategory as the parent of ProductSubCategory and set ProductSubcategory as the parent of ProductNam
• D. For ProductSubcategory, click Hide if Name Equals Parent.
• E. Set ProductName as the parent of ProductSubcategory and set ProductSubCategory as the parent of ProductCategor
• F. For ProductCategory, click Hide if Name Equals Parent.
• G. Set ProductCategory as the parent of ProductSubcategory and set ProductSubCategory as the parent of ProductNam
• H. For ProductCategory, click Hide if Name Equals Parent.

Answer: B

NEW QUESTION 2
You need to configure the SSRS data source. What should you do?

• A. Use Windows credentials.
• B. Prompt the user for credentials.
• C. In the data source configuration window, select the Credentials are not required option.
• D. Store the credentials.

Answer: A

NEW QUESTION 3
You are developing a Microsoft SQL Analysis Services (SSAS) multidimensional project
A fact table named FactHouseSales has a measure column named Area. All values in the column are stored in square feet. Users must be able to analyze the area in different units.
You create a table named AreaUnit. Each row in the table consists of the unit name and a square feet conversion factor value.
You need to implement the area conversion in the project. 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 that uses the LastNonEmpty aggregate functio
• F. Use a regular relationship between the time dimension and the measure group.
• G. Add a measure group that has one measure that uses the DistinctCount aggregate function.
• H. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• I. Add a hidden measure that uses the Sum aggregate functio
• J. Add a calculated measure aggregating the measure along the time dimension.
• K. Create several dimension
• L. Add each dimension to the cube.
• M. Create a dimensio
• N. Then add a cube dimension and link it several times to the measure group.
• O. Create a dimensio
• P. Create regular relationships between the cube dimension and the measure grou
• Q. Configure the relationships to use different dimension attributes.
• R. Create a dimension with one attribute hierarch
• S. Set the IsAggregatable property to False and then set the DefaultMember propert
• T. Use a regular relationship between the dimension and measure group.
• U. Create a dimension with one attribute hierarch
• V. Set the IsAggregatable property to False and then set the DefaultMember propert
• W. Use a many-to-many relationship to link the dimension to the measure group.
• X. Create a dimension with one attribute hierarch
• Y. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember propert
• Z. Configure the cube dimension so that it does not have a relationship with the measure grou
• BA. Add a calculated measure that uses the MemberValue attribute property.
• BB. Create a new named calculation in the data source view to calculate a rolling su
• BC. Add a measure that uses the Max aggregate function based on the named calculation.

Answer: N

NEW QUESTION 4
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.)

Answer:

Explanation:

NEW QUESTION 5
DRAG DROP
You have a database named DB1. DB1 contains four tables named FactSales, DimTime, 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 need to identify which type of dimension must be created for each table.
Which type of dimension should you create for each table? To answer, drag the appropriate dimensions to the correct tables. Each dimension may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.

Answer:

Explanation:

NEW QUESTION 6
You are developing a tabular Business Intelligence Semantic Model (BISM) database based on a SQL Server database.
In the data source, the FactInternetSales table is partitioned by month. Data from the current month has been updated and new data has been inserted in the FactInternetSales table, in the DimProduct table, and in the DimCustomer table.
In the model, the FactInternetSales table is also partitioned by month.
You need to ensure that the model has the most recent data while minimizing the processing time.
What should you do?

• A. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing optio
• B. Then process the database with the Process Data processing option.
• C. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing optio
• D. Then process the database with the Process Full processing option.
• E. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Defrag processing optio
• F. Then process the database with the Process Recalc processing option.
• G. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing optio
• H. Then process the database with the Process Defrag processing option.
• I. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing optio
• J. Then process the database with the Process Recalc processing option.

Answer: D

NEW QUESTION 7
You need to create the KPI in the AdhocReports project. What should you do?

• A. Create a measure by using the SUM([OrderQuantity]) expressio
• B. Then use the CREATE KPI CURRENTCUBE statement to define the KPI and target value.
• C. Create a measure by using the SUM([OrderQuantity]) expression and create a KPI based on the measur
• D. Then set the target value.
• E. Create a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measur
• F. Then set the target value.
• G. Create a KPI based on the OrderQuantity column and then set the target value.

Answer: A

NEW QUESTION 8
You need to create the sales territory and product measures. Which aggregate function should you use for both measures?

• A. Count
• B. COUNT(DIST1NCT column_name)
• C. DistinctCount
• D. Distinct

Answer: C

NEW QUESTION 9
You need to ascertain why Marc did not receive his reports. What should you do?

• A. Search the ReportServerService_<timestamp>.log file for errors.
• B. Search the registry for errors.
• C. Use SQL Server Management Studio to search the SQL Server logs for errors.
• D. Use the Windows Event Viewer to search the Application log for errors.

Answer: A

NEW QUESTION 10
You manage a SQL Server Reporting Services (SSRS) instance. The ReportingServicesService.exe.config file has been modified to enable logging.
Some users report that they cannot access the server.
You need to ascertain the IP addresses of the client computers that are accessing the server.
What should you do?

• A. View the ExecutionLog view in the Report Server database.
• B. View the Report Server service trace log.
• C. View the Report Server HTTP log.
• D. View the Windows System event log.

Answer: C

NEW QUESTION 11
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. =(Globals!RenderFormat.IsInteractive = False)
• B. = (Globals!RenderFormat.Name = "PDF")
• C. =False
• D. =True

Answer: B

NEW QUESTION 12
You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Revenue 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 revenue.
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: ACD

NEW QUESTION 13
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.)

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

NEW QUESTION 14
You need to configure the UserRegions role.
Which Multidimensional Expressions (MDX) function should you use?

• A. USERNAME ( )
• B. USERID ( )
• C. CUSTOMDATA ( )
• D. UNIQUENAME ( )
• E. LOOKUPVALUE ( )

Answer: A

NEW QUESTION 15
HOTSPOT
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? (To answer, select the appropriate option in the answer area.)

Answer:

Explanation:

NEW QUESTION 16
You need to configure the dataset for the ManufacturingIssues report. The solution must meet the technical requirements and the reporting requirements.
What should you do?

• A. Configure the dataset to use a stored procedur
• B. Add the necessary parameters to the stored procedure.
• C. Add a query to retrieve the necessary data from the databas
• D. Configure the dataset to use query parameters.
• E. Add a query to retrieve the necessary data from the databas
• F. Configure the dataset to use filter parameters.
• G. Configure the dataset to use a tabl
• H. Ensure that the database has a table that contains the necessary information.

Answer: B