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. Reduced number of JOINS in the generated SQL
Compound Attribute
Tasks when defining a User Hierarchy
Advantage of a completely denormalized schema
OLTP
2. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Facts
Cannot create project objects
Locking and Resizing
Types of analysis you can perform with OLAP Services
3. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
To qualify a Metric in a Set Qualification
Aggregate a Metric
Sample Metrics commonly performed on Facts
4. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Physical Schema
Source system characteristics
MSTR Desktop Architect
File > Email Reports As
5. The default entry-points.
To "drill down" on a report
Column Aliases
4 parts of the Project Design Process
Highest-level attributes
6. Enables you to rearrange the columns and rows in a report.
Data Pivoting
Shortcut in MSTR Desktop
To "drill down" on a report
OLAP
7. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Using a Search Object
4 types of Prompts
Components of a Metric
MSTR OLAP Services
8. A user interface for creating and maintaining a BI environment
Limitations of the Attribute Creation Wizard
Compound Metric
Attribute or its relationship(s)
MSTR Desktop
9. Metrics that perform multiple aggregations; one calculation inside of another.
Methods are there to creating Attributes
Nested Metrics
Gigabytes (GB)
Reference Report Objects
10. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Outline Mode
Report Formatting
View Filter
Sorting
11. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Drilling
Different methods for creating Page-by fields
Heterogeneous Attribute
Components of a Metric
12. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
2 types of Table Keys
Data warehouse characteristics
Characteristics of a Compound Table Key
Components of a Metric
13. AND - OR - OR NOT - AND NOT
Notes
4 basic Schema objects
Report Filter operators
Attribute or its relationship(s)
14. Facts - Attributes - Hierarchies
Tasks when defining a User Hierarchy
OLTP
Components of the Logical Data Model
3-Tier Architecture
15. User reporting requirements - Query performance - Data volume - DB Maintenance
3 types of Attributes
Short-term (2 - 6 months)
4 factors to consider when designing a data-warehouse schema
Attribute Creation Wizard good for
16. Enables you to select which tables from the data-warehouse to store in the Metadata database
Warehouse Catalog
Desktop Architec
Project Source
To save a Report Format
17. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
4 parts of the Project Design Process
Desktop Designer
Simple Attribute Expression
2 types of Table Keys
18. OLAP Services does not add any ______ to the report query.
New SQL
Limitations of the Attribute Creation Wizard
Configuration Wizard
Relationship Tables
19. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Object Prompts
Project Creation Wizard
The System
Display views you can Print by
20. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Attributes
Terabytes (TB)
'View of a Report'
2 methods to creating Facts
21. Attribute Creation Wizard - Attribute Editor
Methods are there to creating Attributes
4 types of Report Filters
Architect Graphical Interface
MSTR OLAP Services
22. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Lookup Tables
Sample Metrics commonly performed on Facts
Stored
To drill through User Hierarchies
23. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
Project Creation Wizard
Attribute or its relationship(s)
Locking and Resizing
24. A feature that enables users to delivers reports to the history list - cache or mobile
Project-level options/settings
MSTR Desktop
Report Subscription
View Filter
25. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy
Default Project folder structure
Desktop Designer
Architect Graphical Interface
Types of drilling
26. One that uses 2 or more columns as its ID
4 factors to consider when designing a data-warehouse schema
Sample Metrics commonly performed on Facts
Compound Attribute
4 types of Report Filters
27. Metrics you create within a report using only those objects in the report.
Required on the report for Outline Model to work
Derived Metrics
3 components of a Report
Drilling
28. 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
Project Source
Sample Metrics commonly performed on Facts
Column Aliases
To qualify a Metric in a Set Qualification
29. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Filter Definition Prompts
Column Aliases
Metrics
Components of a MSTR architecture
30. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
ETL process
4 types of Prompts
Facts
Sorting
31. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Report Filter
Facts
Nested Metrics
2 types of Attribute Relationships
32. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
3 Sections of the MSTR Desktop interface
Project-level options/settings
Logical Data Model
Limitations of the Attribute Creation Wizard
33. Specifies a condition data must meet in order to be included in a report
Outline Mode
Report Filter
Value Prompts
Report Prompts
34. Formula - Level (Dimensionality) - Conditionality - Transformation
5 steps to creating a logical data model
Report Editor
Sorting
Components of a Metric
35. The logical associations between attributes that exist based on a business rule
By default
Shortcut in MSTR Desktop
Attribute Relationships
Data warehouse characteristics
36. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
4 factors to consider when designing a data-warehouse schema
To create the Project connectivity
Schema Object Editor
Object Prompts
37. How users can share comments for reports to other users
Attribute Elements
Process for creating the Project Metadata
Notes
ETL process
38. What tool do you use to create the Metadata DSN connection?
4 types of Prompts
File > Email Reports As
4 factors to consider when designing a data-warehouse schema
MSTR Connectivity Wizard
39. What tool do you use to create the Metadata shell?
Configuration Wizard
3 Schema types
Desktop Designer
4 properties you must know in order to create attributes using the Attribute Editor
40. Subtotals reflect accumulations at selected attribute levels
Short-term (2 - 6 months)
4 parts of the Project Design Process
Schema
Subtotals
41. It contains links to specific folders in the Folder List
Filter Definition Prompts
Report Formatting
Shortcut Bar
Subtotals
42. The unique values of an attribute obtained from the data-warehouse
Methods are there to creating Attributes
Attribute Elements
Architect Graphical Interface
2 methods to creating Facts
43. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Factors to consider when designing a logical data model
Compound Attribute
View Filter
Schema Objects
44. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
Compound Metric
Notes
Required on the report for Outline Model to work
45. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Process for creating the Project Metadata
4 tasks of the Attribute Creation Wizard
Simple Metrics
Very high; part of ETL process
46. Groupings of directly related attributes. Also commonly known as "dimensions".
Report Objects
2 ways you can configure the Project Source to connect to the Metadata database
File types are allowed for exporting a Report
Hierarchies
47. Simple - Compound - Nested - Derived
Search-based prompts
Components of a Derived Metric
4 types of Metrics
ETL
48. All Attributes must have an _______.
4 types of Prompts
3-Tier Architecture
Banding
ID form
49. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Gigabytes (GB)
3 components of a Report
Project Source
4 types of Prompts
50. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Report Prompts
Aggregate a Metric
5 steps to creating a logical data model
Subtotals