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. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






2. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked






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






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






5. All report-level options overwrite ___________.






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






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






8. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters






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






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






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






12. View Filters can only ___________.






13. You can _____________ in the Architect Graphical Interface.






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






15. Enables you to format report values based on a condition - such as highlights - font colors - etc.






16. OLTP data storage measure






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






18. Primary keys






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






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






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






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






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






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






25. More storage - Complex SQL - Simple ETL






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






27. Folder List - Object Viewer - Shortcut Bar






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






29. Specifies what info to retrieve from a data-warehouse - and how to display it






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






31. The default entry-points.






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


33. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy






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






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






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






37. Simple - Compound - Nested - Derived






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






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






40. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






41. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






43. OLTP retains data ________






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






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






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






47. All Attributes must have an _______.






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






49. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






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







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