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. Metrics that perform multiple aggregations; one calculation inside of another.
3-Tier Architecture
Thresholding
Page-by
Nested Metrics
2. Must have a one-to-one relationship with all other forms.
Project-level options/settings
Report Template
5 Report display views
Attribute Forms
3. 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
File > Email Reports As
To create a Report Prompt
Default Project folder structure
Source system characteristics
4. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
MSTR Connectivity Wizard
Facts
Project Creation Wizard
Types of drilling
5. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
ETL process
Schema Objects
Default Project folder structure
OLAP
6. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Components of a Metric
Physical Schema
Architect Graphical Interface
Schema
7. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.
Report Prompts
3 column types of a Physical Schema
File > Email Reports As
4 factors to consider when designing a data-warehouse schema
8. Facts associated to different column names in 2 or more tables
Application Objects
Heterogeneous Fact
Physical Schema
Source system characteristics
9. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
User Hierarchies
Aggregate a Metric
Minimal or none
10. Level of OLAP integration
New SQL
Very high; part of ETL process
Project Source
User Hierarchies
11. Create the Project Source - Create the Database Instance
Rollback your changes
To create the Project connectivity
Attribute Forms
Required on the report for Outline Model to work
12. 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
2-Tier Architecture
Reports
To create the Project connectivity
Logical Data Model
13. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
To "drill down" on a report
Components of a Metric
Components of a MSTR architecture
3 project creation interfaces
14. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Level Prompts
MSTR Desktop Architect
Attribute or its relationship(s)
Limitations of the Attribute Creation Wizard
15. Columns - Tables
Advantage of a completely denormalized schema
Reports
To create the Project connectivity
2 components of a Physical Schema
16. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Attributes
To save a Report Format
Physical Schema
Homogeneous Attribute
17. One that uses 2 or more columns as its ID
Object Prompts
Logical Data Model
Compound Attribute
Facts
18. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Column Aliases
2 options for Sorting
Desktop Designer
Project Source
19. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Compound Attribute
Schema Objects
Project Creation Wizard
Sample Metrics commonly performed on Facts
20. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
ETL
Short-term (2 - 6 months)
Facts
To create the Project connectivity
21. The unique values of an attribute obtained from the data-warehouse
Unlimited
3-Tier Architecture
Attribute Elements
Desktop Architec
22. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Simple Attribute Expression
Project-level options/settings
Desktop Designer
Components of a Derived Metric
23. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Object Prompts
To qualify a Metric in a Set Qualification
Fact Tables
ETL
24. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Advantage of a completely denormalized schema
View Filter
Architect Graphical Interface
Components of Compound Metrics
25. Specifies what info to retrieve from a data-warehouse - and how to display it
Terabytes (TB)
To edit the appearance of a Graph in a report
Report Editor
Report Template
26. Enables you to rearrange the columns and rows in a report.
The System
Attribute or its relationship(s)
Data Pivoting
Relationship Tables
27. OLAP Services does not add any ______ to the report query.
Highest-level attributes
4 factors to consider when designing a data-warehouse schema
Characteristics of a Simple Table Key
New SQL
28. Creating multiple attributes quickly. Used during the initial project creation.
4 basic Schema objects
Attribute Creation Wizard good for
To "drill down" on a report
ID form
29. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Required on the report for Outline Model to work
Report Subscription
2 types of Table Keys
Reports
30. Descriptive data that provides context for Facts.
2 types of Fact Expressions
Attribute Forms
Column Aliases
4 tasks of the Attribute Creation Wizard
31. ID columns - Description columns - Fact columns
By default
Value Prompts
Desktop Analyst
3 column types of a Physical Schema
32. A condition data must meet in order to be included in a report. Does affect the SQL.
Process for creating the Project Metadata
To edit the appearance of a Graph in a report
OLAP
Report Filter
33. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Schema
User Hierarchies
3 functions of Attribute Forms
4 parts of the Project Design Process
34. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
MSTR Desktop Architect
Stored
Homogeneous Attribute
Very high; part of ETL process
35. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
To "drill down" on a report
Factors to consider when designing a logical data model
Unlimited
36. A user interface for creating and maintaining a BI environment
MSTR Desktop
Report Formatting
Schema Object Editor
Subtotals
37. OLTP data storage measure
Project
Stored
Components of a Derived Metric
Gigabytes (GB)
38. The logical associations between attributes that exist based on a business rule
Heterogeneous Attribute
Lookup Table structure of a completely denormalized schema
Using a Search Object
Attribute Relationships
39. Enables you to select which tables from the data-warehouse to store in the Metadata database
To create a Report Prompt
Facts
To edit the appearance of a Graph in a report
Warehouse Catalog
40. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Characteristics of a Simple Table Key
Shortcut Bar
Reports
MSTR OLAP Services
41. Less storage - Simple SQL - Complex ETL
Limitations of the Attribute Creation Wizard
Characteristics of a Simple Table Key
Components of Compound Metrics
Table Keys
42. Schema Objects - Application Objects - Configuration Objects
Banding
3 Types of Objects in MSTR Desktop
4 parts of the Project Design Process
2 components of a Physical Schema
43. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
3-Tier Architecture
Desktop Designer
OLAP
44. 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
5 Report display views
Fact Tables
45. Metrics you create within a report using only those objects in the report.
2 components of a Physical Schema
Aggregate a Metric
Derived Metrics
Components of a MSTR architecture
46. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Reference Report Objects
Cannot create project objects
Components of the Logical Data Model
Schema Objects
47. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Types of analysis you can perform with OLAP Services
Simple Attribute Expression
Filter Definition Prompts
Column Aliases
48. Groupings of directly related attributes. Also commonly known as "dimensions".
Hierarchies
Lookup Table structure of a completely normalized schema
To create a Report Prompt
3 components of a Report
49. Grid View - Graph View - Grid/Graph View - SQL View
Filter Definition Prompts
Required on the report for Outline Model to work
Characteristics of a Simple Table Key
Display views you can Print by
50. More storage - Complex SQL - Simple ETL
Characteristics of a Compound Table Key
Report Filter operators
Desktop Analyst
Homogeneous Fact
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