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. Facts - Attributes - Hierarchies
Components of the Logical Data Model
Very high; part of ETL process
Report Objects
Notes
2. The Attribute Form maps to the same column name in multiple tables
Short-term (2 - 6 months)
Derived Attribute Expression
Rollback your changes
Homogeneous Attribute
3. 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
3-Tier Architecture
Configuration Wizard
Logical Data Model
Object Prompts
4. Level of OLAP integration
Attribute Creation Wizard good for
Very high; part of ETL process
MSTR Connectivity Wizard
MSTR OLAP Services
5. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Desktop Designer
3 Schema types
MSTR applications
3 Methods of MSTR Desktop navigation
6. Homogeneous - Heterogeneous
Warehouse Catalog
File > Email Reports As
2 types of Facts
Default Project folder structure
7. Top menu/dropdowns - Toolbar - Right-click popup menus
3 Methods of MSTR Desktop navigation
The 3 MSTR Tools
Thresholding
Required on the report for Outline Model to work
8. Must have a one-to-one relationship with all other forms.
Factors to consider when designing a logical data model
Attribute Forms
Data Pivoting
Fact Expression
9. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Metrics
Object Prompts
Aggregate a Metric
Derived Metrics
10. 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.
Characteristics of a Simple Table Key
Project
Report Prompts
Very high; part of ETL process
11. A user interface for creating and maintaining a BI environment
Compound Attribute
MSTR Desktop
Column Aliases
Report Definitions
12. 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
Shortcut in MSTR Desktop
Report Filter
2 types of Attribute Expression
Types of drilling
13. Facts associated to different column names in 2 or more tables
3 column types of a Physical Schema
Heterogeneous Fact
To edit the appearance of a Graph in a report
Report Editor
14. Level of OLTP integration
MSTR OLAP Services
Limitations of the Attribute Creation Wizard
Minimal or none
File types are allowed for exporting a Report
15. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Report Editor
ETL
2 types of Table Keys
Limitations of the Attribute Creation Wizard
16. Using the Prompt Generation Wizard - Inside the Report Editor
Report Subscription
Stored
To create a Report Prompt
Table Keys
17. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Display views you can Print by
5 Report display views
Project Creation Wizard
MSTR applications
18. Creating multiple attributes quickly. Used during the initial project creation.
MSTR Connectivity Wizard
Report Filter
Report Filter
Attribute Creation Wizard good for
19. OLTP retains data ________
Report Filter
Short-term (2 - 6 months)
Heterogeneous Attribute
Fact Tables
20. It contains links to specific folders in the Folder List
Shortcut Bar
Column Aliases
Attributes
Components of a Derived Metric
21. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Types of analysis you can perform with OLAP Services
Unlimited
Components of a Metric
Report Definitions
22. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Sorting
By default
Outline Mode
Attribute Elements
23. A shortcut to an existing Object in a Project
Warehouse Catalog
Shortcut in MSTR Desktop
ID form
Default Project folder structure
24. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Rollback your changes
4 factors to consider when designing a data-warehouse schema
3 project creation interfaces
MSTR OLAP Services
25. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
3 types of Attributes
2 components of a Physical Schema
4 tasks of the Attribute Creation Wizard
Desktop Analyst
26. 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
Relationship Tables
Data Pivoting
Warehouse Catalog
27. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
ETL
Facts
Unlimited
Report Definitions
28. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Drilling
Components of a Derived Metric
Heterogeneous Fact
Facts
29. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Notes
Schema Object Editor
4 types of Metrics
Facts
30. Attribute Creation Wizard - Attribute Editor
Characteristics of Nested Metrics
Report Filter operators
Components of a MSTR architecture
Methods are there to creating Attributes
31. AND - OR - OR NOT - AND NOT
User Hierarchies
Unlimited
MSTR Connectivity Wizard
Report Filter operators
32. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Search-based prompts
Tasks when defining a User Hierarchy
To edit the appearance of a Graph in a report
2 types of Attribute Relationships
33. Schema Objects - Application Objects - Configuration Objects
3 Types of Objects in MSTR Desktop
Relationship Tables
Configuration Wizard
Project Creation Wizard
34. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Components of a Derived Metric
Long-term (2 - 5 years)
4 properties you must know in order to create attributes using the Attribute Editor
Report Definitions
35. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
Components of Compound Metrics
2 options for Sorting
Display views you can Print by
36. User requirements - Existing source data - Technical and performance considerations
Display views you can Print by
3 Sections of the MSTR Desktop interface
MSTR Desktop Architect
Factors to consider when designing a logical data model
37. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Short-term (2 - 6 months)
MSTR Desktop Architect
Required on the report for Outline Model to work
Relationship Tables
38. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Search Object
Rollback your changes
Derived Metrics
Components of a Metric
39. 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
Simple Metrics
Unlimited
4 types of Prompts
File types are allowed for exporting a Report
40. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Using a Search Object
Components of a MSTR architecture
Different methods for creating Page-by fields
Lookup Table structure of a completely normalized schema
41. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
Desktop Analyst
Terabytes (TB)
Fact Expression
42. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Physical Schema
5 Report display views
File types are allowed for exporting a Report
Compound Attribute
43. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Characteristics of a Simple Table Key
To "drill down" on a report
Sample Metrics commonly performed on Facts
MSTR OLAP Services
44. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
The 3 MSTR Tools
2 types of Fact Expressions
Facts
2-Tier Architecture
45. Formula - Level (Dimensionality) - Conditionality - Transformation
To create the Project connectivity
Components of a Metric
Minimal or none
Heterogeneous Fact
46. The Attribute Form Expression that maps to a single column - no matter the number of tables
Long-term (2 - 5 years)
Drilling
Simple Attribute Expression
4 properties you must know in order to create attributes using the Attribute Editor
47. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
ETL process
Derived Metrics
Physical Schema
Report Filter operators
48. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Homogeneous Fact
2 types of Table Keys
Report Filter
4 types of Report Filters
49. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
2 types of Attribute Relationships
Components of a MSTR architecture
Aggregate a Metric
Highest-level attributes
50. Metrics you create within a report using only those objects in the report.
Sorting
2 components of a Physical Schema
3 types of Attributes
Derived Metrics
Sorry!:) No result found.
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests