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. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






2. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






3. Must have Subtotals enabled - or you won't see any data for higher-level attributes






4. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






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






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






7. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






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






9. Formula - Level (Dimensionality) - Conditionality - Transformation






10. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






11. Compound - Homogeneous - Heterogeneous






12. A shortcut to an existing Object in a Project






13. Grid View - Graph View - Grid/Graph View - SQL View






14. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






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






16. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






17. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).






18. OLAP data storage measure






19. It contains the ID column of the parent attribute






20. One that uses 2 or more columns as its ID






21. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






22. Groupings of directly related attributes. Also commonly known as "dimensions".






23. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






24. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)






25. Primary keys






26. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema






27. It contains the ID and DESC columns of all higher-level attributes






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






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






30. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






31. Enables you to rearrange the columns and rows in a report.






32. The actual column name for a fact. Every fact must have at least 1 expression.






33. 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






34. Columns - Tables






35. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






36. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






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






38. What tool do you use to create the Metadata DSN connection?






39. Template - Filter - View of a Report






40. Tables - Facts - Attributes - Hierarchies






41. Level of OLAP integration






42. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






43. A development environment to create BI applications - allowing users to edit the Metadata database






44. Metrics aggregate on the lowest-level attribute __________.






45. You can e-mail reports by going to _____






46. The System Hierarchy is automatically updated whenever you make a change to an __________________.






47. Direct: 2-tier - Server: 3-tier






48. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.






49. Used for - Initially populating the Metadata - Creating schema objects






50. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.