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. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






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






6. Create the Project Source - Create the Database Instance






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






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






9. Enables you to lock column headers so that they always appear when scrolling






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






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






12. Level of OLTP integration






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






14. Less storage - Simple SQL - Complex ETL






15. Homogeneous - Heterogeneous






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






17. All Attributes must have an _______.






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






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






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






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


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. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






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






25. The default entry-points.






26. A shortcut to an existing Object in a Project






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






28. Schema Objects - Application Objects - Configuration Objects






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






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






31. Subtotals reflect accumulations at selected attribute levels






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






33. Level of OLAP integration






34. View Filters can only ___________.






35. Tables - Facts - Attributes - Hierarchies






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






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






38. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






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






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






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






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






43. ID columns - Description columns - Fact columns






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






45. Folder List - Object Viewer - Shortcut Bar






46. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






47. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






48. Columns - Tables






49. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






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