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. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
5 steps to creating a logical data model
Object Prompts
2 options for Sorting
Schema Object Editor
2. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
2 methods to creating Facts
Gigabytes (GB)
5 steps to creating a logical data model
3. Filter definition prompts - Object prompts - Value prompts - Level prompts
By default
4 types of Prompts
4 tasks of the Attribute Creation Wizard
Heterogeneous Attribute
4. A new tool for project design tasks - used for fine-tuning a project after initial creation
Architect Graphical Interface
Simple Attribute Expression
Tasks when defining a User Hierarchy
2 types of Table Keys
5. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Terabytes (TB)
Application Objects
Very high; part of ETL process
Fact Tables
6. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Value Prompts
4 types of Prompts
3 Types of Objects in MSTR Desktop
The System
7. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
The System
File types are allowed for exporting a Report
Architect Graphical Interface
Required on the report for Outline Model to work
8. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Components of a Derived Metric
2-Tier Architecture
Report Objects
Types of drilling
9. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
ID form
Fact Tables
Advantage of a completely denormalized schema
4 properties you must know in order to create attributes using the Attribute Editor
10. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Filter
Data Pivoting
3 Types of Objects in MSTR Desktop
Simple Attribute Expression
11. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
5 steps to creating a logical data model
4 parts of the Project Design Process
Components of Compound Metrics
By default
12. Enables you to rearrange the columns and rows in a report.
Compound Attribute
Stored
Data Pivoting
Nested Metrics
13. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Process for creating the Project Metadata
Characteristics of a Compound Table Key
Data Pivoting
Derived Metrics
14. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Attribute Creation Wizard good for
Facts
File > Email Reports As
Nested Metrics
15. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Facts
2 types of Attribute Relationships
Subtotals
Attribute Forms
16. 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.
User Hierarchies
Table Keys
Notes
2 ways you can configure the Project Source to connect to the Metadata database
17. 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
2 components of a Physical Schema
Stored
Shortcut Bar
Tasks when defining a User Hierarchy
18. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Types of drilling
Unlimited
Attribute Relationships
Methods are there to creating Attributes
19. Enables you to lock column headers so that they always appear when scrolling
Compound Metric
Locking and Resizing
Characteristics of Nested Metrics
Gigabytes (GB)
20. Direct: 2-tier - Server: 3-tier
Project Creation Wizard
2 ways you can configure the Project Source to connect to the Metadata database
Search-based prompts
Fact Tables
21. Simple - Derived
2 ways you can configure the Project Source to connect to the Metadata database
2 types of Attribute Expression
Components of Compound Metrics
Application Objects
22. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
5 steps to creating a logical data model
Column Aliases
Report Objects
Outline Mode
23. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Notes
Limitations of the Attribute Creation Wizard
4 properties you must know in order to create attributes using the Attribute Editor
Project
24. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Project
Cannot create project objects
Logical Data Model
4 properties you must know in order to create attributes using the Attribute Editor
25. Level of OLAP integration
Factors to consider when designing a logical data model
Very high; part of ETL process
Architect Graphical Interface
Derived Metrics
26. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Advantage of a completely denormalized schema
Physical Schema
File types are allowed for exporting a Report
3 functions of Attribute Forms
27. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
Report Editor
Report Filter
Attribute Creation Wizard good for
28. To see data at completely different levels - other than that of the original Grid or Graph
Drilling
Components of Compound Metrics
2 types of Fact Expressions
View Filter
29. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Value Prompts
Metrics
Compound Attribute
Relationship Tables
30. View Filters can only ___________.
4 types of Prompts
Homogeneous Fact
Reference Report Objects
Filter Definition Prompts
31. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Components of a MSTR architecture
Data warehouse characteristics
Cannot create project objects
Schema Objects
32. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
Level Prompts
Fact Expression
Attribute Forms
33. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Types of drilling
Project Source
Factors to consider when designing a logical data model
Desktop Analyst
34. OLTP retains data ________
Schema Objects
Short-term (2 - 6 months)
View Filters
Nested Metrics
35. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Architect Graphical Interface
Simple Metrics
Heterogeneous Attribute
Different methods for creating Page-by fields
36. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
To qualify a Metric in a Set Qualification
Simple Attribute Expression
Project-level options/settings
4 tasks of the Attribute Creation Wizard
37. 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.
Advantage of a completely denormalized schema
Hierarchies
Application Objects
Report Prompts
38. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Reports
Sorting
The System
Relationship Tables
39. Simple - Compound - Nested - Derived
4 tasks of the Attribute Creation Wizard
Report Template
4 types of Metrics
To "drill down" on a report
40. Compound - Homogeneous - Heterogeneous
Components of the Logical Data Model
View Filters
3 types of Attributes
Objects you are allowed to Page-by
41. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Configuration Wizard
MSTR Connectivity Wizard
5 steps to creating a logical data model
OLAP
42. It contains the ID column of all higher-level attributes
Lookup Table structure of a moderately denormalized schema
Warehouse Catalog
Components of a MSTR architecture
Attribute Forms
43. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Attribute or its relationship(s)
Schema Object Editor
3 types of Attributes
ETL
44. Used for - Initially populating the Metadata - Creating schema objects
3 Methods of MSTR Desktop navigation
MSTR Desktop Architect
Level Prompts
Very high; part of ETL process
45. Columns - Tables
2 components of a Physical Schema
Desktop Designer
4 types of Metrics
4 parts of the Project Design Process
46. Specifies what info to retrieve from a data-warehouse - and how to display it
3 project creation interfaces
Report Template
MSTR Desktop
Objects you are allowed to Page-by
47. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
3 functions of Attribute Forms
OLTP
Attribute Relationships
Sorting
48. 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.
2 types of Attribute Relationships
'View of a Report'
ID form
View Filters
49. Used to "fine-tune" your Project
Sample Metrics commonly performed on Facts
Architect Graphical Interface
Compound Attribute
Heterogeneous Attribute
50. All Attributes must have an _______.
Configuration Wizard
Components of the Logical Data Model
ID form
Level Prompts
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