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. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
3 project creation interfaces
OLAP
Architect Graphical Interface
Sorting
2. 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.
Filter Definition Prompts
Derived Attribute Expression
Project
User Hierarchies
3. Create the Project Source - Create the Database Instance
To create the Project connectivity
Components of a MSTR architecture
ID form
Column Aliases
4. Descriptive data that provides context for Facts.
MSTR Connectivity Wizard
Attribute Forms
Desktop Analyst
Source system characteristics
5. 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 functions of Attribute Forms
The 3 MSTR Tools
Components of a MSTR architecture
Methods are there to creating Attributes
6. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Tasks when defining a User Hierarchy
OLAP
Reports
Hierarchies
7. Folder List - Object Viewer - Shortcut Bar
Project-level options/settings
Attribute Elements
3 Sections of the MSTR Desktop interface
5 steps to creating a logical data model
8. Metrics you create within a report using only those objects in the report.
Derived Metrics
Outline Mode
Advantage of a completely denormalized schema
Report Editor
9. The Attribute Form Expression that maps to a single column - no matter the number of tables
Architect Graphical Interface
MSTR Connectivity Wizard
Level Prompts
Simple Attribute Expression
10. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Facts
Project Source
Aggregate a Metric
Data Pivoting
11. It contains the ID column of the parent attribute
Architect Graphical Interface
View Filters
Lookup Table structure of a completely normalized schema
Attributes
12. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Types of analysis you can perform with OLAP Services
Data warehouse characteristics
4 parts of the Project Design Process
Architect Graphical Interface
13. Metrics aggregate on the lowest-level attribute __________.
By default
Lookup Table structure of a moderately denormalized schema
Column Aliases
Aggregate a Metric
14. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
MSTR Desktop
Stored
Report Prompts
5 Report display views
15. Template - Filter - View of a Report
Locking and Resizing
Simple Metrics
3 components of a Report
Page-by
16. A user interface for creating and maintaining a BI environment
MSTR Desktop
Required on the report for Outline Model to work
4 types of Metrics
Sample Metrics commonly performed on Facts
17. An environment in which the MSTR Desktop connects directly to the Metadata database.
Sorting
2-Tier Architecture
4 parts of the Project Design Process
Attribute Forms
18. 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
4 tasks of the Attribute Creation Wizard
Components of a Derived Metric
Logical Data Model
Drilling
19. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Metrics
Sample Metrics commonly performed on Facts
Report Objects
Derived Attribute Expression
20. To define the level of aggregation for a specific metric - Used for qualifications
Project Source
5 Report display views
2-Tier Architecture
Attributes
21. Enables you to lock column headers so that they always appear when scrolling
3 Methods of MSTR Desktop navigation
Locking and Resizing
Components of a Metric
Column Aliases
22. Enables you to select and display subsets of a report as separate pages.
Page-by
Simple Attribute Expression
Reports
Desktop Administrative Functions
23. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Stored
Default Project folder structure
4 types of Prompts
By default
24. User reporting requirements - Query performance - Data volume - DB Maintenance
'View of a Report'
4 factors to consider when designing a data-warehouse schema
Attribute Elements
Tasks when defining a User Hierarchy
25. Specifies what info to retrieve from a data-warehouse - and how to display it
Characteristics of a Simple Table Key
Report Template
New SQL
Attribute Relationships
26. 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
Column Aliases
Fact Tables
3 Schema types
2 types of Attribute Expression
27. Allow you to interact with the BI system - logically organize data to analyze complex relationships
4 types of Report Filters
2 options for Sorting
Logical Data Model
MSTR applications
28. Used to "fine-tune" your Project
Attribute Relationships
Architect Graphical Interface
Level Prompts
Simple Attribute Expression
29. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
MSTR OLAP Services
Advantage of a completely denormalized schema
Attribute Relationships
Lookup Tables
30. Compound - Homogeneous - Heterogeneous
Attribute Creation Wizard good for
Desktop Analyst
Shortcut in MSTR Desktop
3 types of Attributes
31. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3-Tier Architecture
2-Tier Architecture
Heterogeneous Fact
'View of a Report'
32. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Configuration Wizard
2 types of Fact Expressions
Sample Metrics commonly performed on Facts
3-Tier Architecture
33. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
3 types of Attributes
Desktop Administrative Functions
View Filters
Required on the report for Outline Model to work
34. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Notes
Relationship Tables
Page-by
Subtotals
35. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Column Aliases
2 methods to creating Facts
Terabytes (TB)
Facts
36. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
4 types of Metrics
Components of a Derived Metric
Sorting
37. A method of organizing the appearance of report results in a Grid report based on a criteria
2 types of Table Keys
MSTR OLAP Services
Facts
Banding
38. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Simple Attribute Expression
Metrics
File > Email Reports As
Source system characteristics
39. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Shortcut in MSTR Desktop
Column Aliases
2 types of Table Keys
Warehouse Catalog
40. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations
Data warehouse characteristics
Components of the Logical Data Model
Simple Metrics
Schema
41. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
4 factors to consider when designing a data-warehouse schema
Attribute Forms
File types are allowed for exporting a Report
2 options for Sorting
42. Facts - Attributes - Hierarchies
Locking and Resizing
Components of the Logical Data Model
Factors to consider when designing a logical data model
Physical Schema
43. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Derived Attribute Expression
Report Filter operators
Lookup Table structure of a completely denormalized schema
Outline Mode
44. View Filters are saved with the _____________.
Report Definitions
2 components of a Physical Schema
Simple Metrics
Minimal or none
45. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
Aggregate a Metric
Data Pivoting
Logical Data Model
46. Simple - Compound - Nested - Derived
4 types of Metrics
Using a Search Object
Report Filter operators
Display views you can Print by
47. Level of OLTP integration
File types are allowed for exporting a Report
'View of a Report'
2 options for Sorting
Minimal or none
48. Extraction - transformation - loading
2 types of Attribute Relationships
4 properties you must know in order to create attributes using the Attribute Editor
ETL
Object Prompts
49. A development environment to create BI applications - allowing users to edit the Metadata database
Report Filter
Desktop Architec
Using a Search Object
View Filter
50. AND - OR - OR NOT - AND NOT
3 functions of Attribute Forms
Very high; part of ETL process
File > Email Reports As
Report Filter operators
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