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. Extraction - transformation - loading






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






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






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






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






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






7. How users can share comments for reports to other users






8. Filter definition prompts - Object prompts - Value prompts - Level prompts






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






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






11. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked






12. OLAP data storage measure






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






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






15. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






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






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






18. Specifies a condition data must meet in order to be included in a report






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






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






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






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






23. The unique values of an attribute obtained from the data-warehouse






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






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






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






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






28. It contains the ID column of the parent attribute






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






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






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






32. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






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






34. OLTP data storage measure






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






36. View Filters can only ___________.






37. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






38. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






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






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






41. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






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






43. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






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






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






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






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






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






49. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






50. Create an empty Metadata database - Create the Metadata DSN connection - 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