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






2. Attribute Creation Wizard - Attribute Editor






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






4. Specifies what info to retrieve from a data-warehouse - and how to display it






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






6. You can _____________ in the Architect Graphical Interface.






7. It contains the ID column of the parent attribute






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






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






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






11. OLTP data storage measure






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






13. View Filters can only ___________.






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






15. OLTP retains data ________






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






17. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






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






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






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






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






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






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






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






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






26. AND - OR - OR NOT - AND NOT






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






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






29. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






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






32. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






33. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






34. The Attribute Form maps to the same column name in multiple tables






35. View Filters are saved with the _____________.






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






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






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






39. ID columns - Description columns - Fact columns






40. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






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






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






44. Template - Filter - View of a Report






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






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






47. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






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






49. Simple - Derived






50. Facts - Attributes - Hierarchies