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. It contains links to specific folders in the Folder List
Table Keys
Tasks when defining a User Hierarchy
Rollback your changes
Shortcut Bar
2. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form
Attribute or its relationship(s)
3 functions of Attribute Forms
2 types of Fact Expressions
Column Aliases
3. Enables you to select and display subsets of a report as separate pages.
4 factors to consider when designing a data-warehouse schema
Components of a Metric
Lookup Table structure of a completely denormalized schema
Page-by
4. User reporting requirements - Query performance - Data volume - DB Maintenance
4 factors to consider when designing a data-warehouse schema
3 Types of Objects in MSTR Desktop
Types of drilling
Attribute Relationships
5. To define the level of aggregation for a specific metric - Used for qualifications
Schema Objects
The System
Rollback your changes
Attributes
6. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Lookup Tables
Schema
Compound Attribute
4 types of Report Filters
7. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
2 methods to creating Facts
View Filters
Desktop Administrative Functions
Attribute Forms
8. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
Source system characteristics
Page-by
Object Prompts
9. Creating multiple attributes quickly. Used during the initial project creation.
2 components of a Physical Schema
Nested Metrics
3 Schema types
Attribute Creation Wizard good for
10. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Stored
ETL process
4 tasks of the Attribute Creation Wizard
ETL
11. Facts associated to different column names in 2 or more tables
Factors to consider when designing a logical data model
Heterogeneous Fact
Filter Definition Prompts
Gigabytes (GB)
12. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Report Subscription
Using a Search Object
Attribute Forms
Derived Attribute Expression
13. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Desktop Analyst
Cannot create project objects
2 types of Attribute Relationships
Reference Report Objects
14. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
New SQL
3 Types of Objects in MSTR Desktop
2 options for Sorting
5 Report display views
15. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Objects you are allowed to Page-by
2 types of Table Keys
Schema Objects
Stored
16. Simple - Compound - Nested - Derived
To edit the appearance of a Graph in a report
Column Aliases
4 types of Metrics
Unlimited
17. Used to limit a possibly overwhelming set of potential prompt answers
Desktop Architec
Default Project folder structure
Search-based prompts
Logical Data Model
18. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Physical Schema
Metrics
MSTR Desktop Architect
Notes
19. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Attribute Elements
Heterogeneous Attribute
Advantage of a completely denormalized schema
Source system characteristics
20. To see data at completely different levels - other than that of the original Grid or Graph
Drilling
Relationship Tables
Attribute Creation Wizard good for
Components of the Logical Data Model
21. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Attribute or its relationship(s)
Different methods for creating Page-by fields
User Hierarchies
Notes
22. It contains the ID column of the parent attribute
To create the Project connectivity
Filter Definition Prompts
Sorting
Lookup Table structure of a completely normalized schema
23. Enables you to rearrange the columns and rows in a report.
Highest-level attributes
ETL
MSTR Desktop Architect
Data Pivoting
24. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Components of the Logical Data Model
Filter Definition Prompts
Attributes
Components of a Metric
25. Create the Project Source - Create the Database Instance
The 3 MSTR Tools
To create the Project connectivity
Attribute Forms
Thresholding
26. User requirements - Existing source data - Technical and performance considerations
Level Prompts
Factors to consider when designing a logical data model
Relationship Tables
Nested Metrics
27. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Objects you are allowed to Page-by
Data warehouse characteristics
2 types of Table Keys
Factors to consider when designing a logical data model
28. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
3-Tier Architecture
Relationship Tables
Search Object
Search-based prompts
29. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Highest-level attributes
Gigabytes (GB)
Desktop Administrative Functions
Advantage of a completely denormalized schema
30. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Compound Metric
4 types of Metrics
Lookup Table structure of a moderately denormalized schema
Desktop Designer
31. 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
Project
Attribute Elements
Report Objects
Types of drilling
32. Used to create or edit complex attributes - facts - hierarchies - and logical tables
2 types of Attribute Relationships
Derived Metrics
Shortcut in MSTR Desktop
Schema Object Editor
33. Subtotals reflect accumulations at selected attribute levels
2 ways you can configure the Project Source to connect to the Metadata database
Subtotals
New SQL
Stored
34. Direct: 2-tier - Server: 3-tier
ETL
Derived Attribute Expression
2 ways you can configure the Project Source to connect to the Metadata database
Types of analysis you can perform with OLAP Services
35. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Minimal or none
2 options for Sorting
Value Prompts
Simple Attribute Expression
36. OLTP data storage measure
Gigabytes (GB)
4 types of Metrics
New SQL
Report Filter operators
37. AND - OR - OR NOT - AND NOT
Different methods for creating Page-by fields
Report Filter operators
Using a Search Object
Rollback your changes
38. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling
ID form
Tasks when defining a User Hierarchy
4 properties you must know in order to create attributes using the Attribute Editor
Locking and Resizing
39. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Characteristics of a Simple Table Key
Tasks when defining a User Hierarchy
Compound Metric
Unlimited
40. It contains the ID column of all higher-level attributes
Lookup Table structure of a moderately denormalized schema
Project
2 components of a Physical Schema
Application Objects
41. More storage - Complex SQL - Simple ETL
Outline Mode
Characteristics of Nested Metrics
ID form
Characteristics of a Compound Table Key
42. A development environment to create BI applications - allowing users to edit the Metadata database
Data warehouse characteristics
Derived Metrics
Desktop Architec
To edit the appearance of a Graph in a report
43. Specifies what info to retrieve from a data-warehouse - and how to display it
ID form
Process for creating the Project Metadata
2 types of Fact Expressions
Report Template
44. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Characteristics of a Compound Table Key
Cannot create project objects
Homogeneous Attribute
Process for creating the Project Metadata
45. Metrics aggregate on the lowest-level attribute __________.
By default
Outline Mode
To drill through User Hierarchies
File > Email Reports As
46. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
Heterogeneous Fact
3 Methods of MSTR Desktop navigation
Shortcut in MSTR Desktop
47. Compound - Homogeneous - Heterogeneous
3 types of Attributes
4 tasks of the Attribute Creation Wizard
By default
Lookup Tables
48. Used for - Initially populating the Metadata - Creating schema objects
Project Creation Wizard
Long-term (2 - 5 years)
Attribute Forms
MSTR Desktop Architect
49. Must have a one-to-one relationship with all other forms.
Metrics
2-Tier Architecture
OLAP
Attribute Forms
50. Facts associated to the same column name in 1 or more tables
OLAP
Hierarchies
Attribute or its relationship(s)
Homogeneous Fact