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. Less storage - Simple SQL - Complex ETL
Relationship Tables
Simple Attribute Expression
Attribute Elements
Characteristics of a Simple Table Key
2. Compound - Homogeneous - Heterogeneous
Very high; part of ETL process
ETL
3 types of Attributes
2 methods to creating Facts
3. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
3 Schema types
Unlimited
2 types of Table Keys
Long-term (2 - 5 years)
4. You can e-mail reports by going to _____
Simple Metrics
File > Email Reports As
Thresholding
Project Source
5. To see data at completely different levels - other than that of the original Grid or Graph
Project Creation Wizard
MSTR Desktop
Drilling
View Filters
6. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Facts
Desktop Administrative Functions
Subtotals
Reports
7. Enables you to rearrange the columns and rows in a report.
Attribute or its relationship(s)
Level Prompts
Data Pivoting
MSTR Connectivity Wizard
8. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Limitations of the Attribute Creation Wizard
Report Filter operators
MSTR applications
Homogeneous Fact
9. Folder List - Object Viewer - Shortcut Bar
Long-term (2 - 5 years)
3 Sections of the MSTR Desktop interface
3 functions of Attribute Forms
Report Objects
10. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
4 properties you must know in order to create attributes using the Attribute Editor
Compound Attribute
To qualify a Metric in a Set Qualification
To edit the appearance of a Graph in a report
11. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Object Prompts
Short-term (2 - 6 months)
Advantage of a completely denormalized schema
Components of Compound Metrics
12. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
3-Tier Architecture
Very high; part of ETL process
OLTP
Source system characteristics
13. One that uses 2 or more columns as its ID
Compound Attribute
Using a Search Object
Report Objects
Default Project folder structure
14. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Level Prompts
New SQL
Using a Search Object
Very high; part of ETL process
15. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Project Source
2 types of Attribute Relationships
Display views you can Print by
Data warehouse characteristics
16. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Data Pivoting
Search Object
Heterogeneous Fact
4 tasks of the Attribute Creation Wizard
17. Grid View - Graph View - Grid/Graph View - SQL View
Simple Metrics
4 types of Report Filters
2 types of Fact Expressions
Display views you can Print by
18. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Characteristics of a Simple Table Key
Derived Attribute Expression
Components of a MSTR architecture
Heterogeneous Attribute
19. A development environment to create BI applications - allowing users to edit the Metadata database
To create a Report Prompt
Desktop Architec
3 Sections of the MSTR Desktop interface
Column Aliases
20. Top menu/dropdowns - Toolbar - Right-click popup menus
Shortcut in MSTR Desktop
Display views you can Print by
Architect Graphical Interface
3 Methods of MSTR Desktop navigation
21. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Simple Attribute Expression
Tasks when defining a User Hierarchy
OLAP
Architect Graphical Interface
22. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Project-level options/settings
2 methods to creating Facts
Factors to consider when designing a logical data model
Shortcut in MSTR Desktop
23. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Compound Metric
Application Objects
Project
Objects you are allowed to Page-by
24. 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
Shortcut in MSTR Desktop
To qualify a Metric in a Set Qualification
View Filters
3 column types of a Physical Schema
25. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Schema Objects
Components of a MSTR architecture
Outline Mode
Nested Metrics
26. The Attribute Form maps to different column names in multiple tables
'View of a Report'
Column Aliases
Heterogeneous Attribute
To "drill down" on a report
27. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
4 parts of the Project Design Process
Using a Search Object
Simple Metrics
Heterogeneous Attribute
28. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Banding
Homogeneous Fact
Report Filter
2 options for Sorting
29. 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
Value Prompts
Data Pivoting
Locking and Resizing
Tasks when defining a User Hierarchy
30. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Desktop Designer
Desktop Analyst
Report Filter operators
MSTR OLAP Services
31. The Attribute Form Expression that maps to a single column - no matter the number of tables
Nested Metrics
Simple Attribute Expression
Application Objects
Drilling
32. Used to modify a Report
5 Report display views
Rollback your changes
Report Editor
Attribute Forms
33. The default entry-points.
Highest-level attributes
The 3 MSTR Tools
To "drill down" on a report
Stored
34. Metrics you create within a report using only those objects in the report.
Sample Metrics commonly performed on Facts
4 types of Prompts
Report Template
Derived Metrics
35. A new tool for project design tasks - used for fine-tuning a project after initial creation
Shortcut in MSTR Desktop
Architect Graphical Interface
MSTR OLAP Services
Attributes
36. You must select "Other directions" when drilling attributes while viewing a report
Using a Search Object
To drill through User Hierarchies
Methods are there to creating Attributes
Project Creation Wizard
37. A method of organizing the appearance of report results in a Grid report based on a criteria
5 steps to creating a logical data model
Banding
Sorting
Locking and Resizing
38. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
2 types of Facts
Desktop Administrative Functions
ETL process
4 types of Metrics
39. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Warehouse Catalog
2 types of Fact Expressions
Homogeneous Fact
To save a Report Format
40. It contains the ID and DESC columns of all higher-level attributes
Characteristics of Nested Metrics
2 types of Fact Expressions
Homogeneous Fact
Lookup Table structure of a completely denormalized schema
41. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
2 types of Attribute Relationships
Derived Metrics
MSTR Desktop
Report Formatting
42. Specifies a condition data must meet in order to be included in a report
Outline Mode
Report Filter
Attribute Forms
Sample Metrics commonly performed on Facts
43. Filter definition prompts - Object prompts - Value prompts - Level prompts
5 Report display views
3 components of a Report
4 types of Prompts
Fact Expression
44. Homogeneous - Heterogeneous
Heterogeneous Fact
MSTR Desktop Architect
2 types of Facts
2 options for Sorting
45. Descriptive data that provides context for Facts.
Shortcut in MSTR Desktop
Desktop Administrative Functions
Facts
Attribute Forms
46. The Attribute Form maps to the same column name in multiple tables
Page-by
Report Formatting
Homogeneous Attribute
Heterogeneous Attribute
47. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
5 steps to creating a logical data model
Limitations of the Attribute Creation Wizard
Thresholding
Homogeneous Fact
48. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Subtotals
Fact Expression
Object Prompts
Report Subscription
49. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
5 Report display views
Subtotals
Components of the Logical Data Model
Components of a Derived Metric
50. A subset of a report that users can manipulate without altering the SQL
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
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