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. Direct: 2-tier - Server: 3-tier






2. You can _____________ in the Architect Graphical Interface.






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






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






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


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






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






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






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






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






11. A shortcut to an existing Object in a Project






12. More storage - Complex SQL - Simple ETL






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






14. A development environment to create BI applications - allowing users to edit the Metadata database






15. Homogeneous - Heterogeneous






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






17. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






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






19. OLAP retains data ________






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






21. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






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






24. View Filters are saved with the _____________.






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






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






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






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






29. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






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






31. Prompts to select a single value on which to qualify a date - number or text string.






32. Used to limit a possibly overwhelming set of potential prompt answers






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






34. Attribute Creation Wizard - Attribute Editor






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






36. Extraction - transformation - loading






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






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






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






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






41. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






45. Used for - Initially populating the Metadata - Creating schema objects






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






47. Simple - Derived






48. It contains the ID column of the parent attribute






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






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