Test your basic knowledge |

Certified Project Designer Cpd

Subjects : certifications, it-skills

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. Facts associated to the same column name in 1 or more tables
Components of the Logical Data Model
Homogeneous Fact
Facts
Object Prompts

2. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Fact Tables
Attributes
Gigabytes (GB)
Schema Objects

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

4. Groupings of directly related attributes. Also commonly known as "dimensions".
Components of a MSTR architecture
Characteristics of a Compound Table Key
Schema Object Editor
Hierarchies

5. A shortcut to an existing Object in a Project
Lookup Table structure of a completely denormalized schema
Attribute Forms
Shortcut in MSTR Desktop
Project-level options/settings

6. Attribute Creation Wizard - Attribute Editor
Shortcut in MSTR Desktop
Methods are there to creating Attributes
Homogeneous Attribute
4 parts of the Project Design Process

7. Descriptive data that provides context for Facts.
Desktop Designer
Report Template
Desktop Administrative Functions
Attribute Forms

8. Used to limit a possibly overwhelming set of potential prompt answers
To create a Report Prompt
MSTR OLAP Services
Long-term (2 - 5 years)
Search-based prompts

9. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
3 Types of Objects in MSTR Desktop
Aggregate a Metric
Lookup Table structure of a completely denormalized schema
Terabytes (TB)

10. Simple - Compound - Nested - Derived
Table Keys
Project Creation Wizard
4 types of Metrics
Compound Attribute

11. OLTP retains data ________
Short-term (2 - 6 months)
Attribute Forms
To qualify a Metric in a Set Qualification
4 basic Schema objects

12. The actual column name for a fact. Every fact must have at least 1 expression.
4 properties you must know in order to create attributes using the Attribute Editor
Fact Expression
Project-level options/settings
OLTP

13. More storage - Complex SQL - Simple ETL
Characteristics of a Compound Table Key
Components of a MSTR architecture
To create the Project connectivity
Fact Expression

14. 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
To qualify a Metric in a Set Qualification
Attribute Relationships
4 parts of the Project Design Process
Desktop Designer

15. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Required on the report for Outline Model to work
3 Sections of the MSTR Desktop interface
Gigabytes (GB)
New SQL

16. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Attribute Forms
File types are allowed for exporting a Report
Sorting
Report Filter operators

17. OLAP retains data ________
MSTR OLAP Services
To save a Report Format
Long-term (2 - 5 years)
2 methods to creating Facts

18. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Metrics
MSTR Desktop
MSTR OLAP Services
Source system characteristics

19. 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
Sorting
3 functions of Attribute Forms
Search Object
Components of a Metric

20. AND - OR - OR NOT - AND NOT
Report Filter operators
MSTR Desktop Architect
Report Subscription
Components of Compound Metrics

21. 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.
Schema
User Hierarchies
Report Template
4 tasks of the Attribute Creation Wizard

22. Schema Objects - Application Objects - Configuration Objects
2 types of Attribute Relationships
5 steps to creating a logical data model
Unlimited
3 Types of Objects in MSTR Desktop

23. Level of OLAP integration
To create the Project connectivity
Attribute Forms
Very high; part of ETL process
Facts

24. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
2 components of a Physical Schema
4 parts of the Project Design Process
Types of analysis you can perform with OLAP Services
Drilling

25. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Fact Expression
Stored
File types are allowed for exporting a Report
Components of a MSTR architecture

26. User requirements - Existing source data - Technical and performance considerations
2 types of Attribute Expression
Factors to consider when designing a logical data model
Attributes
File > Email Reports As

27. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Banding
4 types of Report Filters
2 types of Table Keys
3 column types of a Physical Schema

28. It contains the ID and DESC columns of all higher-level attributes
Page-by
Homogeneous Attribute
To edit the appearance of a Graph in a report
Lookup Table structure of a completely denormalized schema

29. Enables you to select which tables from the data-warehouse to store in the Metadata database
MSTR applications
Warehouse Catalog
Desktop Architec
Architect Graphical Interface

30. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
4 types of Metrics
Unlimited
Logical Data Model
Simple Metrics

31. It contains the ID column of all higher-level attributes
Lookup Table structure of a moderately denormalized schema
Terabytes (TB)
Data Pivoting
User Hierarchies

32. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Page-by
Report Objects
Project Source
3 Sections of the MSTR Desktop interface

33. Folder List - Object Viewer - Shortcut Bar
Search-based prompts
Report Subscription
Heterogeneous Attribute
3 Sections of the MSTR Desktop interface

34. You must select "Other directions" when drilling attributes while viewing a report
2 types of Attribute Relationships
To drill through User Hierarchies
Gigabytes (GB)
Long-term (2 - 5 years)

35. Template - Filter - View of a Report
Project Source
The System
Search Object
3 components of a Report

36. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Physical Schema
To create the Project connectivity
Nested Metrics
Components of Compound Metrics

37. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
4 parts of the Project Design Process
2-Tier Architecture
The System
2 ways you can configure the Project Source to connect to the Metadata database

38. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Source system characteristics
Lookup Table structure of a completely normalized schema
Components of a Metric
Components of a Derived Metric

39. Metrics you create within a report using only those objects in the report.
Homogeneous Fact
Derived Metrics
Physical Schema
Desktop Designer

40. The logical associations between attributes that exist based on a business rule
Level Prompts
3 functions of Attribute Forms
Attribute Forms
Attribute Relationships

41. Level of OLTP integration
Sorting
Thresholding
Data warehouse characteristics
Minimal or none

42. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
Nested Metrics
Components of a Derived Metric
2 types of Attribute Expression

43. Simple - Derived
2 types of Attribute Relationships
Components of a Metric
2 types of Attribute Expression
Terabytes (TB)

44. Reduced number of JOINS in the generated SQL
Simple Attribute Expression
Advantage of a completely denormalized schema
3 Schema types
MSTR applications

45. It contains links to specific folders in the Folder List
Schema Objects
Locking and Resizing
Shortcut Bar
Display views you can Print by

46. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Search Object
Reports
To save a Report Format
Hierarchies

47. An environment in which the MSTR Desktop connects directly to the Metadata database.
3 components of a Report
Attribute or its relationship(s)
Using a Search Object
2-Tier Architecture

48. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Facts
MSTR Desktop Architect
MSTR Connectivity Wizard
Data warehouse characteristics

49. All report-level options overwrite ___________.
Sample Metrics commonly performed on Facts
Project-level options/settings
2-Tier Architecture
MSTR OLAP Services

50. 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
To "drill down" on a report
Simple Metrics
Stored
2 ways you can configure the Project Source to connect to the Metadata database