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. Enables you to lock column headers so that they always appear when scrolling
Fact Expression
Desktop Administrative Functions
ETL process
Locking and Resizing
2. Facts - Attributes - Hierarchies
MSTR OLAP Services
Components of the Logical Data Model
Configuration Wizard
Project Source
3. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Attribute or its relationship(s)
To create the Project connectivity
The 3 MSTR Tools
Report Filter operators
4. A shortcut to an existing Object in a Project
2 components of a Physical Schema
To save a Report Format
Shortcut in MSTR Desktop
2 ways you can configure the Project Source to connect to the Metadata database
5. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
Attribute Creation Wizard good for
Fact Tables
MSTR OLAP Services
6. AND - OR - OR NOT - AND NOT
Report Objects
Fact Expression
Minimal or none
Report Filter operators
7. Creating multiple attributes quickly. Used during the initial project creation.
Attribute or its relationship(s)
Page-by
Attribute Creation Wizard good for
Object Prompts
8. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Schema Object Editor
Attribute Creation Wizard good for
Cannot create project objects
To save a Report Format
9. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.
Heterogeneous Attribute
View Filters
Subtotals
Report Prompts
10. Formula - Level (Dimensionality) - Conditionality - Transformation
Homogeneous Fact
Components of a Metric
Attribute Elements
Methods are there to creating Attributes
11. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Object Prompts
Process for creating the Project Metadata
Nested Metrics
To edit the appearance of a Graph in a report
12. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2 options for Sorting
4 parts of the Project Design Process
Project Creation Wizard
3 types of Attributes
13. OLTP retains data ________
Short-term (2 - 6 months)
Schema Objects
Thresholding
Homogeneous Attribute
14. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Terabytes (TB)
Different methods for creating Page-by fields
Factors to consider when designing a logical data model
3-Tier Architecture
15. Direct: 2-tier - Server: 3-tier
Unlimited
User Hierarchies
2 ways you can configure the Project Source to connect to the Metadata database
5 Report display views
16. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Using a Search Object
Compound Attribute
Long-term (2 - 5 years)
Warehouse Catalog
17. Template - Filter - View of a Report
Long-term (2 - 5 years)
Value Prompts
OLAP
3 components of a Report
18. Facts associated to different column names in 2 or more tables
Heterogeneous Fact
4 basic Schema objects
2 ways you can configure the Project Source to connect to the Metadata database
Objects you are allowed to Page-by
19. Grid View - Graph View - Grid/Graph View - SQL View
Display views you can Print by
MSTR Desktop
Cannot create project objects
To create the Project connectivity
20. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h
Minimal or none
Components of a MSTR architecture
Default Project folder structure
Report Filter
21. OLAP data storage measure
Nested Metrics
Very high; part of ETL process
Components of a Metric
Terabytes (TB)
22. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Schema Objects
To "drill down" on a report
Desktop Analyst
ETL process
23. 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
Characteristics of a Compound Table Key
Notes
Default Project folder structure
To qualify a Metric in a Set Qualification
24. The Attribute Form maps to different column names in multiple tables
Thresholding
2-Tier Architecture
Heterogeneous Attribute
MSTR applications
25. Simple - Derived
Data Pivoting
2 types of Facts
Fact Expression
2 types of Attribute Expression
26. 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.
Logical Data Model
User Hierarchies
Search-based prompts
MSTR OLAP Services
27. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Sample Metrics commonly performed on Facts
Objects you are allowed to Page-by
Compound Metric
2 types of Facts
28. Columns - Tables
2 components of a Physical Schema
Page-by
Highest-level attributes
Heterogeneous Fact
29. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Derived Attribute Expression
ETL process
MSTR Desktop Architect
View Filter
30. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
The System
3 components of a Report
To qualify a Metric in a Set Qualification
Factors to consider when designing a logical data model
31. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
3 Schema types
Rollback your changes
4 tasks of the Attribute Creation Wizard
Homogeneous Attribute
32. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
ID form
Reference Report Objects
Components of Compound Metrics
MSTR OLAP Services
33. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
MSTR Desktop Architect
File types are allowed for exporting a Report
Compound Metric
34. Using the Prompt Generation Wizard - Inside the Report Editor
To create a Report Prompt
Different methods for creating Page-by fields
Shortcut Bar
OLAP
35. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Page-by
2 types of Table Keys
Default Project folder structure
Components of Compound Metrics
36. A feature that enables users to delivers reports to the history list - cache or mobile
MSTR Desktop Architect
Methods are there to creating Attributes
Report Subscription
Application Objects
37. Facts associated to the same column name in 1 or more tables
Search Object
Homogeneous Fact
Terabytes (TB)
Components of the Logical Data Model
38. 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
2 components of a Physical Schema
4 types of Report Filters
5 Report display views
ID form
39. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Project Creation Wizard
Aggregate a Metric
Tasks when defining a User Hierarchy
2 components of a Physical Schema
40. Used to "fine-tune" your Project
MSTR Connectivity Wizard
2 methods to creating Facts
Highest-level attributes
Architect Graphical Interface
41. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Stored
MSTR Desktop Architect
Types of analysis you can perform with OLAP Services
File > Email Reports As
42. Allow you to interact with the BI system - logically organize data to analyze complex relationships
To edit the appearance of a Graph in a report
MSTR applications
Process for creating the Project Metadata
Lookup Tables
43. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
MSTR Desktop
Facts
Desktop Designer
Attribute Forms
44. Specifies what info to retrieve from a data-warehouse - and how to display it
File types are allowed for exporting a Report
Gigabytes (GB)
Characteristics of a Compound Table Key
Report Template
45. Metrics aggregate on the lowest-level attribute __________.
4 factors to consider when designing a data-warehouse schema
By default
Desktop Administrative Functions
Desktop Designer
46. Used to modify a Report
Lookup Table structure of a completely denormalized schema
Report Editor
Lookup Table structure of a completely normalized schema
Object Prompts
47. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
3-Tier Architecture
4 types of Metrics
5 steps to creating a logical data model
Application Objects
48. The default entry-points.
Subtotals
Aggregate a Metric
Highest-level attributes
View Filters
49. One that uses 2 or more columns as its ID
Compound Attribute
Using a Search Object
3 Types of Objects in MSTR Desktop
New SQL
50. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
3 components of a Report
MSTR Connectivity Wizard
Stored
MSTR Desktop Architect