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






2. More storage - Complex SQL - Simple ETL






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






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






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






6. Simple - Compound - Nested - Derived






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






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






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






10. Facts - Attributes - Hierarchies






11. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






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






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






14. Used to modify a Report






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






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






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






18. View Filters can only ___________.






19. AND - OR - OR NOT - AND NOT






20. Compound - Homogeneous - Heterogeneous






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






22. Simple - Derived






23. Less storage - Simple SQL - Complex ETL






24. Enables you to select and display subsets of a report as separate pages.






25. Level of OLTP integration






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






27. OLAP data storage measure






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






29. You must select "Other directions" when drilling attributes while viewing a report






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






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






32. Enables you to lock column headers so that they always appear when scrolling






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






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






35. Subtotals reflect accumulations at selected attribute levels






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






37. A user interface for creating and maintaining a BI environment






38. Columns - Tables






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






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






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






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






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






44. View Filters are saved with the _____________.






45. Primary keys






46. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






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






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






49. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen






50. OLTP retains data ________







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:



Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Most popular tests