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. Create the Project Source - Create the Database Instance






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






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






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






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






6. Compound - Homogeneous - Heterogeneous






7. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






8. Less storage - Simple SQL - Complex ETL






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






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






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


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






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






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






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






16. You can _____________ in the Architect Graphical Interface.






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






18. Top menu/dropdowns - Toolbar - Right-click popup menus






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






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






21. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.






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






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






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






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






26. OLTP data storage measure






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






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






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






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






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






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






33. It contains the ID column of the parent attribute






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






35. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






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






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






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






39. Simple - Compound - Nested - Derived






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






41. OLTP retains data ________






42. Used to modify a Report






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






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






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






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






47. Grid View - Graph View - Grid/Graph View - SQL View






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






49. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






50. Using the Prompt Generation Wizard - Inside the Report Editor