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 you create within a report using only those objects in the report.






2. Descriptive data that provides context for Facts.






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






4. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






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






6. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities






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






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






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






10. Used to create or edit complex attributes - facts - hierarchies - and logical tables






11. Used to modify a Report






12. Attribute Creation Wizard - Attribute Editor






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






14. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






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






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






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






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






19. Simple - Derived






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






21. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






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






23. Folder List - Object Viewer - Shortcut Bar






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






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






26. A feature that enables users to delivers reports to the history list - cache or mobile






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






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






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






30. You can _____________ in the Architect Graphical Interface.






31. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






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






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






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






35. It contains the ID column of the parent attribute






36. OLTP data storage measure






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






38. OLAP data storage measure






39. Store info on relationships between 2 or more tables (attributes) - like an Index table.






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






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






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






43. All report-level options overwrite ___________.






44. Level of OLTP integration






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






46. ID columns - Description columns - Fact columns






47. More storage - Complex SQL - Simple ETL






48. Compound - Homogeneous - Heterogeneous






49. You must select "Other directions" when drilling attributes while viewing a report






50. What tool do you use to create the Metadata shell?







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