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. Extraction - transformation - loading






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






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






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






5. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






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






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






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






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






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






11. Enables you to rearrange the columns and rows in a report.






12. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






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






14. More storage - Complex SQL - Simple ETL






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






16. Simple - Compound - Nested - Derived






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






18. Homogeneous - Heterogeneous






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






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






21. Create the Project Source - Create the Database Instance






22. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






24. An environment in which the MSTR Desktop connects directly to the Metadata database.






25. Grid View - Graph View - Grid/Graph View - SQL View






26. Metrics that perform multiple aggregations; one calculation inside of another.






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






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






29. It contains the ID column of the parent attribute






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






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






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






33. Less storage - Simple SQL - Complex ETL






34. Groupings of directly related attributes. Also commonly known as "dimensions".






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






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






37. OLTP data storage measure






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


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






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






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






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






43. Used to "fine-tune" your Project






44. User requirements - Existing source data - Technical and performance considerations






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






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






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






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






49. Reduced number of JOINS in the generated SQL






50. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests