最新的Microsoft SQL Server 2012認證 70-466考試題庫

問題1

You are managing a SQL Server Reporting Services (SSRS) instance.
A website 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 and RSWindowsNegotiate

B. RSWindowsBasic

C. RSWindowsKerberos only

D. RSWindowsKerberos and RSWindowsNTLM

正確答案: B

說明：（僅 VCESoft 成員可見）

問題2

You have a SQL Server Reporting Services (SSRS) instance. The instance has a report that displays 3 million records.
Users report that they experience performance issues when they use the report.
You need to ensure that the report renders as quickly as possible.
Which two actions should you perform? Each correct answer presents part of the solution.

A. Enable versioning.

B. Enable caching.

C. Create snapshots.

D. Implement pagination.

E. Enable report history.

正確答案: A,B

問題3

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.

正確答案:

問題4

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. Search the ReportServerService_<timestamp>.log file for errors.

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

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

正確答案: C

問題5

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

A. ByAccount

B. Sum

C. AverageOfChildren

D. Average

正確答案: C

問題6

You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML.
The report includes a dataset with fields named Description, Price, and Color. The report layout includes a table that displays product details and also includes columns named Description, Price, and Color.
You need to modify the report so that users can sort products by the Price column.
What should you do?

A. Set the SortExpression property to =Fields!Price.Name for the Price text box.

B. Set the SortExpression property to =Fields!Price.Value for the Price text box.

C. Add a custom action to the Price text box.

D. Set the SortExpression value to = Fields!Price.Description for the Price text box.

正確答案: B

問題7

You are developing a SQL Server Analysis Services (SSAS) tabular database.
To maximize performance, the queries must be resolved by using cache unless otherwise specified in the connection string.
You need to configure the appropriate query mode.
Which query mode should you select?

A. DirectQuery

B. In-Memory with DirectQuery

C. DirectQuery with In-Memory

D. In-Memory

正確答案: B

問題8

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

B. Create a KPI based on the OrderQuantity column and then set the target value. Check in the changes before the next release cycle.

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

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

正確答案: A

問題9

You are troubleshooting query performance for a SQL Server Analysis Services (SSAS) cube.
A user reports that a Multidimensional Expressions (MDX) query is very slow.
You need to identify the MDX query statement in a trace by using SQL Server Profiler.
Which event class should you use?

A. Query Begin

B. Execute MDX Script Begin

C. Query Subcube

D. Get Data From Aggregation

E. Progress Report Begin

F. Calculate Non Empty Begin

正確答案: A

問題10

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The City column exists in the Geography table that is related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?

A. City:=RELATED(Geography[City])

B. City :=RELATEDTABLE (Geography)

C. =Geography[City]

D. =RELATED(Geography[City])

E. =RELATEDTABLE(Geography)

F. City:=Geography[City]

正確答案: D

問題11

You need to configure the partition storage settings to support the reporting requirements.
Which partition storage setting should you use?

A. LazyAggregations

B. Regular

C. DirectQuery

D. Low-latency MOLAP

E. High-latency MOLAP

F. In-Memory

正確答案: D

問題12

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The City column exists in the Geography table that is related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?

A. =RELATED(Geography.City)

B. City:=VALUES(Geography[City])

C. City:= LOOKUP(Geography[City],Geography[GeographyKey],[GeographyKey])

D. =VALUES(Geography[City])

E. City:= LOOKUPVALUE(Geography[City],Geography[GeographyKey],[GeographyKey]) C .=RELATED(Geography[City])

正確答案: A

說明：（僅 VCESoft 成員可見）

問題13

A large manufacturing company has manufacturing plants in many states. Each state has a dedicated SQL Server instance that stores its manufacturing data. Each SQL Server instance is configured identically and all instances have identical database structures.
You are developing a daily report that summarizes information on manufacturing activity.
The report has the following requirements:
*It must have a stale name as one of the report parameters.
*It must provide a daily summary of manufacturing activity of a selected state.
*It must require minimal development and maintenance effort.
You need to develop the report to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A. Use a shared data source that defines an expression-based connection string based on the state parameter.

B. Use a report-specific data source that defines an expression-based connection string based on the state parameter.

C. Build a centralized data repository, schedule a regular Extract Transform, and Load (ETL) process on all manufacturing data, and then use the repository to generate the report.

D. Build one report for each state and instruct users to execute reports as needed.

正確答案: B

問題14

You need to deploy the StandardReports project at the end of the current business day.
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 XMLA deployment script and run it at the end of the day.

B. Deploy the project from SQL Server Data Tools (SSDT) at the end of the day.

C. Use the Analysis Services Deployment utility to create an XMLA deployment script and run it at the end of the day.

D. Use the Analysis Services Deployment wizard to create an MDX deployment script and run it at the end of the day.

正確答案: A,B

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

最新更新

站內鏈接

聯系我們