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. View Filters are saved with the _____________.
4 properties you must know in order to create attributes using the Attribute Editor
Report Definitions
Facts
Characteristics of a Compound Table Key
2. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
2 ways you can configure the Project Source to connect to the Metadata database
4 types of Prompts
Project Source
Derived Attribute Expression
3. It contains links to specific folders in the Folder List
4 parts of the Project Design Process
2 types of Facts
Lookup Tables
Shortcut Bar
4. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Homogeneous Attribute
Methods are there to creating Attributes
OLAP
Column Aliases
5. The default entry-points.
Highest-level attributes
3 Methods of MSTR Desktop navigation
Desktop Designer
Attribute Forms
6. One that uses 2 or more columns as its ID
Factors to consider when designing a logical data model
Data warehouse characteristics
Report Objects
Compound Attribute
7. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Report Formatting
2 types of Attribute Relationships
Aggregate a Metric
Components of a Metric
8. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Subscription
Report Filter
Simple Attribute Expression
To "drill down" on a report
9. Homogeneous - Heterogeneous
Architect Graphical Interface
2 types of Facts
Relationship Tables
MSTR applications
10. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
To qualify a Metric in a Set Qualification
Project Source
3 project creation interfaces
11. Enables you to rearrange the columns and rows in a report.
Column Aliases
Data Pivoting
Schema Object Editor
Components of Compound Metrics
12. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Methods are there to creating Attributes
Compound Attribute
5 steps to creating a logical data model
Desktop Designer
13. Must have a one-to-one relationship with all other forms.
To qualify a Metric in a Set Qualification
Facts
Attribute Forms
Components of Compound Metrics
14. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Configuration Wizard
Components of the Logical Data Model
The System
ID form
15. Groupings of directly related attributes. Also commonly known as "dimensions".
5 steps to creating a logical data model
Desktop Designer
Hierarchies
Project Source
16. Folder List - Object Viewer - Shortcut Bar
Desktop Designer
Tasks when defining a User Hierarchy
Project-level options/settings
3 Sections of the MSTR Desktop interface
17. Metrics that perform multiple aggregations; one calculation inside of another.
Display views you can Print by
2 methods to creating Facts
Nested Metrics
3 components of a Report
18. You can _____________ in the Architect Graphical Interface.
Sample Metrics commonly performed on Facts
Rollback your changes
Cannot create project objects
Application Objects
19. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Report Objects
2 methods to creating Facts
ETL
ETL process
20. More storage - Complex SQL - Simple ETL
Source system characteristics
Characteristics of a Compound Table Key
2 ways you can configure the Project Source to connect to the Metadata database
4 properties you must know in order to create attributes using the Attribute Editor
21. The Attribute Form maps to different column names in multiple tables
Value Prompts
3 components of a Report
ID form
Heterogeneous Attribute
22. The logical associations between attributes that exist based on a business rule
Characteristics of Nested Metrics
Components of a Derived Metric
Source system characteristics
Attribute Relationships
23. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
4 tasks of the Attribute Creation Wizard
Metrics
3 Sections of the MSTR Desktop interface
24. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Project
'View of a Report'
Short-term (2 - 6 months)
2 types of Attribute Relationships
25. An environment in which the MSTR Desktop connects directly to the Metadata database.
Very high; part of ETL process
2-Tier Architecture
'View of a Report'
Schema Object Editor
26. Used to limit a possibly overwhelming set of potential prompt answers
Schema Object Editor
3 Types of Objects in MSTR Desktop
Search-based prompts
The 3 MSTR Tools
27. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Architect Graphical Interface
Components of a Derived Metric
Report Filter
Sample Metrics commonly performed on Facts
28. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
To edit the appearance of a Graph in a report
Application Objects
3 project creation interfaces
Schema Objects
29. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
3 project creation interfaces
Level Prompts
Schema Objects
Relationship Tables
30. Columns - Tables
2 components of a Physical Schema
2 types of Facts
Methods are there to creating Attributes
New SQL
31. Level of OLTP integration
Subtotals
3-Tier Architecture
Minimal or none
Attribute Creation Wizard good for
32. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Unlimited
4 parts of the Project Design Process
Report Objects
Metrics
33. Must have Subtotals enabled - or you won't see any data for higher-level attributes
4 parts of the Project Design Process
2-Tier Architecture
Desktop Analyst
Required on the report for Outline Model to work
34. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Methods are there to creating Attributes
Project Creation Wizard
View Filter
Page-by
35. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Facts
Object Prompts
To create the Project connectivity
Using a Search Object
36. A shortcut to an existing Object in a Project
Gigabytes (GB)
Shortcut in MSTR Desktop
View Filter
Report Subscription
37. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
4 tasks of the Attribute Creation Wizard
Configuration Wizard
Characteristics of a Compound Table Key
Report Formatting
38. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Schema Object Editor
Shortcut in MSTR Desktop
User Hierarchies
Heterogeneous Attribute
39. It contains the ID column of all higher-level attributes
Lookup Table structure of a moderately denormalized schema
Architect Graphical Interface
Configuration Wizard
Components of a MSTR architecture
40. User reporting requirements - Query performance - Data volume - DB Maintenance
Attributes
4 factors to consider when designing a data-warehouse schema
Compound Metric
Report Subscription
41. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
Components of a Derived Metric
Drilling
Attribute Elements
42. Create the Project Source - Create the Database Instance
To create the Project connectivity
Relationship Tables
4 types of Report Filters
Configuration Wizard
43. ID columns - Description columns - Fact columns
3 column types of a Physical Schema
Report Prompts
Desktop Designer
Derived Attribute Expression
44. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Unlimited
OLAP
Project-level options/settings
Components of Compound Metrics
45. What tool do you use to create the Metadata shell?
Project
Configuration Wizard
MSTR Connectivity Wizard
2 types of Facts
46. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Compound Metric
Outline Mode
File types are allowed for exporting a Report
MSTR applications
47. 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
ETL
MSTR Connectivity Wizard
Derived Attribute Expression
48. Tables - Facts - Attributes - Hierarchies
4 basic Schema objects
Objects you are allowed to Page-by
3 Sections of the MSTR Desktop interface
Locking and Resizing
49. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop Architect
Using a Search Object
Drilling
Derived Metrics
50. Grid View - Graph View - Grid/Graph View - SQL View
Rollback your changes
To qualify a Metric in a Set Qualification
Sorting
Display views you can Print by
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