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

Question - 15 Maximum mark : - 29

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 1

You need to maintain the partitions on the ProductOrderStatus measure group. What should you do? Certkey.com - Make You Succeed To Pass IT Exams Certkey 70-446

Create a Microsoft SQL Server 2005 Integration Services (SSIS) package that alters the partition queries and processes aggregated partitions every evening. ✘ Enable proactive caching on the partitions. Set the cache to update periodically with a latency of 24 hours. ✘ Set the rebuild interval of the partitions to 36 hours. Create a Microsoft SQL Server 2005 IntegrationServices (SSIS) package that processes aggregated partitions every evening. ✘ Enable proactive caching on the ProductOrderStatus measure group. Set scheduled polling that re-processes the measure group whenever the system dates change. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to minimize the amount of space required for the SSAS cube. You must achieve this goal while maximizing the performance of business user queries. What should you do?

Within the data source view, replace the Shipment data table with a named query that orders results by descending shipment date. ✘ Create a separate perspective within your SSAS solution. Ensure that the only selected measure group isthe Shipment measure group. Ensure that only the Key attributes are included from each dimension. ✘ Use ROLAP storage on the SSAS cube. ✘ Create separate partitions on the Shipment measure group. Use a query in each partition to separate dataon the basis of Shipment date. Ensure that the partition that contains the present calendar month is aggregated. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to modify the cube to support the Shipping Work by Location report. What should you do?

Add the Geography dimension twice to the cube. Create regular relationships between the two cube dimensions and the Shipment measure group. ✘ Add the Geography dimension once to the cube. Create a many-to-many Relationship type between theGeography dimension and the measure group. ✘ Add the Geography dimension once to the cube. Create a Referenced Relationship type between theGeography dimension and the measure group. ✘ Add the Geography dimension once to the cube. Set measure group bindings to the two Geographycolumns within the measure group tables. ✔

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 new sales manager is able to view clients within only the North and South regions.

Add a Denied member set for the West clients to NorthRole. ✘ Add an Allowed member set for the South clients to NorthRole. ✘ Create a new role for the sales manager and add a Denied member set for the South clients. ✘ Create a new role for the sales manager and add an Allowed member set for the South Certkey.com - MakeYou Succeed To Pass IT Exams Certkey 70-446 clients. Remove the sales manager from SouthAndWestRole. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to ensure the Client dimension is able to support new orders and new client records. Which setting should you configure?

ROLAP storage ✘ Lazy aggregations ✘ Write Enabled property ✘ Unknown Member functionality ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to ship a copy of the FabrikamASDB metadata to Contoso, Ltd. What should you do?

Use the Synchronize Database Wizard. ✘ Describe the FabrikamASDB database in an XML for Analysis (XMLA) script. Ship the script to Contoso,Ltd. ✘ Copy the folder structure of the live SSAS solution to a compressed file. Ship the compressed file toContoso, Ltd. ✘ Backup the FabrikamASDB database. Run a Process Full on the restored database. Ship the database toContoso, Ltd. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to select appropriate processing methods for the EmployeeAssignment measure group and the Employee dimension. Which method should you choose?

Run a Process Update against the Employee dimension. Run a Process Full against the EmployeeAssignment measure group. ✘ Run a Process Full against the EmployeeAssignment measure group. Run a Process Update against theEmployee dimension. ✘ Run a Process Full against the Employee dimension. Run a Process Incremental against theEmployeeAssignment measure group. ✘ Run a Process Incremental against the EmployeeAssignment measure group. Run a Process Full againstthe Employee dimension. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to maintain the partitions on the ProductOrderStatus measure group. What should you do?

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to meet the requirements of the accounts team. What should you do?

Set the Dimension type to Currency. ✘ Set the Currency member name as a unique attribute. ✘ Hide non-leaf data within the Currency dimension key attribute. ✘ Disable the All member of the Currency dimension key attribute. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

You need to help the HR team improve the resource allocation process. What should you do?

Perform data mining regression analysis to identify the correlation between productivity and specific employee groups. ✘ Set the GroupingBehaviour property within the Employee dimension. ✘ Partition the EmployeeAssignment measure group into groups by department. ✘ Use the Fuzzy Grouping task in Microsoft SQL Server 2005 Integration Services (SSIS). ✔

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 1

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