SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
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. The Attribute Form maps to different column names in multiple tables
Simple Metrics
Heterogeneous Attribute
File types are allowed for exporting a Report
OLAP
2. A user interface for creating and maintaining a BI environment
Report Formatting
The 3 MSTR Tools
MSTR Desktop
Using a Search Object
3. Compound - Homogeneous - Heterogeneous
3 types of Attributes
Architect Graphical Interface
3-Tier Architecture
Schema
4. Subtotals reflect accumulations at selected attribute levels
MSTR Connectivity Wizard
Value Prompts
Schema Object Editor
Subtotals
5. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Lookup Table structure of a moderately denormalized schema
Desktop Administrative Functions
Report Formatting
Data Pivoting
6. All report-level options overwrite ___________.
Default Project folder structure
Fact Tables
Project-level options/settings
File > Email Reports As
7. Create the Project Source - Create the Database Instance
To create the Project connectivity
MSTR applications
Components of a MSTR architecture
3 Methods of MSTR Desktop navigation
8. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
2-Tier Architecture
Different methods for creating Page-by fields
Subtotals
Desktop Architec
9. User reporting requirements - Query performance - Data volume - DB Maintenance
Data warehouse characteristics
3 Schema types
Tasks when defining a User Hierarchy
4 factors to consider when designing a data-warehouse schema
10. Homogeneous - Heterogeneous
Lookup Table structure of a completely denormalized schema
2 types of Facts
MSTR applications
Fact Tables
11. The actual column name for a fact. Every fact must have at least 1 expression.
Cannot create project objects
2 options for Sorting
Fact Expression
Application Objects
12. You can _____________ in the Architect Graphical Interface.
Rollback your changes
Lookup Tables
Sample Metrics commonly performed on Facts
Report Editor
13. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
2 options for Sorting
Report Filter
View Filter
2 methods to creating Facts
14. Used to create or edit complex attributes - facts - hierarchies - and logical tables
User Hierarchies
Schema Object Editor
Logical Data Model
Components of a Derived Metric
15. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Lookup Tables
Lookup Table structure of a completely normalized schema
Desktop Designer
Project Source
16. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Aggregate a Metric
2-Tier Architecture
Process for creating the Project Metadata
Drilling
17. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Nested Metrics
Report Definitions
Homogeneous Attribute
3-Tier Architecture
18. OLAP retains data ________
Notes
Long-term (2 - 5 years)
Derived Metrics
By default
19. Enables you to select which tables from the data-warehouse to store in the Metadata database
Locking and Resizing
Hierarchies
Warehouse Catalog
Attribute Elements
20. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
4 types of Prompts
2 types of Fact Expressions
Fact Tables
Cannot create project objects
21. Using the Prompt Generation Wizard - Inside the Report Editor
Reports
Derived Metrics
Outline Mode
To create a Report Prompt
22. Columns - Tables
2 components of a Physical Schema
Characteristics of a Simple Table Key
Reports
Compound Attribute
23. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
Aggregate a Metric
Factors to consider when designing a logical data model
Attribute Forms
24. View Filters can only ___________.
3 project creation interfaces
Desktop Designer
Reference Report Objects
Notes
25. One that uses 2 or more columns as its ID
Lookup Table structure of a moderately denormalized schema
Compound Attribute
ETL
2 types of Attribute Expression
26. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop Architect
User Hierarchies
Types of analysis you can perform with OLAP Services
Components of a MSTR architecture
27. Specifies a condition data must meet in order to be included in a report
Characteristics of a Simple Table Key
Lookup Table structure of a moderately denormalized schema
Report Filter
2-Tier Architecture
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
Nested Metrics
'View of a Report'
2 ways you can configure the Project Source to connect to the Metadata database
To qualify a Metric in a Set Qualification
29. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
4 tasks of the Attribute Creation Wizard
Project
Logical Data Model
The 3 MSTR Tools
30. Used to limit a possibly overwhelming set of potential prompt answers
Limitations of the Attribute Creation Wizard
Project
Attribute Relationships
Search-based prompts
31. What tool do you use to create the Metadata shell?
Objects you are allowed to Page-by
Configuration Wizard
File > Email Reports As
MSTR applications
32. Store info on relationships between 2 or more tables (attributes) - like an Index table.
3-Tier Architecture
Relationship Tables
Page-by
5 Report display views
33. A shortcut to an existing Object in a Project
Aggregate a Metric
Shortcut in MSTR Desktop
Configuration Wizard
Report Filter operators
34. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
4 parts of the Project Design Process
Project Source
Page-by
Components of Compound Metrics
35. Less storage - Simple SQL - Complex ETL
Characteristics of a Simple Table Key
By default
Report Filter
5 Report display views
36. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Compound Attribute
Search Object
Fact Tables
Report Prompts
37. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Report Template
By default
Schema Objects
Logical Data Model
38. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
4 types of Prompts
Stored
Reports
Schema Objects
39. Prompts to select a single value on which to qualify a date - number or text string.
Shortcut Bar
Application Objects
Homogeneous Fact
Value Prompts
40. Enables you to select and display subsets of a report as separate pages.
To drill through User Hierarchies
Page-by
Notes
Reports
41. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Default Project folder structure
Schema
Table Keys
Schema Objects
42. AND - OR - OR NOT - AND NOT
Highest-level attributes
Report Filter operators
Search-based prompts
Heterogeneous Attribute
43. Creating multiple attributes quickly. Used during the initial project creation.
Shortcut in MSTR Desktop
Attribute Creation Wizard good for
ETL
Project Source
44. Used to modify a Report
Derived Attribute Expression
Default Project folder structure
Lookup Table structure of a completely normalized schema
Report Editor
45. OLAP Services does not add any ______ to the report query.
New SQL
Using a Search Object
The System
Attribute Forms
46. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
5 steps to creating a logical data model
View Filters
Reports
2 ways you can configure the Project Source to connect to the Metadata database
47. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Source system characteristics
Lookup Table structure of a moderately denormalized schema
Locking and Resizing
The System
48. Metrics that perform multiple aggregations; one calculation inside of another.
To save a Report Format
5 Report display views
Nested Metrics
4 factors to consider when designing a data-warehouse schema
49. What tool do you use to create the Metadata DSN connection?
Long-term (2 - 5 years)
MSTR Connectivity Wizard
4 tasks of the Attribute Creation Wizard
ID form
50. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a completely denormalized schema
Lookup Tables
Display views you can Print by
Subtotals