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. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






2. It contains links to specific folders in the Folder List






3. Used to modify a Report






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






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






6. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






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






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






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






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






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






12. OLAP retains data ________






13. Metrics you create within a report using only those objects in the report.






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






15. The default entry-points.






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






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






18. All report-level options overwrite ___________.






19. The actual column name for a fact. Every fact must have at least 1 expression.






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






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






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






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






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






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






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






27. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






28. Homogeneous - Heterogeneous






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






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






31. View Filters can only ___________.






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






33. Level of OLTP integration






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






35. More storage - Complex SQL - Simple ETL






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






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






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






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






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






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






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






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






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






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






46. Descriptive data that provides context for Facts.






47. All Attributes must have an _______.






48. Attribute Creation Wizard - Attribute Editor






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






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







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