SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Certified Project Designer Cpd
Start Test
Study First
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. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Heterogeneous Fact
Schema Object Editor
Methods are there to creating Attributes
Limitations of the Attribute Creation Wizard
2. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Methods are there to creating Attributes
To drill through User Hierarchies
3 Sections of the MSTR Desktop interface
2 types of Attribute Relationships
3. 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
To create a Report Prompt
Characteristics of Nested Metrics
Logical Data Model
Desktop Administrative Functions
4. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
3 functions of Attribute Forms
4 basic Schema objects
Fact Tables
Fact Expression
5. ID columns - Description columns - Fact columns
3 column types of a Physical Schema
Locking and Resizing
3 Methods of MSTR Desktop navigation
Default Project folder structure
6. Less storage - Simple SQL - Complex ETL
3 functions of Attribute Forms
Schema
Attribute Forms
Characteristics of a Simple Table Key
7. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Desktop Administrative Functions
To edit the appearance of a Graph in a report
4 properties you must know in order to create attributes using the Attribute Editor
Logical Data Model
8. Formula - Level (Dimensionality) - Conditionality - Transformation
Different methods for creating Page-by fields
2 components of a Physical Schema
Shortcut in MSTR Desktop
Components of a Metric
9. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Search-based prompts
Object Prompts
Stored
Homogeneous Fact
10. A user interface for creating and maintaining a BI environment
MSTR Desktop
To edit the appearance of a Graph in a report
Report Subscription
Architect Graphical Interface
11. OLAP Services does not add any ______ to the report query.
New SQL
2 ways you can configure the Project Source to connect to the Metadata database
2 components of a Physical Schema
Limitations of the Attribute Creation Wizard
12. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Drilling
Desktop Architec
Terabytes (TB)
Physical Schema
13. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Objects you are allowed to Page-by
Compound Attribute
File types are allowed for exporting a Report
Project
14. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Object Prompts
Report Template
2 options for Sorting
ETL process
15. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Using a Search Object
File types are allowed for exporting a Report
Architect Graphical Interface
Application Objects
16. OLAP data storage measure
Report Subscription
File types are allowed for exporting a Report
Attribute or its relationship(s)
Terabytes (TB)
17. 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
Shortcut Bar
Characteristics of Nested Metrics
ID form
Report Filter operators
18. Schema Objects - Application Objects - Configuration Objects
To create a Report Prompt
Notes
Attribute or its relationship(s)
3 Types of Objects in MSTR Desktop
19. 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
3 components of a Report
Simple Metrics
Report Editor
2 types of Table Keys
20. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
Tasks when defining a User Hierarchy
Advantage of a completely denormalized schema
Value Prompts
21. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Attribute Elements
Project
Cannot create project objects
Attribute Relationships
22. A shortcut to an existing Object in a Project
Application Objects
Shortcut in MSTR Desktop
Schema
Homogeneous Fact
23. Create the Project Source - Create the Database Instance
To create the Project connectivity
Report Subscription
Object Prompts
2 options for Sorting
24. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Desktop Analyst
Schema Objects
4 types of Prompts
Limitations of the Attribute Creation Wizard
25. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Attribute Forms
MSTR OLAP Services
Homogeneous Attribute
Aggregate a Metric
26. What tool do you use to create the Metadata shell?
Attribute Relationships
4 types of Metrics
Configuration Wizard
4 types of Prompts
27. More storage - Complex SQL - Simple ETL
3 column types of a Physical Schema
4 parts of the Project Design Process
Filter Definition Prompts
Characteristics of a Compound Table Key
28. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
2 types of Table Keys
Application Objects
Components of a Derived Metric
Schema Objects
29. View Filters are saved with the _____________.
'View of a Report'
Report Definitions
Reports
Tasks when defining a User Hierarchy
30. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2 options for Sorting
Configuration Wizard
2-Tier Architecture
View Filter
31. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Lookup Table structure of a completely normalized schema
Thresholding
Report Filter
Report Definitions
32. How users can share comments for reports to other users
Report Filter
Highest-level attributes
Attribute or its relationship(s)
Notes
33. A condition data must meet in order to be included in a report. Does affect the SQL.
Nested Metrics
Architect Graphical Interface
2 types of Table Keys
Report Filter
34. Compound - Homogeneous - Heterogeneous
3 types of Attributes
Homogeneous Fact
Unlimited
Report Subscription
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
Terabytes (TB)
Value Prompts
2 types of Attribute Expression
3 Schema types
36. The System Hierarchy is automatically updated whenever you make a change to an __________________.
File types are allowed for exporting a Report
Attribute or its relationship(s)
Report Subscription
Notes
37. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Sorting
Report Filter operators
Components of a Metric
Hierarchies
38. Top menu/dropdowns - Toolbar - Right-click popup menus
Attribute Relationships
3 Methods of MSTR Desktop navigation
Lookup Table structure of a completely denormalized schema
Report Filter
39. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
Different methods for creating Page-by fields
Report Prompts
Heterogeneous Fact
40. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
3 types of Attributes
Facts
Display views you can Print by
Architect Graphical Interface
41. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Display views you can Print by
Table Keys
The 3 MSTR Tools
Characteristics of Nested Metrics
42. 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
Logical Data Model
2 ways you can configure the Project Source to connect to the Metadata database
To edit the appearance of a Graph in a report
43. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Tasks when defining a User Hierarchy
To edit the appearance of a Graph in a report
Outline Mode
Attribute Elements
44. Descriptive data that provides context for Facts.
Fact Expression
Attribute Forms
2-Tier Architecture
4 basic Schema objects
45. It contains the ID and DESC columns of all higher-level attributes
File types are allowed for exporting a Report
Lookup Table structure of a completely denormalized schema
Methods are there to creating Attributes
Report Template
46. Facts - Attributes - Hierarchies
Heterogeneous Fact
Components of the Logical Data Model
Report Prompts
Short-term (2 - 6 months)
47. Subtotals reflect accumulations at selected attribute levels
2 types of Fact Expressions
Subtotals
Level Prompts
Facts
48. Direct: 2-tier - Server: 3-tier
Report Subscription
2 ways you can configure the Project Source to connect to the Metadata database
Object Prompts
Project Creation Wizard
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
OLAP
Derived Metrics
Default Project folder structure
Different methods for creating Page-by fields
50. Filter definition prompts - Object prompts - Value prompts - Level prompts
4 types of Prompts
Terabytes (TB)
Objects you are allowed to Page-by
Types of drilling