Test your basic knowledge |

Certified Project Designer Cpd

Instructions:
  • Answer 50 questions in 15 minutes.
  • If you are not ready to take this test, you can study here.
  • Match each statement with the correct term.
  • Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






2. The Attribute Form maps to different column names in multiple tables






3. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






4. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen






5. Simple - Derived






6. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






7. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities






8. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






9. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






10. OLAP data storage measure






11. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






12. Enables you to select and display subsets of a report as separate pages.






13. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






14. A user interface for creating and maintaining a BI environment






15. You can _____________ in the Architect Graphical Interface.






16. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






17. User reporting requirements - Query performance - Data volume - DB Maintenance






18. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






19. Grid View - Graph View - Grid/Graph View - SQL View






20. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






21. A subset of a report that users can manipulate without altering the SQL

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


22. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






23. The Attribute Form Expression that maps to a single column - no matter the number of tables






24. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.






25. Creating multiple attributes quickly. Used during the initial project creation.






26. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.






27. ID columns - Description columns - Fact columns






28. Facts associated to the same column name in 1 or more tables






29. The unique values of an attribute obtained from the data-warehouse






30. Compound - Homogeneous - Heterogeneous






31. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






32. Used to "fine-tune" your Project






33. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






34. Descriptive data that provides context for Facts.






35. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






36. A feature that enables users to delivers reports to the history list - cache or mobile






37. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






38. View Filters are saved with the _____________.






39. Subtotals reflect accumulations at selected attribute levels






40. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






41. Allow you to interact with the BI system - logically organize data to analyze complex relationships






42. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents






43. Create the Project Source - Create the Database Instance






44. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






45. Simple - Compound - Nested - Derived






46. OLTP data storage measure






47. Facts - Attributes - Hierarchies






48. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






49. Tables - Facts - Attributes - Hierarchies






50. You must select "Other directions" when drilling attributes while viewing a report






Can you answer 50 questions in 15 minutes?



Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests