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. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






3. Metrics aggregate on the lowest-level attribute __________.






4. Tables - Facts - Attributes - Hierarchies






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






6. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






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






8. Less storage - Simple SQL - Complex ETL






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






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






11. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






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






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






14. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






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






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






17. Schema Objects - Application Objects - Configuration Objects






18. How users can share comments for reports to other users






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






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






21. Direct: 2-tier - Server: 3-tier






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






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






24. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






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






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






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






28. Must have a one-to-one relationship with all other forms.






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






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






31. Columns - Tables






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






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






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






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






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






37. It contains the ID column of the parent attribute






38. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.






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






40. View Filters can only ___________.






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






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






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






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






45. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






46. Reduced number of JOINS in the generated SQL






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






48. View Filters are saved with the _____________.






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






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