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






2. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






3. Level of OLTP integration






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






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






6. Tables - Facts - Attributes - Hierarchies






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






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






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






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






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






12. Compound - Homogeneous - Heterogeneous






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






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






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






16. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






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






18. Folder List - Object Viewer - Shortcut Bar






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






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






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






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






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






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






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






26. Descriptive data that provides context for Facts.






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






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






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






30. OLTP data storage measure






31. Specifies a condition data must meet in order to be included in a report






32. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






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


34. A new tool for project design tasks - used for fine-tuning a project after initial creation






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






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






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






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






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






40. All Attributes must have an _______.






41. Facts - Attributes - Hierarchies






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






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






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






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






46. Attribute Creation Wizard - Attribute Editor






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






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






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






50. MS Excel - MS Word - MS Access - PDF - HTML - Plain text