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. Simple - Compound - Nested - Derived






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






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






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






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






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






7. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






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






9. ID columns - Description columns - Fact columns






10. Used to modify a Report






11. It contains the ID column of the parent attribute






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






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






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






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






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






17. View Filters can only ___________.






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






19. The Attribute Form maps to the same column name in multiple tables






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






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






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






23. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






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






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






27. All report-level options overwrite ___________.






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






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






30. OLTP data storage measure






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






32. Grid View - Graph View - Grid/Graph View - SQL View






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






34. Descriptive data that provides context for Facts.






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






36. Create the Project Source - Create the Database Instance






37. You can _____________ in the Architect Graphical Interface.






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






39. Tables - Facts - Attributes - Hierarchies






40. Enables you to lock column headers so that they always appear when scrolling






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






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






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






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






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






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






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






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






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






50. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked