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. Level of OLAP integration






2. Create the Project Source - Create the Database Instance






3. Must have a one-to-one relationship with all other forms.






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






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






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






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






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






9. OLTP retains data ________






10. Compound - Homogeneous - Heterogeneous






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






12. Simple - Derived






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






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






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






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






17. All Attributes must have an _______.






18. Level of OLTP integration






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






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






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






22. Metrics that perform multiple aggregations; one calculation inside of another.






23. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships






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






25. Grid View - Graph View - Grid/Graph View - SQL View






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






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






28. Simple - Compound - Nested - Derived






29. Used to "fine-tune" your Project






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






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






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






33. Attribute Creation Wizard - Attribute Editor






34. The default entry-points.






35. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






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






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






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






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






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






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






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






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






44. Extraction - transformation - loading






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






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






47. Descriptive data that provides context for Facts.






48. Template - Filter - View of a Report






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






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