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. Attribute Creation Wizard - Attribute Editor
Using a Search Object
MSTR applications
Fact Tables
Methods are there to creating Attributes
2. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
The System
Search-based prompts
ID form
2 types of Table Keys
3. User reporting requirements - Query performance - Data volume - DB Maintenance
3 Types of Objects in MSTR Desktop
ETL
4 factors to consider when designing a data-warehouse schema
2 types of Fact Expressions
4. Facts associated to different column names in 2 or more tables
Physical Schema
Project Creation Wizard
Heterogeneous Fact
Characteristics of a Simple Table Key
5. How users can share comments for reports to other users
Banding
Lookup Table structure of a completely denormalized schema
Notes
Architect Graphical Interface
6. Enables you to select and display subsets of a report as separate pages.
'View of a Report'
To edit the appearance of a Graph in a report
New SQL
Page-by
7. You can e-mail reports by going to _____
File > Email Reports As
ID form
Default Project folder structure
Report Definitions
8. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Relationship Tables
Attribute Forms
Subtotals
Desktop Designer
9. To define the level of aggregation for a specific metric - Used for qualifications
Attributes
Level Prompts
View Filters
Shortcut Bar
10. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Schema Object Editor
Report Objects
By default
Components of the Logical Data Model
11. Facts - Attributes - Hierarchies
Process for creating the Project Metadata
Shortcut Bar
3 types of Attributes
Components of the Logical Data Model
12. ID columns - Description columns - Fact columns
To "drill down" on a report
File > Email Reports As
3 column types of a Physical Schema
Thresholding
13. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Lookup Table structure of a completely denormalized schema
Report Editor
To edit the appearance of a Graph in a report
Project
14. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
4 tasks of the Attribute Creation Wizard
2 types of Table Keys
Report Filter
MSTR Connectivity Wizard
15. The actual column name for a fact. Every fact must have at least 1 expression.
2 options for Sorting
Desktop Architec
Fact Expression
2 types of Facts
16. The default entry-points.
Highest-level attributes
Short-term (2 - 6 months)
Using a Search Object
Components of a Derived Metric
17. The logical associations between attributes that exist based on a business rule
Components of a Metric
Attribute Relationships
Locking and Resizing
Facts
18. An environment in which the MSTR Desktop connects directly to the Metadata database.
Report Filter
2-Tier Architecture
Report Editor
User Hierarchies
19. It contains the ID column of the parent attribute
Warehouse Catalog
Locking and Resizing
Terabytes (TB)
Lookup Table structure of a completely normalized schema
20. Homogeneous - Heterogeneous
Project
3 column types of a Physical Schema
2 types of Facts
Filter Definition Prompts
21. Grid View - Graph View - Grid/Graph View - SQL View
Display views you can Print by
Desktop Administrative Functions
MSTR Connectivity Wizard
Aggregate a Metric
22. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
2 types of Attribute Expression
To "drill down" on a report
Terabytes (TB)
Aggregate a Metric
23. Tables - Facts - Attributes - Hierarchies
ETL
4 tasks of the Attribute Creation Wizard
Search Object
4 basic Schema objects
24. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Using a Search Object
Advantage of a completely denormalized schema
Sample Metrics commonly performed on Facts
View Filter
25. Groupings of directly related attributes. Also commonly known as "dimensions".
Hierarchies
Report Filter operators
Report Definitions
Derived Attribute Expression
26. Less storage - Simple SQL - Complex ETL
Characteristics of a Simple Table Key
Facts
Desktop Designer
ETL
27. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Page-by
New SQL
Source system characteristics
The 3 MSTR Tools
28. Extraction - transformation - loading
Short-term (2 - 6 months)
ETL
Attribute or its relationship(s)
Report Prompts
29. 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
ETL
Report Definitions
Components of a Derived Metric
30. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Outline Mode
3 components of a Report
Report Definitions
Drilling
31. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Application Objects
Banding
Types of analysis you can perform with OLAP Services
Gigabytes (GB)
32. Specifies what info to retrieve from a data-warehouse - and how to display it
MSTR Desktop Architect
Report Template
Terabytes (TB)
3 components of a Report
33. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Drilling
Short-term (2 - 6 months)
Heterogeneous Attribute
Relationship Tables
34. Creating multiple attributes quickly. Used during the initial project creation.
Architect Graphical Interface
Types of drilling
Attribute Creation Wizard good for
MSTR Desktop Architect
35. It contains the ID and DESC columns of all higher-level attributes
Outline Mode
Hierarchies
Lookup Table structure of a completely denormalized schema
OLAP
36. 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.
Locking and Resizing
Characteristics of a Simple Table Key
View Filters
Stored
37. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Report Prompts
Project
2 ways you can configure the Project Source to connect to the Metadata database
Object Prompts
38. A shortcut to an existing Object in a Project
Report Objects
Report Filter
File > Email Reports As
Shortcut in MSTR Desktop
39. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
4 tasks of the Attribute Creation Wizard
Column Aliases
Outline Mode
40. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
2 types of Facts
Search Object
File > Email Reports As
MSTR Desktop
41. A user interface for creating and maintaining a BI environment
MSTR Desktop
ETL process
Homogeneous Fact
Cannot create project objects
42. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Schema Object Editor
New SQL
4 basic Schema objects
Facts
43. Must have a one-to-one relationship with all other forms.
Attribute Forms
Components of a Metric
Sample Metrics commonly performed on Facts
Search Object
44. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Search Object
Rollback your changes
To save a Report Format
Drilling
45. What tool do you use to create the Metadata shell?
Configuration Wizard
To qualify a Metric in a Set Qualification
Aggregate a Metric
3 Schema types
46. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
To drill through User Hierarchies
Warehouse Catalog
Data warehouse characteristics
4 properties you must know in order to create attributes using the Attribute Editor
47. View Filters can only ___________.
2-Tier Architecture
Display views you can Print by
Reference Report Objects
Data Pivoting
48. Compound - Homogeneous - Heterogeneous
Heterogeneous Attribute
3 types of Attributes
Project-level options/settings
Simple Attribute Expression
49. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3 Types of Objects in MSTR Desktop
Components of the Logical Data Model
3-Tier Architecture
To create a Report Prompt
50. 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
Notes
OLTP
Heterogeneous Fact
Logical Data Model