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. You can e-mail reports by going to _____






2. You can _____________ in the Architect Graphical Interface.






3. Enables you to rearrange the columns and rows in a report.






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






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






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






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






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






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






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






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






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






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






14. Facts - Attributes - Hierarchies






15. A shortcut to an existing Object in a Project






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






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






18. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






19. It contains the ID column of all higher-level attributes






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






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






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






23. View Filters can only ___________.






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






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






26. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






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






28. Facts associated to the same column name in 1 or more tables






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






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






31. Compound - Homogeneous - Heterogeneous






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






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






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






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






36. Create the Project Source - Create the Database Instance






37. View Filters are saved with the _____________.






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






39. The default entry-points.






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






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


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






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






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






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






46. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






48. Must have a one-to-one relationship with all other forms.






49. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






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






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