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. User requirements - Existing source data - Technical and performance considerations
Report Prompts
Table Keys
Factors to consider when designing a logical data model
OLTP
2. Descriptive data that provides context for Facts.
Notes
Attribute Forms
OLTP
2 options for Sorting
3. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Relationship Tables
Configuration Wizard
Required on the report for Outline Model to work
Different methods for creating Page-by fields
4. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Filter Definition Prompts
Banding
Schema Object Editor
Attribute or its relationship(s)
5. 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
'View of a Report'
Logical Data Model
Required on the report for Outline Model to work
Compound Metric
6. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
ETL
Source system characteristics
Sample Metrics commonly performed on Facts
Level Prompts
7. Create the Project Source - Create the Database Instance
Long-term (2 - 5 years)
Schema
To create the Project connectivity
New SQL
8. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Source system characteristics
4 types of Prompts
New SQL
Thresholding
9. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Characteristics of Nested Metrics
Schema Object Editor
Process for creating the Project Metadata
Desktop Administrative Functions
10. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns
3 Schema types
Highest-level attributes
Types of analysis you can perform with OLAP Services
Report Filter
11. More storage - Complex SQL - Simple ETL
To drill through User Hierarchies
Thresholding
Characteristics of a Compound Table Key
2 methods to creating Facts
12. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
2 types of Facts
MSTR Connectivity Wizard
4 tasks of the Attribute Creation Wizard
Aggregate a Metric
13. It contains links to specific folders in the Folder List
Shortcut Bar
Report Filter operators
4 properties you must know in order to create attributes using the Attribute Editor
Heterogeneous Fact
14. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Desktop Administrative Functions
2 types of Fact Expressions
User Hierarchies
MSTR Desktop Architect
15. OLAP data storage measure
Terabytes (TB)
2 options for Sorting
Search-based prompts
Sample Metrics commonly performed on Facts
16. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
To create a Report Prompt
Rollback your changes
Fact Tables
Facts
17. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Simple Attribute Expression
Minimal or none
Report Definitions
Desktop Administrative Functions
18. Level of OLAP integration
ETL
4 tasks of the Attribute Creation Wizard
Very high; part of ETL process
Objects you are allowed to Page-by
19. Simple - Compound - Nested - Derived
Compound Metric
Architect Graphical Interface
4 types of Metrics
By default
20. Prompts to select a single value on which to qualify a date - number or text string.
Components of the Logical Data Model
Heterogeneous Attribute
Value Prompts
2 types of Fact Expressions
21. AND - OR - OR NOT - AND NOT
Project-level options/settings
Tasks when defining a User Hierarchy
Report Filter operators
4 types of Metrics
22. Store info on relationships between 2 or more tables (attributes) - like an Index table.
2 options for Sorting
3 Sections of the MSTR Desktop interface
Relationship Tables
Homogeneous Attribute
23. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Simple Attribute Expression
Unlimited
OLTP
2 types of Table Keys
24. A feature that enables users to delivers reports to the history list - cache or mobile
To qualify a Metric in a Set Qualification
Report Subscription
Data Pivoting
Rollback your changes
25. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
MSTR Desktop Architect
Compound Attribute
Highest-level attributes
4 tasks of the Attribute Creation Wizard
26. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
4 types of Prompts
2 types of Table Keys
Sorting
Lookup Table structure of a moderately denormalized schema
27. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Methods are there to creating Attributes
To "drill down" on a report
4 parts of the Project Design Process
2 types of Attribute Expression
28. How users can share comments for reports to other users
'View of a Report'
Notes
3 Sections of the MSTR Desktop interface
Simple Attribute Expression
29. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Outline Mode
Compound Attribute
Stored
Heterogeneous Attribute
30. Formula - Level (Dimensionality) - Conditionality - Transformation
MSTR Desktop Architect
Report Objects
Components of a Metric
View Filter
31. 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
3 components of a Report
MSTR Desktop
Homogeneous Fact
32. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Attributes
OLTP
Report Editor
Compound Metric
33. View Filters can only ___________.
Long-term (2 - 5 years)
Relationship Tables
Reference Report Objects
Facts
34. Used to "fine-tune" your Project
Architect Graphical Interface
To "drill down" on a report
Reports
Nested Metrics
35. Subtotals reflect accumulations at selected attribute levels
5 steps to creating a logical data model
4 types of Prompts
Heterogeneous Fact
Subtotals
36. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
2 types of Attribute Expression
Outline Mode
Lookup Table structure of a completely denormalized schema
Report Objects
37. The actual column name for a fact. Every fact must have at least 1 expression.
Locking and Resizing
Fact Expression
View Filters
Nested Metrics
38. Simple - Derived
2 types of Attribute Expression
Project-level options/settings
Report Template
MSTR OLAP Services
39. You can _____________ in the Architect Graphical Interface.
Report Template
Hierarchies
4 factors to consider when designing a data-warehouse schema
Rollback your changes
40. ID columns - Description columns - Fact columns
3 column types of a Physical Schema
2 types of Fact Expressions
Report Subscription
Report Definitions
41. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
Table Keys
Derived Metrics
Homogeneous Attribute
42. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
4 parts of the Project Design Process
2-Tier Architecture
Drilling
User Hierarchies
43. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Metrics
Lookup Tables
3 Schema types
Project
44. Facts associated to the same column name in 1 or more tables
Homogeneous Fact
MSTR Desktop
Reports
Minimal or none
45. OLTP data storage measure
Gigabytes (GB)
Desktop Architec
Drilling
Desktop Administrative Functions
46. All Attributes must have an _______.
Report Filter operators
Source system characteristics
ID form
Logical Data Model
47. A development environment to create BI applications - allowing users to edit the Metadata database
3 Sections of the MSTR Desktop interface
Desktop Architec
Fact Expression
Required on the report for Outline Model to work
48. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Short-term (2 - 6 months)
Derived Attribute Expression
Shortcut Bar
Limitations of the Attribute Creation Wizard
49. Filter definition prompts - Object prompts - Value prompts - Level prompts
Derived Attribute Expression
Fact Tables
Fact Expression
4 types of Prompts
50. Enables you to select and display subsets of a report as separate pages.
MSTR Desktop Architect
Using a Search Object
Page-by
Report Definitions
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