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

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 2

You need to ensure the marketing department is able to implement cross-selling requirements. Which data mining model should you choose?

Microsoft Time Series ✘ Microsoft Nave Bayes ✘ Microsoft Neural Networks ✘ Microsoft Association ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to ensure the Point-Of-Sales system supports cross-selling functionality. What should you do?

Use ADO.NET to execute a Transact-SQL statement to retrieve the data. ✘ Use ADOMD.NET to execute a Data Mining Extensions (DMX) query to retrieve the data. ✘ Use ADOMD.NET to execute a Multidimensional Expressions (MDX) query to retrieve the data. ✘ Use Microsoft SQL Server 2005 Integration Services (SSIS) package that runs overnight to execute a datamining query task. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to calculate the average quantity of products sold by each store. What should you do?

Create a calculated member within the Measures hierarchy. Divide the Quantity measure by a distinct count of store members. ✘ Create a calculated member within the StoreID hierarchy of the Store dimension. Divide the Quantitymeasure by a distinct count of store members. ✘ Create a calculated field within the SaleQuery table inside the data source view. Divide the QuantitySoldcolumn by a distinct count of the number of stores. ✘ Create a calculated field within the Store data table inside the data source view. Sum the QuantitySoldcolumn by that store and divide by the number of sales made. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to include the attributes of the Region dimension within the SSRS report. What should you do?

Join the Region dimension to the Sales measure group by using a Fact relationship type. ✘ Join the Region dimension to the Sales measure group by using a Regular relationship type. ✘ Join the Region dimension to the Sales measure group by using a Referenced relationship type. ✘ Join the Region dimension to the Sales measure group by using a Many-to-Many relationship type. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to implement the security requirements of the SupplierData report. What should you do?

Use the Internet Information Services (IIS) security to prohibit access to the new report. ✘ Within Report Manager, grant Browser rights and Report Builder rights on the new sales report to the usersof the management group. ✘ Create a new user group and add all management users to this group. Within Report Manager, grantBrowser rights on the report to the management group. ✘ Create a new user group and add all management users to this group. Use the file system security to grantaccess to the report for the management group. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to alter the StaffMember dimension and measure group relationship to resolve the processing errors. You also need to meet the requirements for handling NULL values in the StaffMember dimension. What should you do?

Alter the relationship to map NULL to zero or blank. Add a default member to the StaffMember dimension. ✘ Alter the relationship to map NULL to Unknown. Design the Unknown Member functionality within thedimension. ✘ Alter the relationship to error upon NULL key values. Design the custom error configuration in theStaffMember dimension. ✘ Alter the relationship to preserve NULL values. Design the Missing Member Mode functionality ofMultidimensional Expressions (MDX) in the dimension. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to design the Monthly Sales Items report for the regional managers. Certkey.com - Make You Succeed To Pass IT Exams Certkey 70-446 What should you do?

Create a single report that uses the caching functionality of SSRS. ✘ Create a single report in SSRS by using a Matrix format that has the lower levels of grouping collapsed bydefault. ✘ Create a single parent report that displays the highest level of aggregate data. Embed subreports for eachgrouping of child data. ✘ Create a summary report. Add drillthrough functionality to the summary report to link to separate detailedreports for each grouping of data. ✔

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 blank rows in the PivotTable reports are hidden. Which property of the Product dimension should you set?

Set the AttributeHierarchyEnabled property to false. ✘ Set the HideMemberIf property to NoName. ✘ Set the AttributeHierarchyVisible property to true. ✘ Set the AttributeHierarchyVisible property to false. ✔

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 create a data mining model to support the SalesProjections report. How should you modify the SSAS solution?

Create a mining model on the existing Time Of Day dimension by using the Microsoft Time Series algorithm. ✘ Create a Date dimension within the SSAS solution. Use the new Date dimension within a Microsoft TimeSeries data mining model. ✘ Create a Key Performance Indicator (KPI) that displays sales trends. ✘ Create a data mining model on the existing Store dimension by using the Microsoft Time Series algorithm.Certkey.com - Make You Succeed To Pass IT Exams Certkey 70-446 ✔

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 2

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