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. Less storage - Simple SQL - Complex ETL






2. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






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






4. ID columns - Description columns - Fact columns






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


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






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






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






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






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






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






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






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






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






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






16. Allow you to interact with the BI system - logically organize data to analyze complex relationships






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






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






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






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






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






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






23. All Attributes must have an _______.






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






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






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






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






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






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






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






31. OLTP data storage measure






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






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






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






35. A method of organizing the appearance of report results in a Grid report based on a criteria






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






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






38. A shortcut to an existing Object in a Project






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






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






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






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






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






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






45. Compound - Homogeneous - Heterogeneous






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






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






48. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.






49. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






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