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. The System Hierarchy is automatically updated whenever you make a change to an __________________.






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






3. Groupings of directly related attributes. Also commonly known as "dimensions".






4. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






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






6. Primary keys






7. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






8. All Attributes must have an _______.






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






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






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






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






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






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






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






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






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






18. Using the Prompt Generation Wizard - Inside the Report Editor






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


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






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






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






23. OLTP data storage measure






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






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






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






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






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






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






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






31. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






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. A condition data must meet in order to be included in a report. Does affect the SQL.






34. You must select "Other directions" when drilling attributes while viewing a report






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






36. ID columns - Description columns - Fact columns






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






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






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






40. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






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






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






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






44. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






45. Attribute Creation Wizard - Attribute Editor






46. OLTP retains data ________






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






48. View Filters are saved with the _____________.






49. Enables you to lock column headers so that they always appear when scrolling






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







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