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. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
4 properties you must know in order to create attributes using the Attribute Editor
Derived Attribute Expression
Terabytes (TB)
Fact Expression
2. ID columns - Description columns - Fact columns
4 factors to consider when designing a data-warehouse schema
2 types of Attribute Expression
3 column types of a Physical Schema
Characteristics of a Compound Table Key
3. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
File > Email Reports As
View Filter
2 types of Fact Expressions
3 Methods of MSTR Desktop navigation
4. 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
Table Keys
3 Types of Objects in MSTR Desktop
Banding
5. A feature that enables users to delivers reports to the history list - cache or mobile
Application Objects
Search Object
Highest-level attributes
Report Subscription
6. Prompts to select a single value on which to qualify a date - number or text string.
Display views you can Print by
Limitations of the Attribute Creation Wizard
Reports
Value Prompts
7. Filter definition prompts - Object prompts - Value prompts - Level prompts
Components of Compound Metrics
Characteristics of a Compound Table Key
4 types of Prompts
Report Formatting
8. The default entry-points.
Outline Mode
Hierarchies
Lookup Table structure of a moderately denormalized schema
Highest-level attributes
9. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Attribute or its relationship(s)
Characteristics of a Simple Table Key
Aggregate a Metric
Thresholding
10. Enables you to rearrange the columns and rows in a report.
Filter Definition Prompts
Data Pivoting
5 Report display views
Types of drilling
11. Enables you to select and display subsets of a report as separate pages.
Page-by
Compound Attribute
4 factors to consider when designing a data-warehouse schema
4 properties you must know in order to create attributes using the Attribute Editor
12. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Desktop Analyst
2 options for Sorting
MSTR Connectivity Wizard
Different methods for creating Page-by fields
13. 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
3 functions of Attribute Forms
Display views you can Print by
Warehouse Catalog
To drill through User Hierarchies
14. User requirements - Existing source data - Technical and performance considerations
2-Tier Architecture
Factors to consider when designing a logical data model
Attributes
Characteristics of a Compound Table Key
15. Schema Objects - Application Objects - Configuration Objects
Lookup Table structure of a completely denormalized schema
Fact Expression
3 Types of Objects in MSTR Desktop
Compound Attribute
16. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
To create a Report Prompt
To "drill down" on a report
3 Schema types
Search Object
17. Direct: 2-tier - Server: 3-tier
Data Pivoting
Report Objects
Types of analysis you can perform with OLAP Services
2 ways you can configure the Project Source to connect to the Metadata database
18. A new tool for project design tasks - used for fine-tuning a project after initial creation
Configuration Wizard
Long-term (2 - 5 years)
Fact Tables
Architect Graphical Interface
19. Used for - Initially populating the Metadata - Creating schema objects
Types of analysis you can perform with OLAP Services
OLAP
Derived Metrics
MSTR Desktop Architect
20. Level of OLTP integration
3-Tier Architecture
Physical Schema
Minimal or none
Limitations of the Attribute Creation Wizard
21. Specifies a condition data must meet in order to be included in a report
Report Filter
2-Tier Architecture
4 parts of the Project Design Process
Simple Metrics
22. Enables you to select which tables from the data-warehouse to store in the Metadata database
Attribute Creation Wizard good for
Warehouse Catalog
Desktop Analyst
Shortcut Bar
23. A development environment to create BI applications - allowing users to edit the Metadata database
File > Email Reports As
Desktop Architec
Locking and Resizing
Nested Metrics
24. It contains the ID column of the parent attribute
Terabytes (TB)
Report Prompts
Using a Search Object
Lookup Table structure of a completely normalized schema
25. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Homogeneous Attribute
Attributes
The 3 MSTR Tools
Display views you can Print by
26. Enables you to lock column headers so that they always appear when scrolling
Locking and Resizing
Facts
Compound Metric
Reference Report Objects
27. It contains the ID column of all higher-level attributes
Lookup Table structure of a moderately denormalized schema
3 functions of Attribute Forms
Reports
Object Prompts
28. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
ETL process
Drilling
Notes
3 Sections of the MSTR Desktop interface
29. OLAP Services does not add any ______ to the report query.
2 types of Attribute Relationships
To qualify a Metric in a Set Qualification
New SQL
Project Creation Wizard
30. Metrics that perform multiple aggregations; one calculation inside of another.
Report Template
Nested Metrics
Compound Attribute
4 parts of the Project Design Process
31. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
3 functions of Attribute Forms
3 column types of a Physical Schema
Terabytes (TB)
Fact Tables
32. Enables you to format report values based on a condition - such as highlights - font colors - etc.
To edit the appearance of a Graph in a report
Thresholding
Process for creating the Project Metadata
Banding
33. Columns - Tables
Lookup Table structure of a completely normalized schema
Report Template
Rollback your changes
2 components of a Physical Schema
34. Groupings of directly related attributes. Also commonly known as "dimensions".
Drilling
Schema
Default Project folder structure
Hierarchies
35. OLAP data storage measure
File types are allowed for exporting a Report
Rollback your changes
File > Email Reports As
Terabytes (TB)
36. 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
4 types of Report Filters
4 factors to consider when designing a data-warehouse schema
Default Project folder structure
37. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h
Object Prompts
Fact Expression
Default Project folder structure
Page-by
38. Attribute Creation Wizard - Attribute Editor
File types are allowed for exporting a Report
Methods are there to creating Attributes
Attribute Creation Wizard good for
New SQL
39. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Derived Metrics
Metrics
3 project creation interfaces
3 components of a Report
40. 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
Report Editor
Components of a MSTR architecture
Value Prompts
Simple Metrics
41. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.
Report Editor
Long-term (2 - 5 years)
The System
Report Prompts
42. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Tasks when defining a User Hierarchy
Compound Attribute
Components of a MSTR architecture
2 types of Attribute Relationships
43. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Types of drilling
Stored
File > Email Reports As
2 ways you can configure the Project Source to connect to the Metadata database
44. Must have Subtotals enabled - or you won't see any data for higher-level attributes
3 project creation interfaces
3-Tier Architecture
Required on the report for Outline Model to work
Report Prompts
45. Must have a one-to-one relationship with all other forms.
Attribute Forms
Components of a MSTR architecture
Components of the Logical Data Model
Desktop Analyst
46. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Compound Metric
Heterogeneous Fact
Reports
Source system characteristics
47. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Level Prompts
MSTR applications
Source system characteristics
Report Subscription
48. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Different methods for creating Page-by fields
Types of drilling
2-Tier Architecture
4 tasks of the Attribute Creation Wizard
49. OLTP data storage measure
Tasks when defining a User Hierarchy
Aggregate a Metric
Schema
Gigabytes (GB)
50. The Attribute Form maps to different column names in multiple tables
Facts
4 types of Prompts
Heterogeneous Attribute
Shortcut in MSTR Desktop