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. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






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






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






4. Columns - Tables






5. Used to limit a possibly overwhelming set of potential prompt answers






6. All Attributes must have an _______.






7. Schema Objects - Application Objects - Configuration Objects






8. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships






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






10. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






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






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






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






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






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






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






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






18. Reduced number of JOINS in the generated SQL






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






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






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






22. OLAP retains data ________






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






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






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






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






27. Compound - Homogeneous - Heterogeneous






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






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






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






31. All report-level options overwrite ___________.






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






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






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






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






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






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






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






39. Level of OLTP integration






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






41. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






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






43. Subtotals reflect accumulations at selected attribute levels






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






45. OLAP data storage measure






46. Create the Project Source - Create the Database Instance






47. Template - Filter - View of a Report






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






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






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






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