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. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






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






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






4. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






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






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






7. Subtotals reflect accumulations at selected attribute levels






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






9. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






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






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






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






13. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






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






15. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






16. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






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






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






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






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






21. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.






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






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






24. Less storage - Simple SQL - Complex ETL






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






26. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






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






29. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






30. Using the Prompt Generation Wizard - Inside the Report Editor






31. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






32. AND - OR - OR NOT - AND NOT






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






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






35. Metrics you create within a report using only those objects in the report.






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






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






38. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






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






40. Used to "fine-tune" your Project






41. More storage - Complex SQL - Simple ETL






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






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






44. What tool do you use to create the Metadata shell?






45. A shortcut to an existing Object in a Project






46. Enables you to format report values based on a condition - such as highlights - font colors - etc.






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






48. Level of OLTP integration






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






50. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:



Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Most popular tests