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. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






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






3. Direct: 2-tier - Server: 3-tier






4. You can _____________ in the Architect Graphical Interface.






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






6. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






7. All Attributes must have an _______.






8. ID columns - Description columns - Fact columns






9. OLAP retains data ________






10. It contains the ID column of the parent attribute






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






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






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






14. Folder List - Object Viewer - Shortcut Bar






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






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






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






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






19. Reduced number of JOINS in the generated SQL






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






21. Template - Filter - View of a Report






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






23. Primary keys






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






25. Descriptive data that provides context for Facts.






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






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






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






29. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






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






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






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






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






34. The default entry-points.






35. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






36. Formula - Level (Dimensionality) - Conditionality - Transformation






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






38. Simple - Compound - Nested - Derived






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






40. Grid View - Graph View - Grid/Graph View - SQL View






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






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






43. View Filters are saved with the _____________.






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






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






46. Schema Objects - Application Objects - Configuration Objects






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






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






49. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






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







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