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. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
User Hierarchies
Unlimited
Application Objects
2. You can _____________ in the Architect Graphical Interface.
Rollback your changes
3 Types of Objects in MSTR Desktop
To qualify a Metric in a Set Qualification
Process for creating the Project Metadata
3. You must select "Other directions" when drilling attributes while viewing a report
Architect Graphical Interface
To drill through User Hierarchies
Objects you are allowed to Page-by
Components of a Derived Metric
4. Groupings of directly related attributes. Also commonly known as "dimensions".
Hierarchies
Column Aliases
Cannot create project objects
Derived Attribute Expression
5. 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
6. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Components of a Metric
Tasks when defining a User Hierarchy
Sample Metrics commonly performed on Facts
Page-by
7. Top menu/dropdowns - Toolbar - Right-click popup menus
3-Tier Architecture
3 Methods of MSTR Desktop navigation
View Filters
To save a Report Format
8. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Level Prompts
ETL
By default
The System
9. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Architect Graphical Interface
4 types of Prompts
Desktop Administrative Functions
Stored
10. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
Report Prompts
Relationship Tables
ETL process
11. A shortcut to an existing Object in a Project
Report Formatting
Outline Mode
Shortcut in MSTR Desktop
Report Objects
12. More storage - Complex SQL - Simple ETL
Locking and Resizing
OLAP
Tasks when defining a User Hierarchy
Characteristics of a Compound Table Key
13. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Report Prompts
Thresholding
Desktop Administrative Functions
Components of a Derived Metric
14. A development environment to create BI applications - allowing users to edit the Metadata database
Characteristics of a Simple Table Key
Desktop Architec
Nested Metrics
4 parts of the Project Design Process
15. Homogeneous - Heterogeneous
Hierarchies
2 types of Facts
Architect Graphical Interface
3 column types of a Physical Schema
16. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2 options for Sorting
The System
Attribute Elements
Different methods for creating Page-by fields
17. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Process for creating the Project Metadata
Warehouse Catalog
Different methods for creating Page-by fields
Fact Expression
18. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
Simple Metrics
4 parts of the Project Design Process
Using a Search Object
19. OLAP retains data ________
Architect Graphical Interface
Drilling
To qualify a Metric in a Set Qualification
Long-term (2 - 5 years)
20. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLTP
ID form
Report Filter operators
View Filter
21. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
MSTR Connectivity Wizard
2 types of Attribute Expression
Limitations of the Attribute Creation Wizard
Homogeneous Fact
22. It contains the ID column of all higher-level attributes
Using a Search Object
Attribute Elements
To save a Report Format
Lookup Table structure of a moderately denormalized schema
23. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Stored
Display views you can Print by
To "drill down" on a report
Objects you are allowed to Page-by
24. View Filters are saved with the _____________.
To edit the appearance of a Graph in a report
The System
Report Definitions
2 types of Attribute Relationships
25. Specifies what info to retrieve from a data-warehouse - and how to display it
4 types of Prompts
Report Template
OLAP
Desktop Architec
26. 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
3 Methods of MSTR Desktop navigation
To "drill down" on a report
Physical Schema
27. 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
Methods are there to creating Attributes
User Hierarchies
Very high; part of ETL process
3 Schema types
28. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Report Definitions
Homogeneous Fact
2-Tier Architecture
Fact Tables
29. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
To qualify a Metric in a Set Qualification
Metrics
Components of a MSTR architecture
Types of analysis you can perform with OLAP Services
30. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Project
To edit the appearance of a Graph in a report
Required on the report for Outline Model to work
Data Pivoting
31. Prompts to select a single value on which to qualify a date - number or text string.
4 factors to consider when designing a data-warehouse schema
Value Prompts
Methods are there to creating Attributes
Process for creating the Project Metadata
32. Used to limit a possibly overwhelming set of potential prompt answers
To "drill down" on a report
3 Types of Objects in MSTR Desktop
Report Template
Search-based prompts
33. 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.
User Hierarchies
Report Objects
Project-level options/settings
Unlimited
34. Attribute Creation Wizard - Attribute Editor
Configuration Wizard
Methods are there to creating Attributes
Value Prompts
Different methods for creating Page-by fields
35. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Fact Expression
3 column types of a Physical Schema
ETL process
Reports
36. Extraction - transformation - loading
Shortcut in MSTR Desktop
Components of a MSTR architecture
ETL
Stored
37. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
4 tasks of the Attribute Creation Wizard
Attributes
Components of a MSTR architecture
Derived Attribute Expression
38. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Facts
Compound Metric
Project
Report Filter
39. Formula - Level (Dimensionality) - Conditionality - Transformation
Reference Report Objects
Characteristics of Nested Metrics
Components of a Metric
Locking and Resizing
40. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Characteristics of a Compound Table Key
MSTR applications
Column Aliases
5 Report display views
41. Grid View - Graph View - Grid/Graph View - SQL View
Report Filter
To create a Report Prompt
Display views you can Print by
File types are allowed for exporting a Report
42. The actual column name for a fact. Every fact must have at least 1 expression.
Subtotals
Compound Metric
Fact Expression
New SQL
43. A new tool for project design tasks - used for fine-tuning a project after initial creation
Architect Graphical Interface
Components of a Derived Metric
Gigabytes (GB)
Heterogeneous Attribute
44. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
3 Methods of MSTR Desktop navigation
Long-term (2 - 5 years)
2 types of Table Keys
3 Types of Objects in MSTR Desktop
45. Used for - Initially populating the Metadata - Creating schema objects
Nested Metrics
Terabytes (TB)
MSTR Desktop Architect
Sample Metrics commonly performed on Facts
46. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3-Tier Architecture
Limitations of the Attribute Creation Wizard
Methods are there to creating Attributes
Attribute Creation Wizard good for
47. Simple - Derived
2 types of Attribute Expression
Report Prompts
Display views you can Print by
Characteristics of a Simple Table Key
48. It contains the ID column of the parent attribute
Report Subscription
Search Object
Lookup Table structure of a completely normalized schema
Data warehouse characteristics
49. The System Hierarchy is automatically updated whenever you make a change to an __________________.
To create a Report Prompt
Report Formatting
Attribute or its relationship(s)
Lookup Table structure of a moderately denormalized schema
50. Enables you to lock column headers so that they always appear when scrolling
Value Prompts
Components of a MSTR architecture
To save a Report Format
Locking and Resizing