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. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






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






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






4. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






5. Homogeneous - Heterogeneous






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






7. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






8. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






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






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






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






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






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


14. The default entry-points.






15. Less storage - Simple SQL - Complex ETL






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






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






18. A shortcut to an existing Object in a Project






19. Metrics you create within a report using only those objects in the report.






20. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






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






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






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






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






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






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






27. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






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






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






31. Schema Objects - Application Objects - Configuration Objects






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






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






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






35. OLTP data storage measure






36. The Attribute Form maps to different column names in multiple tables






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






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






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






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






41. Facts associated to different column names in 2 or more tables






42. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






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






44. Compound - Homogeneous - Heterogeneous






45. Used to modify a Report






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






47. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.






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






49. All Attributes must have an _______.






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