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. To define the level of aggregation for a specific metric - Used for qualifications
3-Tier Architecture
5 Report display views
2 types of Facts
Attributes
2. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form
2 types of Attribute Expression
Drilling
3 functions of Attribute Forms
Project Source
3. Simple - Derived
2 types of Attribute Expression
Unlimited
Project Creation Wizard
Subtotals
4. Extraction - transformation - loading
ETL
Derived Attribute Expression
Attribute Elements
Shortcut in MSTR Desktop
5. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Project Creation Wizard
Gigabytes (GB)
Report Objects
Rollback your changes
6. Specifies a condition data must meet in order to be included in a report
5 Report display views
Rollback your changes
Compound Attribute
Report Filter
7. The unique values of an attribute obtained from the data-warehouse
MSTR applications
Page-by
Project Creation Wizard
Attribute Elements
8. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Long-term (2 - 5 years)
2 types of Table Keys
Objects you are allowed to Page-by
Desktop Designer
9. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
To create the Project connectivity
2 ways you can configure the Project Source to connect to the Metadata database
Types of analysis you can perform with OLAP Services
Warehouse Catalog
10. AND - OR - OR NOT - AND NOT
4 parts of the Project Design Process
Report Filter operators
Attribute Forms
Default Project folder structure
11. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
5 Report display views
Methods are there to creating Attributes
Components of Compound Metrics
Components of the Logical Data Model
12. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling
File types are allowed for exporting a Report
Derived Attribute Expression
Tasks when defining a User Hierarchy
5 steps to creating a logical data model
13. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
File types are allowed for exporting a Report
4 tasks of the Attribute Creation Wizard
Lookup Table structure of a moderately denormalized schema
ETL process
14. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Project Creation Wizard
Characteristics of Nested Metrics
Report Filter
3 project creation interfaces
15. You can e-mail reports by going to _____
Minimal or none
File > Email Reports As
Column Aliases
Attribute Relationships
16. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Relationship Tables
Project
OLAP
Reports
17. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Banding
4 types of Report Filters
Thresholding
Simple Metrics
18. Grid View - Graph View - Grid/Graph View - SQL View
Display views you can Print by
Simple Attribute Expression
Attribute Relationships
Lookup Table structure of a moderately denormalized schema
19. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Source system characteristics
The 3 MSTR Tools
Attribute Elements
Project Source
20. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Characteristics of Nested Metrics
Default Project folder structure
4 types of Metrics
Facts
21. Prompts to select a single value on which to qualify a date - number or text string.
Value Prompts
2 types of Attribute Relationships
Factors to consider when designing a logical data model
Gigabytes (GB)
22. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Shortcut Bar
File > Email Reports As
Schema Object Editor
Desktop Analyst
23. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Methods are there to creating Attributes
Report Template
Reports
2 types of Fact Expressions
24. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Filter Definition Prompts
MSTR applications
Tasks when defining a User Hierarchy
Derived Metrics
25. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Report Formatting
2 options for Sorting
3 Types of Objects in MSTR Desktop
Required on the report for Outline Model to work
26. An environment in which the MSTR Desktop connects directly to the Metadata database.
Schema Objects
OLTP
3-Tier Architecture
2-Tier Architecture
27. A feature that enables users to delivers reports to the history list - cache or mobile
Report Template
To create a Report Prompt
Report Subscription
Project
28. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Cannot create project objects
Physical Schema
2 options for Sorting
New SQL
29. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
3 project creation interfaces
4 properties you must know in order to create attributes using the Attribute Editor
Banding
Architect Graphical Interface
30. You must select "Other directions" when drilling attributes while viewing a report
Gigabytes (GB)
Fact Expression
To drill through User Hierarchies
Short-term (2 - 6 months)
31. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters
3 Sections of the MSTR Desktop interface
3 types of Attributes
Warehouse Catalog
4 types of Report Filters
32. Level of OLAP integration
Source system characteristics
Metrics
To "drill down" on a report
Very high; part of ETL process
33. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Aggregate a Metric
MSTR Connectivity Wizard
The System
Attribute or its relationship(s)
34. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Outline Mode
Project
Column Aliases
To create a Report Prompt
35. Tables - Facts - Attributes - Hierarchies
To create a Report Prompt
File > Email Reports As
3 Methods of MSTR Desktop navigation
4 basic Schema objects
36. Facts associated to different column names in 2 or more tables
Attribute Elements
Report Filter
Objects you are allowed to Page-by
Heterogeneous Fact
37. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Report Objects
3-Tier Architecture
Homogeneous Fact
4 basic Schema objects
38. OLTP data storage measure
Gigabytes (GB)
Objects you are allowed to Page-by
Report Filter
Search Object
39. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Rollback your changes
Hierarchies
Schema
MSTR Desktop Architect
40. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
2-Tier Architecture
Application Objects
Attribute Forms
Lookup Tables
41. Formula - Level (Dimensionality) - Conditionality - Transformation
3 project creation interfaces
Components of a Metric
'View of a Report'
To edit the appearance of a Graph in a report
42. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Components of a MSTR architecture
Characteristics of a Compound Table Key
To "drill down" on a report
4 parts of the Project Design Process
43. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
Heterogeneous Attribute
Stored
Banding
44. 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.
Required on the report for Outline Model to work
3 Types of Objects in MSTR Desktop
View Filters
Components of a Metric
45. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Prompts
Subtotals
Sample Metrics commonly performed on Facts
Report Filter
46. Template - Filter - View of a Report
3 components of a Report
Outline Mode
Characteristics of Nested Metrics
Report Filter operators
47. ID columns - Description columns - Fact columns
3 column types of a Physical Schema
To create a Report Prompt
Project Creation Wizard
Report Subscription
48. Attribute Creation Wizard - Attribute Editor
Methods are there to creating Attributes
Advantage of a completely denormalized schema
MSTR OLAP Services
3 Sections of the MSTR Desktop interface
49. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Sample Metrics commonly performed on Facts
Report Filter
Compound Attribute
3 components of a Report
50. Enables you to rearrange the columns and rows in a report.
Data Pivoting
Value Prompts
Derived Attribute Expression
Attribute Forms
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