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. The Attribute Form Expression that maps to a single column - no matter the number of tables






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






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






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






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






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






7. Attribute Creation Wizard - Attribute Editor






8. Metrics you create within a report using only those objects in the report.






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






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






11. Primary keys






12. Grid View - Graph View - Grid/Graph View - SQL View






13. A development environment to create BI applications - allowing users to edit the Metadata database






14. View Filters can only ___________.






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






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






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






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






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






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






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






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






23. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






24. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.






25. Used to modify a Report






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






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






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






29. Level of OLAP integration






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






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






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






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






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






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






36. OLAP data storage measure






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






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






39. The default entry-points.






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






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






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






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






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






45. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






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






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






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






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






50. Simple - Derived






Can you answer 50 questions in 15 minutes?



Let me suggest you:



Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Most popular tests