Microsoft-Upgrade Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008 Set 4

Question - 15 Maximum mark : - 27

Home
All Exams
Microsoft-Upgrade Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008 Online Practice Exams
Microsoft-Upgrade Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008 Set 4

You need to design a storage mode for the ProductOrderStatus measure group. What should you do?

Use ROLAP for the Historical partition and MOLAP for the CurrentDay partition. ✘ Use MOLAP for the Historical partition and ROLAP for the CurrentDay partition. ✘ Use ROLAP for the Historical partition and Automatic MOLAP for the CurrentDay partition.Certkey.com - Make You Succeed To Pass IT Exams Certkey 70-446 ✘ Use HOLAP for the Historical partition and Low-latency MOLAP for the CurrentDay partition. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design a subscription delivery plan that meets the requirements of the Sales Personnel report. What should you do?

Create two data-driven subscriptions. Place e-mail recipient and report parameters in one table. Place filename and path in a second table. ✘ Create two standard subscriptions. Specify the delivery method and e-mail address list or file locationappropriately in each subscription. ✘ Place delivery method, e-mail address or filename and path, and report parameters in a table for each user.Create one data-driven subscription based on the data in this table. ✘ Place delivery method, e-mail address, and report parameters in a table for each user.Place filename, path, and report parameters in a second table for each user. Create one data-driven subscription based on the data in the two tables. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to select the edition of SQL Server 2005 that will meet all technical and business requirements. Which edition should you use?

Microsoft SQL Server 2005 Express Edition ✘ Microsoft SQL Server 2005 Standard Edition ✘ Microsoft SQL Server 2005 Enterprise Edition ✘ Microsoft SQL Server 2005 Workgroup Edition ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to provide the finance department with a version of the cube that only exposes the data that the department requires. What should you do?

Design a new perspective within your cube. Within the perspective, enable the measures and attributes that are used by the finance department. ✘ Design a new role within the SSAS solution and move the users from the finance department into this role.Within the role, enable the measures and attributes that are used by the finance department. ✘ Design new versions of every dimension within the SSAS solution and include only the attributes that thefinance department uses. Make the new dimensions available to the users from the finance department only. ✘ Modify each dimension by setting the AttributeHierarchyVisible property to true for the attributes that areused by the finance department. Within the cube, set the DisplayFolder property to true for those measures that are used by the finance department. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to ensure that the sales department is able to compare sales against target sales. What should you do? Certkey.com - Make You Succeed To Pass IT Exams Certkey 70-446

Design a calculated measure that shows a current against historical comparison of sales against target sales. ✘ Design a calculated measure that shows sales minus target sales. Ensure that the Parent hierarchy is set toMeasures. ✘ Design a Key Performance Indicator (KPI) that shows sales in the value expression, target sales in the goalexpression, and sales against target sales in the status expression. ✘ Design a Key Performance Indicator (KPI) that shows sales in the status expression, sales against targetsales in the goal expression, and target sales in the value expression. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to ensure that repeat invocations of the same report do not produce different results during working hours. What should you do?

Use Automatic MOLAP storage and set the rebuild interval to 24 hours. Enable ROLAP aggregations. ✘ Use MOLAP storage and create a scheduled task to process the dimensions and cubes after the ETLprocesses are completed. ✘ Use RealTime ROLAP storage to update the cache every 24 hours. Use a tracking table to indicate thestatus of the ETL processes and set a notification on the tracking table. ✘ Use RealTime HOLAP storage to update the cache every 24 hours. Use a tracking table to indicate thestatus of the ETL processes and set a notification on the tracking table. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You add the SalesPerson dimension to the cube during development. You deploy and execute a Process Full against the SSAS solution. You then run a Client Shipment report that summarizes shipments by date and customer. You notice that the Client Shipment report previously took four seconds to run, but now takes 40 seconds. You need to improve the report response time of the Client Shipment report. Which strategy should you choose?

Run a Process Index against the new dimension. ✘ Rerun the Aggregation Design Wizard to recreate aggregations. ✘ Recreate aggregations by using the Usage-based Optimization Wizard. ✘ Ensure that the new dimension has the AttributeHierarchyOptimizedState property set to FullyOptimized. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to ensure that all members of the sales teams can access the Sales data.

Use SSAS security roles for each Sales team by applying Denied Member Sets in Dimension Data Security. ✘ Use SSAS security roles for each sales team by applying Allowed Member Sets in Dimension Data Security. ✘ Use report security in Microsoft SQL Server 2005 Reporting Services (SSRS). Combine report security withcustom code to restrict data access. ✘ Use role-based security in Microsoft SQL Server 2005 Reporting Services (SSRS) to restrict access tospecific folders that contain the relevant report. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to process the Customer dimension by using the minimum amount of time possible. Which processing option should you use?

Process Full ✘ Process Data ✘ Process Index ✘ Process Update ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

You need to design a subscription delivery plan that meets the requirements of the Sales Personnel report. What should you do?

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Microsoft-Upgrade Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008 Set 4

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner