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. Prompts to select a single value on which to qualify a date - number or text string.






2. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






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






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






5. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy






6. Attribute Creation Wizard - Attribute Editor






7. AND - OR - OR NOT - AND NOT






8. OLTP data storage measure






9. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






10. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






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






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






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






14. The default entry-points.






15. To see data at completely different levels - other than that of the original Grid or Graph






16. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






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






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






19. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






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






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






22. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






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






25. All report-level options overwrite ___________.






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






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






28. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






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






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






31. You can _____________ in the Architect Graphical Interface.






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






33. A shortcut to an existing Object in a Project






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






35. View Filters are saved with the _____________.






36. Level of OLTP integration






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






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






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






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






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






42. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






43. To define the level of aggregation for a specific metric - Used for qualifications






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






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






46. Simple - Compound - Nested - Derived






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






48. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






49. The Attribute Form Expression that maps to a single column - no matter the number of tables






50. Primary keys