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. Level of OLAP integration
To create a Report Prompt
'View of a Report'
Very high; part of ETL process
File > Email Reports As
2. 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
Simple Metrics
Attribute Elements
Factors to consider when designing a logical data model
By default
3. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Gigabytes (GB)
Column Aliases
3 project creation interfaces
Schema
4. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
4 tasks of the Attribute Creation Wizard
Value Prompts
Warehouse Catalog
Fact Tables
5. Subtotals reflect accumulations at selected attribute levels
Homogeneous Fact
Project Source
Aggregate a Metric
Subtotals
6. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Project
Configuration Wizard
Report Formatting
Lookup Table structure of a completely denormalized schema
7. Facts associated to different column names in 2 or more tables
2 methods to creating Facts
Heterogeneous Fact
Data warehouse characteristics
Methods are there to creating Attributes
8. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Report Definitions
Shortcut Bar
User Hierarchies
Project Creation Wizard
9. Metrics aggregate on the lowest-level attribute __________.
Subtotals
2-Tier Architecture
By default
Heterogeneous Fact
10. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Stored
Search Object
4 factors to consider when designing a data-warehouse schema
OLTP
11. It contains the ID column of all higher-level attributes
Project-level options/settings
Desktop Administrative Functions
3 Types of Objects in MSTR Desktop
Lookup Table structure of a moderately denormalized schema
12. ID columns - Description columns - Fact columns
Types of analysis you can perform with OLAP Services
Attribute Elements
3 column types of a Physical Schema
Lookup Tables
13. OLTP data storage measure
Required on the report for Outline Model to work
Subtotals
3 functions of Attribute Forms
Gigabytes (GB)
14. Template - Filter - View of a Report
Attribute or its relationship(s)
Simple Metrics
3 components of a Report
Report Prompts
15. A feature that enables users to delivers reports to the history list - cache or mobile
Characteristics of Nested Metrics
Long-term (2 - 5 years)
Report Subscription
Cannot create project objects
16. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Project Creation Wizard
Using a Search Object
Default Project folder structure
Object Prompts
17. Primary keys
Table Keys
Required on the report for Outline Model to work
New SQL
Default Project folder structure
18. 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
3 Sections of the MSTR Desktop interface
4 factors to consider when designing a data-warehouse schema
4 basic Schema objects
3 Schema types
19. Must have a one-to-one relationship with all other forms.
2 components of a Physical Schema
Column Aliases
3 Types of Objects in MSTR Desktop
Attribute Forms
20. Enables you to select and display subsets of a report as separate pages.
Page-by
Report Filter operators
Reference Report Objects
Derived Metrics
21. Groupings of directly related attributes. Also commonly known as "dimensions".
Methods are there to creating Attributes
4 types of Metrics
Hierarchies
Sorting
22. Folder List - Object Viewer - Shortcut Bar
3 Sections of the MSTR Desktop interface
Attribute or its relationship(s)
Lookup Table structure of a moderately denormalized schema
Notes
23. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop Architect
4 types of Prompts
To create a Report Prompt
Simple Attribute Expression
24. The unique values of an attribute obtained from the data-warehouse
Lookup Table structure of a moderately denormalized schema
Fact Expression
Attribute Elements
Page-by
25. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Relationship Tables
The System
4 types of Metrics
4 tasks of the Attribute Creation Wizard
26. Simple - Compound - Nested - Derived
Metrics
Advantage of a completely denormalized schema
3 functions of Attribute Forms
4 types of Metrics
27. A condition data must meet in order to be included in a report. Does affect the SQL.
Attribute Creation Wizard good for
File > Email Reports As
To create a Report Prompt
Report Filter
28. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
Attribute Elements
Gigabytes (GB)
Using a Search Object
29. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Objects you are allowed to Page-by
Homogeneous Attribute
Locking and Resizing
Attribute or its relationship(s)
30. Facts associated to the same column name in 1 or more tables
5 steps to creating a logical data model
Minimal or none
Homogeneous Fact
3 Types of Objects in MSTR Desktop
31. 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
Default Project folder structure
Attribute Forms
Lookup Table structure of a completely denormalized schema
Subtotals
32. One that uses 2 or more columns as its ID
Default Project folder structure
To "drill down" on a report
Limitations of the Attribute Creation Wizard
Compound Attribute
33. 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
To qualify a Metric in a Set Qualification
3 functions of Attribute Forms
4 properties you must know in order to create attributes using the Attribute Editor
By default
34. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
3 column types of a Physical Schema
Display views you can Print by
OLAP
Components of Compound Metrics
35. Level of OLTP integration
Heterogeneous Attribute
ETL
Report Filter
Minimal or none
36. View Filters are saved with the _____________.
Report Definitions
Report Filter
5 steps to creating a logical data model
Rollback your changes
37. Schema Objects - Application Objects - Configuration Objects
Default Project folder structure
3 Methods of MSTR Desktop navigation
Minimal or none
3 Types of Objects in MSTR Desktop
38. The Attribute Form maps to the same column name in multiple tables
Attribute Creation Wizard good for
To qualify a Metric in a Set Qualification
Homogeneous Attribute
2 types of Attribute Expression
39. Top menu/dropdowns - Toolbar - Right-click popup menus
3 Methods of MSTR Desktop navigation
Report Definitions
2 types of Attribute Relationships
Different methods for creating Page-by fields
40. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Stored
Long-term (2 - 5 years)
Report Formatting
Schema Object Editor
41. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Hierarchies
To qualify a Metric in a Set Qualification
3 Schema types
Facts
42. Enables you to lock column headers so that they always appear when scrolling
Filter Definition Prompts
Locking and Resizing
Terabytes (TB)
Desktop Analyst
43. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
2 types of Fact Expressions
Components of the Logical Data Model
To save a Report Format
To edit the appearance of a Graph in a report
44. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Reports
Report Objects
Compound Metric
Components of a Derived Metric
45. Reduced number of JOINS in the generated SQL
Data warehouse characteristics
Different methods for creating Page-by fields
3 project creation interfaces
Advantage of a completely denormalized schema
46. Compound - Homogeneous - Heterogeneous
Data warehouse characteristics
Value Prompts
3 types of Attributes
To "drill down" on a report
47. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Default Project folder structure
File > Email Reports As
Level Prompts
MSTR applications
48. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Reports
Report Formatting
Desktop Administrative Functions
The 3 MSTR Tools
49. Allow you to interact with the BI system - logically organize data to analyze complex relationships
4 types of Report Filters
To edit the appearance of a Graph in a report
Report Formatting
MSTR applications
50. More storage - Complex SQL - Simple ETL
Components of a Metric
Characteristics of a Compound Table Key
Attribute Forms
Desktop Designer
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