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. To see data at completely different levels - other than that of the original Grid or Graph






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






3. Compound - Homogeneous - Heterogeneous






4. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






5. A shortcut to an existing Object in a Project






6. Specifies a condition data must meet in order to be included in a report






7. Subtotals reflect accumulations at selected attribute levels






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






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






10. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






11. You can _____________ in the Architect Graphical Interface.






12. Prompts to select a single value on which to qualify a date - number or text string.






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






14. All Attributes must have an _______.






15. A method of organizing the appearance of report results in a Grid report based on a criteria






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


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






18. OLAP data storage measure






19. It contains the ID column of the parent attribute






20. Primary keys






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






22. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






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






24. A condition data must meet in order to be included in a report. Does affect the SQL.






25. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






26. The logical associations between attributes that exist based on a business rule






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






28. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






30. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






31. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






32. To define the level of aggregation for a specific metric - Used for qualifications






33. Level of OLAP integration






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






35. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






36. Level of OLTP integration






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






38. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






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






40. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






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






42. Specifies what info to retrieve from a data-warehouse - and how to display it






43. How users can share comments for reports to other users






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






45. Top menu/dropdowns - Toolbar - Right-click popup menus






46. It contains the ID column of all higher-level attributes






47. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded






48. Simple - Derived






49. Homogeneous - Heterogeneous






50. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h