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. What tool do you use to create the Metadata shell?






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






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






4. Used to "fine-tune" your Project






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






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






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






8. OLTP retains data ________






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






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






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






12. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






13. OLAP data storage measure






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






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






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






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






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






19. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






20. A shortcut to an existing Object in a Project






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






22. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






23. The logical associations between attributes that exist based on a business rule






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






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






26. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






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






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






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






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






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






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






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






34. The System Hierarchy is automatically updated whenever you make a change to an __________________.






35. Simple - Compound - Nested - Derived






36. Attribute Creation Wizard - Attribute Editor






37. Simple - Derived






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






39. Facts - Attributes - Hierarchies






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






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






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






43. Subtotals reflect accumulations at selected attribute levels






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






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






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


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






48. View Filters are saved with the _____________.






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






50. You can _____________ in the Architect Graphical Interface.