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. The Attribute Form maps to the same column name in multiple tables






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






3. Store info on relationships between 2 or more tables (attributes) - like an Index table.






4. A new tool for project design tasks - used for fine-tuning a project after initial creation






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






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






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






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






9. Groupings of directly related attributes. Also commonly known as "dimensions".






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






11. View Filters can only ___________.






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






13. AND - OR - OR NOT - AND NOT






14. You can _____________ in the Architect Graphical Interface.






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






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






17. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.






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






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






20. Reduced number of JOINS in the generated SQL






21. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






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






23. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen






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






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






26. A subset of a report that users can manipulate without altering the SQL


27. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






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






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






30. Homogeneous - Heterogeneous






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






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






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






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






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






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






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






38. Less storage - Simple SQL - Complex ETL






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






40. Used to modify a Report






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






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






43. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






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






45. A shortcut to an existing Object in a Project






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






47. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






48. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded






49. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters






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