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 select and display subsets of a report as separate pages.
Page-by
Tasks when defining a User Hierarchy
Schema
3 column types of a Physical Schema
2. View Filters can only ___________.
To save a Report Format
Reference Report Objects
Display views you can Print by
Report Objects
3. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
Simple Metrics
Long-term (2 - 5 years)
Source system characteristics
4. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
ETL process
Nested Metrics
File > Email Reports As
Homogeneous Attribute
5. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Architect Graphical Interface
Configuration Wizard
Attribute Forms
OLTP
6. Top menu/dropdowns - Toolbar - Right-click popup menus
2 components of a Physical Schema
Project-level options/settings
3 Methods of MSTR Desktop navigation
Gigabytes (GB)
7. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filters
Architect Graphical Interface
3 column types of a Physical Schema
View Filter
8. The logical associations between attributes that exist based on a business rule
Tasks when defining a User Hierarchy
Stored
Attribute Relationships
Banding
9. Facts associated to the same column name in 1 or more tables
2 types of Attribute Relationships
Stored
Homogeneous Fact
Metrics
10. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
3 project creation interfaces
4 types of Metrics
Search Object
3 Methods of MSTR Desktop navigation
11. Groupings of directly related attributes. Also commonly known as "dimensions".
Derived Attribute Expression
To "drill down" on a report
Attribute Forms
Hierarchies
12. All Attributes must have an _______.
ID form
Attribute Forms
Relationship Tables
Using a Search Object
13. 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
MSTR OLAP Services
To "drill down" on a report
Report Filter operators
Logical Data Model
14. Metrics aggregate on the lowest-level attribute __________.
3 components of a Report
By default
Physical Schema
Banding
15. AND - OR - OR NOT - AND NOT
Subtotals
To create a Report Prompt
Schema
Report Filter operators
16. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Components of Compound Metrics
Cannot create project objects
Subtotals
Derived Metrics
17. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Data warehouse characteristics
Report Objects
Compound Metric
Required on the report for Outline Model to work
18. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Page-by
2 types of Fact Expressions
Attribute or its relationship(s)
Types of analysis you can perform with OLAP Services
19. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Metrics
Sorting
MSTR Desktop
Desktop Administrative Functions
20. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
MSTR OLAP Services
Locking and Resizing
Attributes
Column Aliases
21. A new tool for project design tasks - used for fine-tuning a project after initial creation
Architect Graphical Interface
3 column types of a Physical Schema
Project-level options/settings
Simple Metrics
22. An environment in which the MSTR Desktop connects directly to the Metadata database.
Hierarchies
Fact Expression
Cannot create project objects
2-Tier Architecture
23. The default entry-points.
4 basic Schema objects
Fact Tables
Sorting
Highest-level attributes
24. A shortcut to an existing Object in a Project
Report Subscription
4 properties you must know in order to create attributes using the Attribute Editor
Shortcut in MSTR Desktop
Terabytes (TB)
25. 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
Level Prompts
4 types of Prompts
To create a Report Prompt
Simple Metrics
26. A user interface for creating and maintaining a BI environment
The 3 MSTR Tools
Configuration Wizard
4 parts of the Project Design Process
MSTR Desktop
27. Specifies what info to retrieve from a data-warehouse - and how to display it
2 types of Attribute Relationships
Report Editor
Report Filter
Report Template
28. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Desktop Designer
5 Report display views
Source system characteristics
Facts
29. The Attribute Form maps to different column names in multiple tables
Heterogeneous Attribute
Search Object
Nested Metrics
Project Source
30. Subtotals reflect accumulations at selected attribute levels
Aggregate a Metric
Source system characteristics
Subtotals
Hierarchies
31. View Filters are saved with the _____________.
Fact Expression
Report Definitions
Attribute Elements
Display views you can Print by
32. OLAP Services does not add any ______ to the report query.
View Filters
Warehouse Catalog
To "drill down" on a report
New SQL
33. What tool do you use to create the Metadata DSN connection?
OLTP
3 column types of a Physical Schema
MSTR Connectivity Wizard
Desktop Architec
34. Schema Objects - Application Objects - Configuration Objects
Characteristics of Nested Metrics
Report Template
Thresholding
3 Types of Objects in MSTR Desktop
35. What tool do you use to create the Metadata shell?
Highest-level attributes
Configuration Wizard
Derived Attribute Expression
Desktop Architec
36. Specifies a condition data must meet in order to be included in a report
Attribute or its relationship(s)
Limitations of the Attribute Creation Wizard
Logical Data Model
Report Filter
37. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
The 3 MSTR Tools
Schema Objects
Report Formatting
Desktop Architec
38. Columns - Tables
To create the Project connectivity
2 components of a Physical Schema
Metrics
3-Tier Architecture
39. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Attribute or its relationship(s)
Rollback your changes
Metrics
Filter Definition Prompts
40. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
Sorting
Highest-level attributes
Report Filter operators
41. 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
Cannot create project objects
3 Sections of the MSTR Desktop interface
Desktop Designer
3 functions of Attribute Forms
42. Metrics you create within a report using only those objects in the report.
View Filter
Default Project folder structure
Derived Metrics
Lookup Tables
43. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
3 components of a Report
User Hierarchies
3 Types of Objects in MSTR Desktop
Facts
44. Level of OLAP integration
Stored
Table Keys
Very high; part of ETL process
File types are allowed for exporting a Report
45. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
To edit the appearance of a Graph in a report
Different methods for creating Page-by fields
Components of a Metric
OLTP
46. One that uses 2 or more columns as its ID
Lookup Table structure of a completely denormalized schema
Compound Attribute
Default Project folder structure
User Hierarchies
47. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Configuration Wizard
Report Formatting
Components of a MSTR architecture
Table Keys
48. Prompts to select a single value on which to qualify a date - number or text string.
Different methods for creating Page-by fields
Warehouse Catalog
Value Prompts
2 ways you can configure the Project Source to connect to the Metadata database
49. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
View Filters
Compound Metric
Attribute Relationships
Facts
50. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Report Editor
OLTP
MSTR applications
Derived Attribute Expression
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