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. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Factors to consider when designing a logical data model
Search-based prompts
MSTR applications
Tasks when defining a User Hierarchy
2. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Warehouse Catalog
Fact Expression
Limitations of the Attribute Creation Wizard
Facts
3. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Lookup Table structure of a completely denormalized schema
2 types of Attribute Relationships
Notes
Report Template
4. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
4 parts of the Project Design Process
Derived Attribute Expression
Data Pivoting
Report Definitions
5. OLAP Services does not add any ______ to the report query.
To create a Report Prompt
MSTR Desktop
Thresholding
New SQL
6. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
Report Formatting
Homogeneous Fact
Attribute Forms
7. It contains links to specific folders in the Folder List
3 column types of a Physical Schema
Shortcut Bar
Unlimited
Attribute Creation Wizard good for
8. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Locking and Resizing
Report Formatting
Minimal or none
Drilling
9. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Lookup Tables
Column Aliases
Default Project folder structure
2-Tier Architecture
10. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Components of a Derived Metric
View Filter
4 basic Schema objects
Physical Schema
11. 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
Attribute Forms
Default Project folder structure
Advantage of a completely denormalized schema
Cannot create project objects
12. The unique values of an attribute obtained from the data-warehouse
4 properties you must know in order to create attributes using the Attribute Editor
Attribute Forms
Attribute Elements
4 parts of the Project Design Process
13. View Filters are saved with the _____________.
User Hierarchies
Report Definitions
OLAP
2 types of Table Keys
14. Columns - Tables
5 steps to creating a logical data model
2 components of a Physical Schema
Attribute Forms
Physical Schema
15. Formula - Level (Dimensionality) - Conditionality - Transformation
3 Schema types
Lookup Table structure of a completely normalized schema
Attribute Forms
Components of a Metric
16. User reporting requirements - Query performance - Data volume - DB Maintenance
Hierarchies
Desktop Architec
4 factors to consider when designing a data-warehouse schema
3 Schema types
17. AND - OR - OR NOT - AND NOT
Sorting
Report Filter operators
MSTR applications
Heterogeneous Fact
18. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen
Report Objects
Attribute Forms
Using a Search Object
Logical Data Model
19. Enables you to select which tables from the data-warehouse to store in the Metadata database
The 3 MSTR Tools
View Filter
Warehouse Catalog
Data warehouse characteristics
20. Used to modify a Report
Report Editor
Derived Attribute Expression
Page-by
Highest-level attributes
21. ID columns - Description columns - Fact columns
3 column types of a Physical Schema
OLAP
Default Project folder structure
Components of the Logical Data Model
22. Template - Filter - View of a Report
Desktop Analyst
3 components of a Report
Cannot create project objects
ETL
23. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Schema Objects
Source system characteristics
Outline Mode
Data warehouse characteristics
24. A method of organizing the appearance of report results in a Grid report based on a criteria
The System
Banding
2 methods to creating Facts
Lookup Table structure of a moderately denormalized schema
25. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Search-based prompts
Unlimited
Aggregate a Metric
Locking and Resizing
26. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Stored
Report Prompts
Metrics
Data warehouse characteristics
27. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Shortcut in MSTR Desktop
Relationship Tables
Drilling
3 column types of a Physical Schema
28. One that uses 2 or more columns as its ID
2 components of a Physical Schema
Banding
Compound Attribute
Desktop Designer
29. 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
Derived Metrics
Attribute Elements
3 project creation interfaces
30. Direct: 2-tier - Server: 3-tier
Thresholding
2 ways you can configure the Project Source to connect to the Metadata database
Architect Graphical Interface
MSTR Desktop
31. Groupings of directly related attributes. Also commonly known as "dimensions".
Hierarchies
Report Filter
Logical Data Model
Components of Compound Metrics
32. Schema Objects - Application Objects - Configuration Objects
MSTR applications
Stored
3 Types of Objects in MSTR Desktop
To drill through User Hierarchies
33. View Filters can only ___________.
3 components of a Report
Reference Report Objects
Report Filter
Stored
34. OLTP data storage measure
Gigabytes (GB)
Components of a Derived Metric
'View of a Report'
Project-level options/settings
35. Less storage - Simple SQL - Complex ETL
To "drill down" on a report
Compound Attribute
Process for creating the Project Metadata
Characteristics of a Simple Table Key
36. Facts associated to different column names in 2 or more tables
Banding
Characteristics of a Compound Table Key
Desktop Architec
Heterogeneous Fact
37. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
By default
Filter Definition Prompts
5 steps to creating a logical data model
Attributes
38. A new tool for project design tasks - used for fine-tuning a project after initial creation
Architect Graphical Interface
Project
Desktop Architec
Object Prompts
39. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
OLTP
Schema Objects
4 basic Schema objects
Sorting
40. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Data Pivoting
Project-level options/settings
Project Source
Drilling
41. Reduced number of JOINS in the generated SQL
Sample Metrics commonly performed on Facts
Advantage of a completely denormalized schema
Stored
MSTR OLAP Services
42. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
2 methods to creating Facts
Report Filter operators
Report Subscription
3 components of a Report
43. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Display views you can Print by
Schema
Objects you are allowed to Page-by
44. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Attribute or its relationship(s)
Derived Metrics
Desktop Administrative Functions
MSTR Desktop Architect
45. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Rollback your changes
Attribute Relationships
Application Objects
Homogeneous Fact
46. Homogeneous - Heterogeneous
Limitations of the Attribute Creation Wizard
Minimal or none
2 types of Facts
Report Objects
47. OLAP data storage measure
To create the Project connectivity
Simple Metrics
Terabytes (TB)
Physical Schema
48. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop Architect
2 types of Attribute Expression
Aggregate a Metric
Compound Metric
49. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
ID form
View Filter
4 types of Report Filters
Search Object
50. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
3 types of Attributes
MSTR OLAP Services
Components of the Logical Data Model
Characteristics of a Simple Table Key