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. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






2. Subtotals reflect accumulations at selected attribute levels






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






4. Level of OLTP integration






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






6. View Filters can only ___________.






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






8. User reporting requirements - Query performance - Data volume - DB Maintenance






9. Schema Objects - Application Objects - Configuration Objects






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






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






12. All Attributes must have an _______.






13. Extraction - transformation - loading






14. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






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






16. OLTP retains data ________






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






18. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






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






20. An environment in which the MSTR Desktop connects directly to the Metadata database.






21. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






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






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






24. Columns - Tables






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






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






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


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






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






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






32. Used to modify a Report






33. More storage - Complex SQL - Simple ETL






34. Template - Filter - View of a Report






35. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






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






37. A shortcut to an existing Object in a Project






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






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






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






41. Used to "fine-tune" your Project






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






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






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






45. Simple - Compound - Nested - Derived






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






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






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






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






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