最新的Microsoft 070-466免費考試真題

問題1

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

A. Sum

B. Average

C. AverageOfChildren

D. ByAccount

正確答案: C

問題2

You need create the data source view for the StandardReports project.
What should you do?

A. Generate a relational schema from the dimensions and cubes by using the Schema Generation wizard.

B. Execute the Import from Table wizard and then use the Data Source View wizard.

C. Create a new data source view and then use the Import from Table wizard.

D. Create a data source, connect it to the data warehouse, and then use the Data Source View wizard.

正確答案: D

問題3

You have a SQL Server 2012 database named DB1. You have a backup device named Device1.
You discover that the log file for the database is full. You need to ensure that DB1 can complete transactions.
The solution must not affect the chain of log sequence numbers (LSNs).
Which code segment should you execute?

A. BACKUP LOG D31 TO Device1 WITH TRUNCATE ONLY

B. BACKUP LCG DB1 TO Device1 WITH COPY_ONLY

C. BACKUP LOG DB1 TO Device1 WITH NCRECCVERY

D. BACKUP LOG DB1 TO Device1

正確答案: D

說明：（僅 Fast2test 成員可見）

問題4

You are adding dimensions and a new measure group named Accounts Receivable to an existing SQL Server Analysis Services (SSAS) cube.
Date is one of the existing dimensions in the SSAS database. The underlying fact table for the measure group is associated with multiple dates, including InvoiceDate, DueDate and PaymentDate.
You need to ensure that users can slice the Accounts Receivable measures by InvoiceDate, DueDate, and PaymentDate. You also need to ensure that the time required to process the database is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A. Create three new perspectives named InvoiceDate, DueDate, and PaymentDate.

B. Create cube dimensions named InvoiceDate, DueDate, and PaymentDate by using the existing Date dimension in the database.

C. Add three attributes named InvoiceDate, DueDate, and PaymentDate to the existing Date dimension in the database.

D. Create three independent dimensions named InvoiceDate, DueDate and PaymentDate and then link all three of them to the Accounts Receivable measure group.

正確答案: B

問題5

You are modifying a SQL Server Analysis Service (SSAS) cube.
The cube consists of a single measure group that contains the following measures:
*Total Quantity On Hand
*Average Quantity On Hand
The measure group has a single partition that uses the MOLAP storage mode.
You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real-time and that Average Quantity On Hand measure is updated hourly.
What should you do?

A. Create a new measure group for the Average Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.

B. Change the storage mode of the partition to use proactive caching with minimum latency.

C. Create a new measure group for the Total Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.

D. Create an XMLA script that will process the cube and then use SQL Server Agent to execute the script continuously.

正確答案: C

問題6

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

A. UNIQUENAME ( )

B. USERNAME ( )

C. USERID ( )

D. CUSTOMDATA ( )

E. LOOKUPVALUE ( )

正確答案: B

問題7

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

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

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

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

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

正確答案: C

問題8

You install SQL Server Reporting Services (SSRS).
You need to restore a copy of the symmetric key.
Which command should you run?

A. rskeymgmt -d

B. rskeymgmt -a -f %temp%\rs.key -p Password1

C. rskeymgmt -i

D. rskeymgmt -e -f %temp%\rs.key -p Password1

正確答案: B

問題9

You need to identify the reports that produce the errors that Marc is receiving.
What should you do?

A. Search the ReportServerService_<timestamp>.log file for errors.

B. Use the Windows Event Viewer to search the Application log for errors.

C. Write a query by using the Execution Log 3 view in the report server database.

D. Write a query by using the Subscriptions table in the report server database.

正確答案: C

問題10

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations. The calculations are used to calculate the budget and forecast for the current quarter.
You need to hide the tables and columns.
What should you do?

A. Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide option.

B. After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Visible property to True.

C. Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide from Client Tools option.

D. After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Enabled property to False.

正確答案: C

問題11

DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) tabular project based on a Microsoft Azure SQL Database database. The ProcessingOption property for the project is set to Do Not Process.
Several calculated columns have been added to a table. The project has been deployed to the production server.
You need to ensure that newly added data is processed on the production server.
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.)

正確答案:

Explanation:
Box 1:

Box 2:

Box 3:

Note:
* To process a table
* In SQL Server Management Studio, in the tabular model database which contains the table you want to process, expand theTablesnode, then right-click on the table you want to process, and then clickProcess Table.
* In theProcess Tabledialog box, in theModelistbox, select one of the following process modes:
Etc-

問題12

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 Data processing option. Then process the database with the Process Defrag processing option.

B. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Full processing option.

C. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Defrag processing option. Then process the database with the Process Recalc processing option.

D. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Recalc processing option.

E. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Data processing option.

正確答案: A

最新的Microsoft Implementing Data Models and Reports with Microsoft SQL Server - 070-466免費考試真題

聯系我們

站內鏈接

最新更新