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. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






2. You can _____________ in the Architect Graphical Interface.






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






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






5. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






6. All report-level options overwrite ___________.






7. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents






8. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






9. The Attribute Form Expression that maps to a single column - no matter the number of tables






10. An environment in which the MSTR Desktop connects directly to the Metadata database.






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






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






13. The unique values of an attribute obtained from the data-warehouse






14. Columns - Tables






15. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






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






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






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






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






21. A method of organizing the appearance of report results in a Grid report based on a criteria






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






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






24. Descriptive data that provides context for Facts.






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






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






27. AND - OR - OR NOT - AND NOT






28. OLTP retains data ________






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






30. Less storage - Simple SQL - Complex ETL






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






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






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






34. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






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






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






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






38. It contains the ID column of the parent attribute






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






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






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






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






43. OLAP retains data ________






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






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






46. Enables you to select which tables from the data-warehouse to store in the Metadata database






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






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






49. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






50. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format







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