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. OLAP data storage measure






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






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






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






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






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






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






8. The logical associations between attributes that exist based on a business rule






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


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






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






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






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






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






15. Facts - Attributes - Hierarchies






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






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






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






19. Template - Filter - View of a Report






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






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






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






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






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






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






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






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






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






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






30. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






31. Simple - Compound - Nested - Derived






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






33. Level of OLTP integration






34. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






35. All Attributes must have an _______.






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






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






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






39. Folder List - Object Viewer - Shortcut Bar






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






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






42. ID columns - Description columns - Fact columns






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






44. Formula - Level (Dimensionality) - Conditionality - Transformation






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






46. View Filters are saved with the _____________.






47. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






48. It contains the ID column of all higher-level attributes






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






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