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. Metrics that perform multiple aggregations; one calculation inside of another.






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






3. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






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






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






6. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






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






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






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






10. Level of OLAP integration






11. Create the Project Source - Create the Database Instance






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






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






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






15. Columns - Tables






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






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






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






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






20. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






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






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






23. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded






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






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






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






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






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






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






30. Descriptive data that provides context for Facts.






31. ID columns - Description columns - Fact columns






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






33. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema






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






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






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






37. OLTP data storage measure






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






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






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






41. Less storage - Simple SQL - Complex ETL






42. Schema Objects - Application Objects - Configuration Objects






43. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






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






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






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






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






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






49. Grid View - Graph View - Grid/Graph View - SQL View






50. More storage - Complex SQL - Simple ETL







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