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. Grid View - Graph View - Grid/Graph View - SQL View
Lookup Table structure of a moderately denormalized schema
File types are allowed for exporting a Report
Display views you can Print by
Architect Graphical Interface
2. OLTP data storage measure
ETL
To drill through User Hierarchies
Gigabytes (GB)
Methods are there to creating Attributes
3. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Process for creating the Project Metadata
Reference Report Objects
4 parts of the Project Design Process
OLAP
4. Used to "fine-tune" your Project
Attribute Relationships
Architect Graphical Interface
Application Objects
Locking and Resizing
5. User requirements - Existing source data - Technical and performance considerations
Factors to consider when designing a logical data model
Application Objects
Gigabytes (GB)
Aggregate a Metric
6. A development environment to create BI applications - allowing users to edit the Metadata database
MSTR Desktop
Desktop Architec
Physical Schema
Default Project folder structure
7. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2 types of Facts
2 options for Sorting
File types are allowed for exporting a Report
2-Tier Architecture
8. Compound - Homogeneous - Heterogeneous
3 types of Attributes
To create a Report Prompt
Relationship Tables
Factors to consider when designing a logical data model
9. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Desktop Designer
Data Pivoting
Logical Data Model
Minimal or none
10. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Column Aliases
To qualify a Metric in a Set Qualification
MSTR applications
Facts
11. Subtotals reflect accumulations at selected attribute levels
Desktop Administrative Functions
Subtotals
Components of a Derived Metric
Attribute Elements
12. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
2 types of Table Keys
Stored
Source system characteristics
3 Sections of the MSTR Desktop interface
13. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Reference Report Objects
Characteristics of a Simple Table Key
File types are allowed for exporting a Report
Schema
14. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Derived Attribute Expression
3 project creation interfaces
Search Object
Schema Object Editor
15. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
5 Report display views
2 types of Attribute Relationships
Methods are there to creating Attributes
Object Prompts
16. Enables you to select which tables from the data-warehouse to store in the Metadata database
Page-by
Warehouse Catalog
Desktop Designer
Attribute Elements
17. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Terabytes (TB)
Report Filter
Using a Search Object
To edit the appearance of a Graph in a report
18. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
To save a Report Format
'View of a Report'
Lookup Table structure of a moderately denormalized schema
Outline Mode
19. Prompts to select a single value on which to qualify a date - number or text string.
Locking and Resizing
Filter Definition Prompts
Value Prompts
2 components of a Physical Schema
20. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Attribute or its relationship(s)
Unlimited
Homogeneous Attribute
MSTR Connectivity Wizard
21. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations
Subtotals
Application Objects
Simple Metrics
Lookup Table structure of a moderately denormalized schema
22. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Components of Compound Metrics
Data warehouse characteristics
Types of drilling
Sorting
23. To define the level of aggregation for a specific metric - Used for qualifications
Attributes
To edit the appearance of a Graph in a report
Nested Metrics
To drill through User Hierarchies
24. It contains links to specific folders in the Folder List
Highest-level attributes
Shortcut Bar
Required on the report for Outline Model to work
2 types of Facts
25. Tables - Facts - Attributes - Hierarchies
3 Types of Objects in MSTR Desktop
4 basic Schema objects
3-Tier Architecture
Metrics
26. Facts associated to different column names in 2 or more tables
Value Prompts
To create the Project connectivity
Heterogeneous Fact
Application Objects
27. Facts associated to the same column name in 1 or more tables
File types are allowed for exporting a Report
Components of Compound Metrics
Homogeneous Fact
Lookup Table structure of a completely normalized schema
28. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Report Objects
2 ways you can configure the Project Source to connect to the Metadata database
Table Keys
Project-level options/settings
29. Specifies what info to retrieve from a data-warehouse - and how to display it
Report Template
To save a Report Format
4 basic Schema objects
Report Filter operators
30. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Methods are there to creating Attributes
User Hierarchies
Architect Graphical Interface
Object Prompts
31. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Report Filter
Notes
Simple Attribute Expression
Relationship Tables
32. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Physical Schema
Architect Graphical Interface
Cannot create project objects
Application Objects
33. To see data at completely different levels - other than that of the original Grid or Graph
Different methods for creating Page-by fields
Drilling
3 types of Attributes
To save a Report Format
34. The logical associations between attributes that exist based on a business rule
3 Types of Objects in MSTR Desktop
Attribute Relationships
Warehouse Catalog
Attribute Creation Wizard good for
35. An environment in which the MSTR Desktop connects directly to the Metadata database.
Fact Expression
Search-based prompts
2-Tier Architecture
3 Schema types
36. The actual column name for a fact. Every fact must have at least 1 expression.
Types of analysis you can perform with OLAP Services
Fact Expression
Schema Objects
Metrics
37. Metrics you create within a report using only those objects in the report.
Derived Metrics
Types of drilling
3 Schema types
MSTR applications
38. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
3 Schema types
Report Editor
Long-term (2 - 5 years)
39. OLAP data storage measure
Report Subscription
Locking and Resizing
Terabytes (TB)
Attributes
40. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
4 basic Schema objects
The System
4 properties you must know in order to create attributes using the Attribute Editor
Report Filter
41. Used to limit a possibly overwhelming set of potential prompt answers
Types of analysis you can perform with OLAP Services
MSTR Connectivity Wizard
Search-based prompts
ETL process
42. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
Fact Tables
To edit the appearance of a Graph in a report
Metrics
43. It contains the ID and DESC columns of all higher-level attributes
MSTR Desktop Architect
Reports
Project Creation Wizard
Lookup Table structure of a completely denormalized schema
44. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
Cannot create project objects
5 steps to creating a logical data model
Sample Metrics commonly performed on Facts
45. 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
'View of a Report'
Types of drilling
Schema Objects
Minimal or none
46. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
3 Methods of MSTR Desktop navigation
Attribute Creation Wizard good for
Limitations of the Attribute Creation Wizard
Relationship Tables
47. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Stored
To edit the appearance of a Graph in a report
MSTR Desktop Architect
Schema Objects
48. Reduced number of JOINS in the generated SQL
Sorting
Advantage of a completely denormalized schema
Characteristics of a Compound Table Key
Limitations of the Attribute Creation Wizard
49. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
2 methods to creating Facts
Heterogeneous Attribute
The 3 MSTR Tools
Attribute or its relationship(s)
50. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Reference Report Objects
4 factors to consider when designing a data-warehouse schema
Components of a MSTR architecture
User Hierarchies