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. One that uses 2 or more columns as its ID






2. All report-level options overwrite ___________.






3. Homogeneous - Heterogeneous






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






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






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






7. Direct: 2-tier - Server: 3-tier






8. ID columns - Description columns - Fact columns






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






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






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






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






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






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






15. Primary keys






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






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






18. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






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


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






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






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






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






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






25. The default entry-points.






26. A feature that enables users to delivers reports to the history list - cache or mobile






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






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






29. Used to "fine-tune" your Project






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






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






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






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






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






35. Folder List - Object Viewer - Shortcut Bar






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






37. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






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






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






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






41. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






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






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






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






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






46. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






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






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






49. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






50. AND - OR - OR NOT - AND NOT