We're so confident of our products that we provide no hassle product exchange.
Microsoft 70-460 Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence |
| Exam Number: | 70-460 |
| Available Languages: | English, Japanese, Simplified Chinese (limited availability in some regions) |
| Passing Score: | 700 (on a 1000 scale) |
| Related Certifications: | MCSE: Business Intelligence MCITP: Business Intelligence Developer 2008 |
| Exam Price: | USD 165 (varies by region) |
| Certificate Validity Period: | Retired (no longer available) |
| Exam Duration: | 120-150 |
| Real Exam Qty: | 40-60 |
| Exam Format: | Multiple choice, Case studies, Scenario-based questions |
| Sample Questions: | Microsoft 70-460 Sample Questions |
| Exam Way: | Onsite or online proctored exam (varies by testing provider) |
| Pre Condition: | Recommended experience with SQL Server 2008 BI components and MCITP: Business Intelligence Developer 2008 certification |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/retired-certifications |
Microsoft 70-460 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Implement BI Solutions and Security | - Configure security for BI solutions - Monitor and optimize BI performance - Manage deployment and environment configuration |
| Topic 2: Develop and Implement ETL Solutions | - Create and configure SSIS packages - Deploy and troubleshoot ETL solutions - Manage control flow and data flow tasks |
| Topic 3: Develop OLAP Models | - Develop tabular models - Design and build SSAS multidimensional models - Implement measures, KPIs, and dimensions |
| Topic 4: Design and Implement a Data Warehouse | - Design data warehouse schema (star/snowflake) - Implement ETL processes using SSIS - Manage data quality and data cleansing |
| Topic 5: Develop and Deploy Reports | - Configure report parameters and subscriptions - Deploy and manage reports - Create reports using SQL Server Reporting Services (SSRS) |
Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence Sample Questions:
1. After you deploy the RegionalSales report, you attempt to configure the subscriptions.
You discover that the subscription creation screen does not display the option to deliver the
report by email.
You need to ensure that subscriptions can be delivered by using email.
What should you do?
A) Modify the Rsmgrpolicy.config file.
B) From Central Administration, modify the properties of the Reporting Service Application.
C) From Central Administration, modify the SMTP settings of the SharePoint Server server farm.
D) Modify the Rssrvrpolicy.config file.
2. 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) In the Expression dialog box for the Price text box. enter the =SortByFieldslPrice, Value expression.
D) Add a group for the Price field.
3. You are designing a SQL Server Reporting Services (SSRS) report to display product names and their year-to-date (YTD) sales quantity. YTD sales quantity values are classified in three bands: High Sales, Medium Sales, and Low Sales.
You add a table to the report. Then you define two columns based on the fields named ProductName and YTDSalesQuantity.
You need to set the color of the product text to red, yellow, or blue, depending on the value of the YTD sales quantity values.
What should you do?
A) Add an indicator to the table.
B) Use an expression for the Font property of the text box.
C) Use an expression for the TextDecoration property of the text box.
D) Use an expression for the Color property of the text box.
E) Use an expression for the Style property of the text box.
4. You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power View solution.
You need to grant permission for salespersons to view only the data based on their sales territory.
What should you do?
A) Create a member and then create a Data Analysis Expressions (DAX) filter.
B) Create a member and then create a Multidimensional Expressions (MDX) filter.
C) Use SQL Server Management Studio to create a role. Then create a Data Analysis Expressions (DAX) filter.
D) Use SQL Server Management Studio to create a role. Then create a Multidimensional Expressions (MDX) filter.
5. You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a Windows Azure SQL Database database.
The report must use a map to display the location and status of the ATMs as shown in the following exhibit. (Click the Exhibit button.)
You need to ensure that the report displays only a user selected map region.
Which source of spatial data should you use for the map?
A) SQL Server spatial query
B) Bing Maps layer
C) ESRI shape file
D) Map gallery
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: B | Question # 3 Answer: D | Question # 4 Answer: C | Question # 5 Answer: A |
By Wilbur
