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. Groupings of directly related attributes. Also commonly known as "dimensions".
Project
Hierarchies
2 types of Facts
File > Email Reports As
2. Facts - Attributes - Hierarchies
Components of the Logical Data Model
2 types of Attribute Expression
Characteristics of Nested Metrics
Notes
3. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
To qualify a Metric in a Set Qualification
User Hierarchies
Desktop Architec
3 Methods of MSTR Desktop navigation
4. You must select "Other directions" when drilling attributes while viewing a report
MSTR OLAP Services
Sample Metrics commonly performed on Facts
3 Sections of the MSTR Desktop interface
To drill through User Hierarchies
5. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Aggregate a Metric
Characteristics of a Compound Table Key
ETL process
2 options for Sorting
6. 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
MSTR Desktop
The 3 MSTR Tools
3 project creation interfaces
Tasks when defining a User Hierarchy
7. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
To "drill down" on a report
3 Schema types
Logical Data Model
Components of a Derived Metric
8. Filter definition prompts - Object prompts - Value prompts - Level prompts
View Filter
Types of analysis you can perform with OLAP Services
4 types of Prompts
Heterogeneous Attribute
9. OLTP retains data ________
3 components of a Report
Short-term (2 - 6 months)
Lookup Table structure of a completely denormalized schema
File > Email Reports As
10. More storage - Complex SQL - Simple ETL
Filter Definition Prompts
Report Template
Characteristics of a Compound Table Key
Report Definitions
11. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
To create a Report Prompt
Types of analysis you can perform with OLAP Services
Terabytes (TB)
View Filters
12. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Required on the report for Outline Model to work
Components of Compound Metrics
Desktop Designer
Factors to consider when designing a logical data model
13. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Different methods for creating Page-by fields
Simple Attribute Expression
4 properties you must know in order to create attributes using the Attribute Editor
Architect Graphical Interface
14. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Sorting
Heterogeneous Fact
2 types of Attribute Relationships
3 project creation interfaces
15. A new tool for project design tasks - used for fine-tuning a project after initial creation
Lookup Table structure of a moderately denormalized schema
Architect Graphical Interface
Simple Attribute Expression
OLAP
16. One that uses 2 or more columns as its ID
Compound Attribute
Metrics
MSTR OLAP Services
Locking and Resizing
17. AND - OR - OR NOT - AND NOT
To drill through User Hierarchies
ID form
Reports
Report Filter operators
18. A subset of a report that users can manipulate without altering the SQL
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
19. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Project Source
Drilling
Report Objects
Schema
20. Grid View - Graph View - Grid/Graph View - SQL View
3 column types of a Physical Schema
Display views you can Print by
Logical Data Model
Level Prompts
21. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Source system characteristics
4 properties you must know in order to create attributes using the Attribute Editor
3 Types of Objects in MSTR Desktop
4 parts of the Project Design Process
22. The logical associations between attributes that exist based on a business rule
Attribute Forms
Lookup Table structure of a completely normalized schema
4 properties you must know in order to create attributes using the Attribute Editor
Attribute Relationships
23. View Filters can only ___________.
Required on the report for Outline Model to work
Components of the Logical Data Model
Report Filter
Reference Report Objects
24. A method of organizing the appearance of report results in a Grid report based on a criteria
Desktop Architec
Project Creation Wizard
Banding
Homogeneous Fact
25. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLTP
Lookup Table structure of a completely denormalized schema
Reference Report Objects
Homogeneous Fact
26. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
3-Tier Architecture
Schema Object Editor
Project-level options/settings
Search Object
27. 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
Attributes
Default Project folder structure
ID form
28. Subtotals reflect accumulations at selected attribute levels
Subtotals
Fact Expression
Report Filter
Level Prompts
29. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Shortcut Bar
Display views you can Print by
MSTR OLAP Services
Desktop Administrative Functions
30. Enables you to select which tables from the data-warehouse to store in the Metadata database
Warehouse Catalog
Value Prompts
Minimal or none
Architect Graphical Interface
31. You can _____________ in the Architect Graphical Interface.
Rollback your changes
Simple Metrics
Very high; part of ETL process
Short-term (2 - 6 months)
32. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Report Filter operators
Different methods for creating Page-by fields
3 Schema types
Homogeneous Attribute
33. Top menu/dropdowns - Toolbar - Right-click popup menus
3 Methods of MSTR Desktop navigation
3 column types of a Physical Schema
Short-term (2 - 6 months)
Types of analysis you can perform with OLAP Services
34. 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
3 Schema types
Logical Data Model
3 functions of Attribute Forms
Characteristics of a Compound Table Key
35. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
The 3 MSTR Tools
5 Report display views
2 options for Sorting
Derived Metrics
36. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Application Objects
Long-term (2 - 5 years)
Aggregate a Metric
To edit the appearance of a Graph in a report
37. Schema Objects - Application Objects - Configuration Objects
3 Types of Objects in MSTR Desktop
Stored
Terabytes (TB)
Objects you are allowed to Page-by
38. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
MSTR applications
Process for creating the Project Metadata
4 parts of the Project Design Process
Banding
39. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Schema Object Editor
Lookup Table structure of a moderately denormalized schema
Source system characteristics
The 3 MSTR Tools
40. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Desktop Designer
5 steps to creating a logical data model
Minimal or none
Sorting
41. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Desktop Administrative Functions
4 tasks of the Attribute Creation Wizard
To qualify a Metric in a Set Qualification
Reports
42. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Required on the report for Outline Model to work
Display views you can Print by
Architect Graphical Interface
Components of the Logical Data Model
43. The unique values of an attribute obtained from the data-warehouse
New SQL
Lookup Tables
Attribute Elements
Report Prompts
44. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Relationship Tables
5 Report display views
3 Types of Objects in MSTR Desktop
3 functions of Attribute Forms
45. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Subtotals
2 types of Table Keys
Schema Object Editor
Attribute Creation Wizard good for
46. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h
2 ways you can configure the Project Source to connect to the Metadata database
Default Project folder structure
Filter Definition Prompts
Metrics
47. Used to modify a Report
Table Keys
Unlimited
Derived Metrics
Report Editor
48. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Subtotals
4 types of Report Filters
Using a Search Object
2 methods to creating Facts
49. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Minimal or none
Report Editor
MSTR Desktop Architect
Cannot create project objects
50. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Report Objects
File types are allowed for exporting a Report
MSTR OLAP Services
View Filter
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