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. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






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






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






4. Reduced number of JOINS in the generated SQL






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






6. Schema Objects - Application Objects - Configuration Objects






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






8. ID columns - Description columns - Fact columns






9. OLTP retains data ________






10. View Filters are saved with the _____________.






11. OLTP data storage measure






12. You can _____________ in the Architect Graphical Interface.






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






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






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






16. Enables you to select which tables from the data-warehouse to store in the Metadata database






17. OLAP retains data ________






18. User requirements - Existing source data - Technical and performance considerations






19. OLAP Services does not add any ______ to the report query.






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






21. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






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






23. AND - OR - OR NOT - AND NOT






24. Homogeneous - Heterogeneous






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






26. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






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






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






29. Less storage - Simple SQL - Complex ETL






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






31. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






32. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






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






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






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






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






37. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






38. The default entry-points.






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






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






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






42. Filter definition prompts - Object prompts - Value prompts - Level prompts






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






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






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






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






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






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






49. Used to "fine-tune" your Project






50. Facts associated to different column names in 2 or more tables