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. 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
4 properties you must know in order to create attributes using the Attribute Editor
Homogeneous Fact
Warehouse Catalog
To qualify a Metric in a Set Qualification
2. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Filter Definition Prompts
To "drill down" on a report
Types of analysis you can perform with OLAP Services
Search Object
3. 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.
2 types of Attribute Expression
User Hierarchies
Default Project folder structure
Source system characteristics
4. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
To create a Report Prompt
Derived Attribute Expression
Notes
5. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Notes
Unlimited
Level Prompts
Schema Object Editor
6. User reporting requirements - Query performance - Data volume - DB Maintenance
Notes
Warehouse Catalog
4 factors to consider when designing a data-warehouse schema
MSTR applications
7. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Reference Report Objects
Report Template
Schema Objects
Object Prompts
8. The Attribute Form maps to different column names in multiple tables
Locking and Resizing
Heterogeneous Attribute
Schema Objects
Lookup Table structure of a moderately denormalized schema
9. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Search-based prompts
4 tasks of the Attribute Creation Wizard
2 methods to creating Facts
The System
10. OLTP data storage measure
Table Keys
Nested Metrics
Gigabytes (GB)
Physical Schema
11. 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
Characteristics of a Simple Table Key
Filter Definition Prompts
Report Filter operators
Characteristics of Nested Metrics
12. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
The 3 MSTR Tools
Sample Metrics commonly performed on Facts
Desktop Designer
2 types of Attribute Relationships
13. What tool do you use to create the Metadata shell?
Banding
Application Objects
Configuration Wizard
Desktop Analyst
14. 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
To create the Project connectivity
Tasks when defining a User Hierarchy
3 Schema types
Process for creating the Project Metadata
15. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Shortcut Bar
Desktop Designer
Report Definitions
3 Sections of the MSTR Desktop interface
16. Used to limit a possibly overwhelming set of potential prompt answers
Stored
Search-based prompts
Subtotals
View Filter
17. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
3 Schema types
To save a Report Format
Report Prompts
Components of Compound Metrics
18. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
3 functions of Attribute Forms
Components of Compound Metrics
Objects you are allowed to Page-by
OLAP
19. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
3 functions of Attribute Forms
View Filters
Column Aliases
Application Objects
20. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop Architect
Schema Objects
Desktop Analyst
Report Formatting
21. The default entry-points.
Banding
Characteristics of a Simple Table Key
View Filter
Highest-level attributes
22. A new tool for project design tasks - used for fine-tuning a project after initial creation
Architect Graphical Interface
Relationship Tables
3 column types of a Physical Schema
ID form
23. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
To edit the appearance of a Graph in a report
2 types of Table Keys
Types of analysis you can perform with OLAP Services
Terabytes (TB)
24. To see data at completely different levels - other than that of the original Grid or Graph
Attribute Elements
Nested Metrics
Drilling
Report Filter
25. What tool do you use to create the Metadata DSN connection?
Page-by
MSTR Connectivity Wizard
View Filter
By default
26. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Cannot create project objects
Methods are there to creating Attributes
Metrics
Drilling
27. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling
Compound Metric
Tasks when defining a User Hierarchy
MSTR Connectivity Wizard
File > Email Reports As
28. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Source system characteristics
Application Objects
Highest-level attributes
File types are allowed for exporting a Report
29. Must have a one-to-one relationship with all other forms.
Attribute Forms
Stored
Attribute or its relationship(s)
Column Aliases
30. Facts associated to different column names in 2 or more tables
The 3 MSTR Tools
Report Filter
Heterogeneous Fact
Components of the Logical Data Model
31. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Data warehouse characteristics
Cannot create project objects
MSTR Connectivity Wizard
Attribute or its relationship(s)
32. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Schema Object Editor
MSTR Desktop Architect
Application Objects
ETL process
33. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
Derived Metrics
Simple Metrics
To drill through User Hierarchies
34. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
4 tasks of the Attribute Creation Wizard
Rollback your changes
Lookup Table structure of a moderately denormalized schema
Terabytes (TB)
35. Simple - Compound - Nested - Derived
Search Object
Fact Tables
4 types of Metrics
Shortcut Bar
36. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Reports
5 steps to creating a logical data model
Project Source
3-Tier Architecture
37. Metrics you create within a report using only those objects in the report.
MSTR OLAP Services
Derived Metrics
Reports
Homogeneous Fact
38. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
To create the Project connectivity
Characteristics of Nested Metrics
Rollback your changes
Column Aliases
39. Specifies what info to retrieve from a data-warehouse - and how to display it
Using a Search Object
Object Prompts
Long-term (2 - 5 years)
Report Template
40. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
4 basic Schema objects
Desktop Analyst
View Filters
Facts
41. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
4 basic Schema objects
Simple Metrics
Warehouse Catalog
Compound Metric
42. Enables you to lock column headers so that they always appear when scrolling
To qualify a Metric in a Set Qualification
Thresholding
Relationship Tables
Locking and Resizing
43. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
MSTR OLAP Services
Configuration Wizard
User Hierarchies
3 project creation interfaces
44. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Components of the Logical Data Model
Configuration Wizard
Limitations of the Attribute Creation Wizard
Level Prompts
45. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
2 components of a Physical Schema
4 tasks of the Attribute Creation Wizard
Derived Attribute Expression
Types of drilling
46. You must select "Other directions" when drilling attributes while viewing a report
'View of a Report'
To drill through User Hierarchies
The 3 MSTR Tools
Data Pivoting
47. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
4 basic Schema objects
Derived Attribute Expression
Process for creating the Project Metadata
4 types of Metrics
48. Store info on relationships between 2 or more tables (attributes) - like an Index table.
3 Sections of the MSTR Desktop interface
Relationship Tables
Facts
Homogeneous Fact
49. Less storage - Simple SQL - Complex ETL
Report Prompts
Characteristics of a Simple Table Key
Short-term (2 - 6 months)
Subtotals
50. Filter definition prompts - Object prompts - Value prompts - Level prompts
Table Keys
Desktop Administrative Functions
4 types of Prompts
Nested Metrics