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. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
2-Tier Architecture
Configuration Wizard
Stored
Homogeneous Attribute
2. The Attribute Form maps to different column names in multiple tables
To "drill down" on a report
Limitations of the Attribute Creation Wizard
Heterogeneous Attribute
New SQL
3. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Fact Tables
Schema Objects
Attribute Creation Wizard good for
2 types of Table Keys
4. 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
Report Filter
Object Prompts
Sorting
Logical Data Model
5. Simple - Derived
Advantage of a completely denormalized schema
2 types of Attribute Expression
Using a Search Object
The System
6. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.
Attribute Forms
To save a Report Format
Data warehouse characteristics
User Hierarchies
7. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
4 tasks of the Attribute Creation Wizard
3 Schema types
Desktop Analyst
2 types of Facts
8. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Report Filter
Physical Schema
Report Objects
Simple Metrics
9. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Level Prompts
To save a Report Format
3 Sections of the MSTR Desktop interface
Reports
10. OLAP data storage measure
Report Formatting
Terabytes (TB)
New SQL
Hierarchies
11. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
5 Report display views
2 types of Fact Expressions
Shortcut in MSTR Desktop
Facts
12. Enables you to select and display subsets of a report as separate pages.
Column Aliases
Page-by
5 steps to creating a logical data model
Reports
13. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Report Objects
The System
Lookup Table structure of a moderately denormalized schema
Search Object
14. A user interface for creating and maintaining a BI environment
'View of a Report'
4 tasks of the Attribute Creation Wizard
MSTR Desktop
Different methods for creating Page-by fields
15. You can _____________ in the Architect Graphical Interface.
Highest-level attributes
Rollback your changes
Project Creation Wizard
Report Definitions
16. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Value Prompts
Outline Mode
Simple Attribute Expression
Report Prompts
17. User reporting requirements - Query performance - Data volume - DB Maintenance
Types of analysis you can perform with OLAP Services
4 factors to consider when designing a data-warehouse schema
Components of a Derived Metric
ID form
18. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Project-level options/settings
View Filter
Page-by
Facts
19. Grid View - Graph View - Grid/Graph View - SQL View
Project Source
2 types of Attribute Expression
Nested Metrics
Display views you can Print by
20. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Homogeneous Attribute
Derived Attribute Expression
2 types of Facts
Aggregate a Metric
21. 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
22. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Required on the report for Outline Model to work
The 3 MSTR Tools
Methods are there to creating Attributes
Project Source
23. The Attribute Form Expression that maps to a single column - no matter the number of tables
Report Objects
Simple Attribute Expression
Desktop Architec
Report Filter
24. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Configuration Wizard
Notes
Rollback your changes
3-Tier Architecture
25. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
3 components of a Report
Gigabytes (GB)
Report Editor
26. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
2 methods to creating Facts
Filter Definition Prompts
Components of the Logical Data Model
Subtotals
27. ID columns - Description columns - Fact columns
View Filter
Long-term (2 - 5 years)
ID form
3 column types of a Physical Schema
28. Facts associated to the same column name in 1 or more tables
Advantage of a completely denormalized schema
Banding
Stored
Homogeneous Fact
29. The unique values of an attribute obtained from the data-warehouse
Terabytes (TB)
Attribute Elements
Project Creation Wizard
Notes
30. Compound - Homogeneous - Heterogeneous
Objects you are allowed to Page-by
3 types of Attributes
Desktop Administrative Functions
Hierarchies
31. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
To save a Report Format
OLTP
Compound Attribute
MSTR Desktop
32. Used to "fine-tune" your Project
Default Project folder structure
Outline Mode
Architect Graphical Interface
Lookup Table structure of a moderately denormalized schema
33. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Project-level options/settings
MSTR OLAP Services
Locking and Resizing
Simple Metrics
34. Descriptive data that provides context for Facts.
Attribute Forms
Process for creating the Project Metadata
To create the Project connectivity
Report Editor
35. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
4 types of Metrics
Report Filter
Types of drilling
36. A feature that enables users to delivers reports to the history list - cache or mobile
Homogeneous Fact
Level Prompts
Report Subscription
Project-level options/settings
37. 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.
Gigabytes (GB)
Reference Report Objects
View Filters
Minimal or none
38. View Filters are saved with the _____________.
Derived Attribute Expression
Report Definitions
The 3 MSTR Tools
Filter Definition Prompts
39. Subtotals reflect accumulations at selected attribute levels
Subtotals
To save a Report Format
4 factors to consider when designing a data-warehouse schema
2 components of a Physical Schema
40. 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
Lookup Table structure of a moderately denormalized schema
2 methods to creating Facts
Physical Schema
41. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Compound Metric
Filter Definition Prompts
Reports
MSTR applications
42. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Reference Report Objects
Locking and Resizing
Desktop Designer
Sorting
43. Create the Project Source - Create the Database Instance
To create the Project connectivity
Gigabytes (GB)
2 types of Facts
Object Prompts
44. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
To "drill down" on a report
2 options for Sorting
User Hierarchies
2 types of Table Keys
45. Simple - Compound - Nested - Derived
Characteristics of a Compound Table Key
Relationship Tables
4 types of Metrics
To create the Project connectivity
46. OLTP data storage measure
Data warehouse characteristics
The 3 MSTR Tools
Gigabytes (GB)
Attribute or its relationship(s)
47. Facts - Attributes - Hierarchies
Application Objects
Components of the Logical Data Model
Report Objects
MSTR Desktop
48. 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
Tasks when defining a User Hierarchy
2-Tier Architecture
Project-level options/settings
Different methods for creating Page-by fields
49. Tables - Facts - Attributes - Hierarchies
Characteristics of a Simple Table Key
4 basic Schema objects
Attribute Creation Wizard good for
Long-term (2 - 5 years)
50. You must select "Other directions" when drilling attributes while viewing a report
Sorting
Types of drilling
3 Types of Objects in MSTR Desktop
To drill through User Hierarchies
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