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. Simple - Derived






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






3. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






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






5. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






6. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






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






8. OLAP retains data ________






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






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






11. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






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






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






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






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


19. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






20. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






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






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






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






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






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






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






27. What tool do you use to create the Metadata shell?






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






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






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






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






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






33. Simple - Compound - Nested - Derived






34. Primary keys






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






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






37. You can _____________ in the Architect Graphical Interface.






38. Extraction - transformation - loading






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






40. The default entry-points.






41. Homogeneous - Heterogeneous






42. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.






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






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






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






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






47. Tables - Facts - Attributes - Hierarchies






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






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






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







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