Microsoft 070-460 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Build OLAP cubes | - Implement calculations
|
| Design and implement tabular models | - Tabular model development
|
| Develop reports | - SQL Server Reporting Services (SSRS)
|
| Design and implement a data warehouse | - Implement ETL processes
|
Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence Sample Questions:
1. You need to implement the aggregation designs for the cube.
What should you do?
A) Use the Aggregation Design Wizard.
B) Implement cache warming in SSAS via an SSIS package.
C) Partition the cube by month.
D) Use the Usage-Based Optimization Wizard.
2. You need to use SQL Server Management Studio (SSMS) to make the SSAS databases available for application testing.
What should you do?
A) Restore the SSAS databases from the latest backup to SSAS01.
B) Script the databases as a Create script to a new window and then execute the script on SSAS01.
C) Detach the SSAS databases from the SSASCluster, and then attach them to SSAS01.
D) Use the Import/Export Wizard to copy the databases from the production server to the development server.
3. You are modifying a star schema data mart that feeds order data from a Microsoft Azure SQL Database database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two large tables that include flags and indicators for some orders. There are 100 different flag columns, each with 10 different indicator values. Some flags reuse indicators. The tables both have a granularity that matches the fact table.
You have the following requirements:
- Allow users to slice data by all flags and indicators. - Modify the date dimension table to include a surrogate key of a numeric data type and add the surrogate key to the fact table. - Use the most efficient design strategy for cube processing and queries.
You need to modify the schema.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A) Define the surrogate key as a BIGINT data type. Combine the distinct flag/indicator combinations into a single dimension.
B) Define the surrogate key as an INT data type. Combine the distinct flag/indicator combinations into a single dimension.
C) Define the surrogate key as a BIGINT data type. Create a single fact dimension in each table for its flags and indicators.
D) Define the surrogate key as an INT data type. Create a single fact dimension in each table for its flags and indicators.
4. You need to grant appropriate permissions to the SSISOwners SQL Server login. What should you do?
A) Map the login to the SSISDB database. Assign the user to the db.ssisadmin role.
B) Map the login to the msdb database. Assign the user to the db_owner role.
C) Map the login to the SSISDB database. Assign the user to the ssis.admin role.
D) Map the login to the SSISDB database. Assign the user to the db_owner role.
E) Map the login to the msdb database. Assign the user to the db_ssisadmin role.
F) Map the login to the msdb database. Assign the user to the ssis_admin role.
5. You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube.
The cube contains a Key Performance Indicator (KPI) to show if a salesperson's sales are off target, slightly off target, or on target.
You need to add a report item that visually displays the KPI status value as a red, yellow, or green circle.
Which report item should you add?
A) Radial Gauge
B) Indicator
C) Data Bar
D) Sparkline
E) Linear Gauge
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: B | Question # 3 Answer: B | Question # 4 Answer: C | Question # 5 Answer: B |
1368 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
