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. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






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






3. Compound - Homogeneous - Heterogeneous






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






5. Formula - Level (Dimensionality) - Conditionality - Transformation






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






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






8. Used to "fine-tune" your Project






9. It contains the ID and DESC columns of all higher-level attributes






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






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






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






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






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






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






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






17. OLTP data storage measure






18. OLAP retains data ________






19. Schema Objects - Application Objects - Configuration Objects






20. You can _____________ in the Architect Graphical Interface.






21. Top menu/dropdowns - Toolbar - Right-click popup menus






22. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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






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






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






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






27. You can e-mail reports by going to _____






28. Columns - Tables






29. Homogeneous - Heterogeneous






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






31. Less storage - Simple SQL - Complex ETL






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






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






34. More storage - Complex SQL - Simple ETL






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






36. To define the level of aggregation for a specific metric - Used for qualifications






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






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






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






40. Create the Project Source - Create the Database Instance






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






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






43. Reduced number of JOINS in the generated SQL






44. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






45. To see data at completely different levels - other than that of the original Grid or Graph






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






47. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






48. The System Hierarchy is automatically updated whenever you make a change to an __________________.






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






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







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