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. Primary keys
Derived Metrics
Table Keys
3 Types of Objects in MSTR Desktop
Page-by
2. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
Process for creating the Project Metadata
Derived Metrics
Terabytes (TB)
3. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
2-Tier Architecture
Report Definitions
Data Pivoting
Project Source
4. Prompts to select a single value on which to qualify a date - number or text string.
Drilling
Value Prompts
Heterogeneous Attribute
The 3 MSTR Tools
5. Groupings of directly related attributes. Also commonly known as "dimensions".
Hierarchies
Project-level options/settings
Reports
Sorting
6. View Filters are saved with the _____________.
Project Source
Advantage of a completely denormalized schema
Application Objects
Report Definitions
7. The logical associations between attributes that exist based on a business rule
Data warehouse characteristics
Objects you are allowed to Page-by
User Hierarchies
Attribute Relationships
8. AND - OR - OR NOT - AND NOT
Schema Objects
Report Filter operators
Lookup Table structure of a completely normalized schema
Report Filter
9. Enables you to select which tables from the data-warehouse to store in the Metadata database
Derived Attribute Expression
4 basic Schema objects
Nested Metrics
Warehouse Catalog
10. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
To edit the appearance of a Graph in a report
Facts
3 types of Attributes
Different methods for creating Page-by fields
11. Facts associated to the same column name in 1 or more tables
Report Subscription
Configuration Wizard
3 Methods of MSTR Desktop navigation
Homogeneous Fact
12. Reduced number of JOINS in the generated SQL
To save a Report Format
Desktop Architec
Nested Metrics
Advantage of a completely denormalized schema
13. All Attributes must have an _______.
Shortcut in MSTR Desktop
ID form
Terabytes (TB)
Display views you can Print by
14. A condition data must meet in order to be included in a report. Does affect the SQL.
Lookup Table structure of a completely denormalized schema
Report Filter
Project Source
Locking and Resizing
15. Facts associated to different column names in 2 or more tables
2 ways you can configure the Project Source to connect to the Metadata database
Heterogeneous Fact
'View of a Report'
5 Report display views
16. Must have Subtotals enabled - or you won't see any data for higher-level attributes
The 3 MSTR Tools
MSTR Desktop
Report Editor
Required on the report for Outline Model to work
17. Level of OLTP integration
Required on the report for Outline Model to work
File > Email Reports As
Display views you can Print by
Minimal or none
18. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
5 steps to creating a logical data model
Banding
Lookup Table structure of a completely normalized schema
19. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Project Creation Wizard
Desktop Administrative Functions
Short-term (2 - 6 months)
OLTP
20. Metrics that perform multiple aggregations; one calculation inside of another.
Column Aliases
Nested Metrics
Types of analysis you can perform with OLAP Services
Objects you are allowed to Page-by
21. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.
View Filters
4 factors to consider when designing a data-warehouse schema
Attribute or its relationship(s)
To save a Report Format
22. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
4 basic Schema objects
Lookup Tables
To save a Report Format
To "drill down" on a report
23. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Minimal or none
Attribute Creation Wizard good for
Methods are there to creating Attributes
MSTR applications
24. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Attribute or its relationship(s)
3 Methods of MSTR Desktop navigation
Homogeneous Attribute
Architect Graphical Interface
25. Descriptive data that provides context for Facts.
Data warehouse characteristics
Attribute Forms
By default
Components of a Metric
26. OLTP data storage measure
Compound Metric
Shortcut Bar
ETL
Gigabytes (GB)
27. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Tasks when defining a User Hierarchy
5 steps to creating a logical data model
Schema Object Editor
4 types of Prompts
28. Direct: 2-tier - Server: 3-tier
To edit the appearance of a Graph in a report
Required on the report for Outline Model to work
2 ways you can configure the Project Source to connect to the Metadata database
Lookup Tables
29. Attribute Creation Wizard - Attribute Editor
MSTR applications
3 Sections of the MSTR Desktop interface
2 types of Attribute Relationships
Methods are there to creating Attributes
30. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Fact Tables
Compound Metric
Application Objects
Schema Object Editor
31. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
User Hierarchies
Column Aliases
Level Prompts
32. User reporting requirements - Query performance - Data volume - DB Maintenance
Thresholding
4 factors to consider when designing a data-warehouse schema
Attributes
Attribute Relationships
33. 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
Configuration Wizard
Data warehouse characteristics
Attribute Elements
34. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
4 tasks of the Attribute Creation Wizard
4 basic Schema objects
Simple Metrics
To create the Project connectivity
35. Metrics aggregate on the lowest-level attribute __________.
By default
Report Filter
The System
Aggregate a Metric
36. Formula - Level (Dimensionality) - Conditionality - Transformation
To edit the appearance of a Graph in a report
Report Formatting
Subtotals
Components of a Metric
37. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
MSTR Connectivity Wizard
Project
Drilling
Table Keys
38. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Components of Compound Metrics
Reference Report Objects
Facts
39. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop Architect
ID form
To qualify a Metric in a Set Qualification
Report Template
40. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Using a Search Object
Desktop Analyst
Types of drilling
Attribute Relationships
41. 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
4 factors to consider when designing a data-warehouse schema
2 methods to creating Facts
Nested Metrics
42. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Column Aliases
Configuration Wizard
Cannot create project objects
Compound Metric
43. Used to "fine-tune" your Project
Attribute or its relationship(s)
Architect Graphical Interface
Attribute Elements
Components of a MSTR architecture
44. Filter definition prompts - Object prompts - Value prompts - Level prompts
Shortcut in MSTR Desktop
4 types of Prompts
Metrics
2 ways you can configure the Project Source to connect to the Metadata database
45. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
New SQL
4 parts of the Project Design Process
Notes
Report Formatting
46. Using the Prompt Generation Wizard - Inside the Report Editor
To create a Report Prompt
To save a Report Format
Table Keys
Reference Report Objects
47. Columns - Tables
MSTR applications
Report Editor
Attribute Creation Wizard good for
2 components of a Physical Schema
48. A method of organizing the appearance of report results in a Grid report based on a criteria
Fact Expression
Banding
Fact Tables
2 types of Facts
49. To see data at completely different levels - other than that of the original Grid or Graph
Components of Compound Metrics
Page-by
Search-based prompts
Drilling
50. The Attribute Form maps to the same column name in multiple tables
Report Filter operators
Homogeneous Attribute
The System
4 types of Prompts
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