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. It contains the ID column of all higher-level attributes
Desktop Designer
Lookup Table structure of a moderately denormalized schema
Report Editor
New SQL
2. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Report Formatting
Desktop Analyst
New SQL
Required on the report for Outline Model to work
3. OLAP data storage measure
Aggregate a Metric
Terabytes (TB)
Column Aliases
Report Filter
4. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Reference Report Objects
5 Report display views
2 types of Attribute Relationships
Project
5. Columns - Tables
Desktop Analyst
2 components of a Physical Schema
Types of analysis you can perform with OLAP Services
2 options for Sorting
6. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Minimal or none
To drill through User Hierarchies
Reports
To create the Project connectivity
7. Prompts to select a single value on which to qualify a date - number or text string.
Facts
Advantage of a completely denormalized schema
Value Prompts
Fact Tables
8. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Cannot create project objects
Unlimited
4 types of Metrics
Notes
9. The unique values of an attribute obtained from the data-warehouse
3 Types of Objects in MSTR Desktop
Attribute Elements
2 methods to creating Facts
Desktop Administrative Functions
10. OLAP retains data ________
Long-term (2 - 5 years)
Physical Schema
Using a Search Object
5 Report display views
11. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
The 3 MSTR Tools
Lookup Table structure of a moderately denormalized schema
Attribute Creation Wizard good for
Short-term (2 - 6 months)
12. A user interface for creating and maintaining a BI environment
Source system characteristics
Report Filter
MSTR Desktop
Characteristics of a Simple Table Key
13. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Source system characteristics
Data Pivoting
Facts
Fact Expression
14. Must have a one-to-one relationship with all other forms.
Derived Metrics
Hierarchies
File types are allowed for exporting a Report
Attribute Forms
15. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
File types are allowed for exporting a Report
4 factors to consider when designing a data-warehouse schema
Attribute Elements
Locking and Resizing
16. Allow you to interact with the BI system - logically organize data to analyze complex relationships
To edit the appearance of a Graph in a report
MSTR applications
Heterogeneous Fact
Schema Objects
17. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
2 types of Fact Expressions
View Filters
ETL process
Advantage of a completely denormalized schema
18. It contains the ID and DESC columns of all higher-level attributes
Column Aliases
4 tasks of the Attribute Creation Wizard
Lookup Table structure of a completely denormalized schema
User Hierarchies
19. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Column Aliases
Metrics
Schema
Relationship Tables
20. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters
User Hierarchies
Attribute Forms
4 types of Report Filters
4 types of Metrics
21. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Unlimited
Required on the report for Outline Model to work
4 types of Metrics
Relationship Tables
22. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
3 Types of Objects in MSTR Desktop
ETL process
Methods are there to creating Attributes
2 types of Fact Expressions
23. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
To edit the appearance of a Graph in a report
Default Project folder structure
Sample Metrics commonly performed on Facts
The 3 MSTR Tools
24. 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
Derived Metrics
3 functions of Attribute Forms
2 types of Fact Expressions
3 Sections of the MSTR Desktop interface
25. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Rollback your changes
Desktop Designer
Report Template
To qualify a Metric in a Set Qualification
26. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Logical Data Model
Characteristics of Nested Metrics
Attribute or its relationship(s)
Factors to consider when designing a logical data model
27. A feature that enables users to delivers reports to the history list - cache or mobile
Aggregate a Metric
Derived Metrics
Report Subscription
3 Schema types
28. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Gigabytes (GB)
Report Prompts
Outline Mode
Project Creation Wizard
29. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Thresholding
Compound Metric
Architect Graphical Interface
Schema Object Editor
30. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
3 project creation interfaces
Subtotals
Fact Tables
Limitations of the Attribute Creation Wizard
31. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Level Prompts
4 properties you must know in order to create attributes using the Attribute Editor
Factors to consider when designing a logical data model
Compound Metric
32. To see data at completely different levels - other than that of the original Grid or Graph
Outline Mode
Drilling
Thresholding
Architect Graphical Interface
33. A development environment to create BI applications - allowing users to edit the Metadata database
Desktop Architec
Data Pivoting
Cannot create project objects
Lookup Tables
34. Metrics you create within a report using only those objects in the report.
Project
Derived Metrics
Data warehouse characteristics
Thresholding
35. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
File > Email Reports As
4 parts of the Project Design Process
Short-term (2 - 6 months)
To create a Report Prompt
36. Facts associated to the same column name in 1 or more tables
To create a Report Prompt
Homogeneous Fact
Components of the Logical Data Model
MSTR Connectivity Wizard
37. 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
3 Types of Objects in MSTR Desktop
3 components of a Report
Gigabytes (GB)
Simple Metrics
38. What tool do you use to create the Metadata DSN connection?
Homogeneous Fact
MSTR applications
Report Filter
MSTR Connectivity Wizard
39. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
3-Tier Architecture
3 project creation interfaces
Report Filter
4 tasks of the Attribute Creation Wizard
40. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Page-by
Long-term (2 - 5 years)
5 Report display views
Filter Definition Prompts
41. Facts associated to different column names in 2 or more tables
Heterogeneous Fact
3 types of Attributes
To save a Report Format
Homogeneous Fact
42. Simple - Compound - Nested - Derived
4 types of Metrics
4 basic Schema objects
2 types of Fact Expressions
Locking and Resizing
43. Homogeneous - Heterogeneous
Aggregate a Metric
OLTP
Physical Schema
2 types of Facts
44. A shortcut to an existing Object in a Project
Attribute Relationships
Shortcut in MSTR Desktop
Characteristics of a Compound Table Key
Filter Definition Prompts
45. You must select "Other directions" when drilling attributes while viewing a report
Report Editor
ID form
To drill through User Hierarchies
Components of a Derived Metric
46. What tool do you use to create the Metadata shell?
Default Project folder structure
2 components of a Physical Schema
Configuration Wizard
Simple Metrics
47. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Level Prompts
Table Keys
Physical Schema
2 types of Attribute Expression
48. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLTP
Default Project folder structure
Thresholding
3 types of Attributes
49. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
To create a Report Prompt
Process for creating the Project Metadata
Default Project folder structure
3 Methods of MSTR Desktop navigation
50. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Desktop Administrative Functions
Terabytes (TB)
OLAP
Search-based 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