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. You can e-mail reports by going to _____






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






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






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






6. A subset of a report that users can manipulate without altering the SQL

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


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






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






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






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






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






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






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






14. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






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






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






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






18. All Attributes must have an _______.






19. Level of OLTP integration






20. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






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






22. OLTP retains data ________






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






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






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






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






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






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






29. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






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






32. Facts associated to different column names in 2 or more tables






33. Descriptive data that provides context for Facts.






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






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






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






37. Folder List - Object Viewer - Shortcut Bar






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






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






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






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






42. Less storage - Simple SQL - Complex ETL






43. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






44. Simple - Compound - Nested - Derived






45. ID columns - Description columns - Fact columns






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






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






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






49. View Filters can only ___________.






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