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. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






2. Subtotals reflect accumulations at selected attribute levels






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






4. Used to "fine-tune" your Project






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






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






7. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






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






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






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






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






12. Creating multiple attributes quickly. Used during the initial project creation.






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






14. ID columns - Description columns - Fact columns






15. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema






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






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






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






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






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






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






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






23. You can _____________ in the Architect Graphical Interface.






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






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






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






27. Level of OLTP integration






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






29. Facts associated to the same column name in 1 or more tables






30. It contains the ID and DESC columns of all higher-level attributes






31. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






32. Compound - Homogeneous - Heterogeneous






33. Create the Project Source - Create the Database Instance






34. Must have Subtotals enabled - or you won't see any data for higher-level attributes






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






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






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






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






39. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






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






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






42. The default entry-points.






43. Schema Objects - Application Objects - Configuration Objects






44. Less storage - Simple SQL - Complex ETL






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






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






47. It contains links to specific folders in the Folder List






48. Used to modify a Report






49. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






50. OLAP retains data ________