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. View Filters are saved with the _____________.






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






3. It contains links to specific folders in the Folder List






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






5. The default entry-points.






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






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






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






9. Homogeneous - Heterogeneous






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






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






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






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






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






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






16. Folder List - Object Viewer - Shortcut Bar






17. Metrics that perform multiple aggregations; one calculation inside of another.






18. You can _____________ in the Architect Graphical Interface.






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






20. More storage - Complex SQL - Simple ETL






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






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






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






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






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






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






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






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






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






30. Columns - Tables






31. Level of OLTP integration






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






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






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






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






36. A shortcut to an existing Object in a Project






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






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






39. It contains the ID column of all higher-level attributes






40. User reporting requirements - Query performance - Data volume - DB Maintenance






41. The Attribute Form maps to the same column name in multiple tables






42. Create the Project Source - Create the Database Instance






43. ID columns - Description columns - Fact columns






44. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






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






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






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






48. Tables - Facts - Attributes - Hierarchies






49. Used for - Initially populating the Metadata - Creating schema objects






50. Grid View - Graph View - Grid/Graph View - SQL View







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