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. Grid View - Graph View - Grid/Graph View - SQL View






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






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






4. Schema Objects - Application Objects - Configuration Objects






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






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






7. OLTP data storage measure






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






9. A feature that enables users to delivers reports to the history list - cache or mobile






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






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






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






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






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






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






16. Template - Filter - View of a Report






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






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






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






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






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






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






23. Less storage - Simple SQL - Complex ETL






24. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






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






26. More storage - Complex SQL - Simple ETL






27. Level of OLAP integration






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






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






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






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






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






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






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






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






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






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






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






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






40. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






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






42. Create the Project Source - Create the Database Instance






43. What tool do you use to create the Metadata shell?






44. A condition data must meet in order to be included in a report. Does affect the SQL.






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






46. Level of OLTP integration






47. The default entry-points.






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






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






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