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. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
MSTR Desktop Architect
Reference Report Objects
Attributes
2. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
To create a Report Prompt
Fact Expression
Sample Metrics commonly performed on Facts
3. Filter definition prompts - Object prompts - Value prompts - Level prompts
Compound Metric
4 types of Prompts
Schema
Components of a MSTR architecture
4. A shortcut to an existing Object in a Project
Rollback your changes
Shortcut in MSTR Desktop
2 types of Table Keys
Long-term (2 - 5 years)
5. A new tool for project design tasks - used for fine-tuning a project after initial creation
Thresholding
Filter Definition Prompts
View Filter
Architect Graphical Interface
6. An environment in which the MSTR Desktop connects directly to the Metadata database.
Components of a Metric
Display views you can Print by
2-Tier Architecture
2 ways you can configure the Project Source to connect to the Metadata database
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
Shortcut in MSTR Desktop
Configuration Wizard
Components of Compound Metrics
8. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Lookup Table structure of a completely normalized schema
2 types of Attribute Expression
ETL process
Banding
9. Simple - Derived
MSTR OLAP Services
Simple Attribute Expression
Shortcut Bar
2 types of Attribute Expression
10. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Schema Objects
Search Object
Report Objects
ETL process
11. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
MSTR Connectivity Wizard
Components of a MSTR architecture
To save a Report Format
Filter Definition Prompts
12. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Using a Search Object
Compound Metric
Source system characteristics
Table Keys
13. Enables you to select and display subsets of a report as separate pages.
Page-by
Report Formatting
Reference Report Objects
4 basic Schema objects
14. Facts associated to different column names in 2 or more tables
Report Filter
Heterogeneous Fact
3 Methods of MSTR Desktop navigation
Data warehouse characteristics
15. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Report Editor
Project Creation Wizard
Components of a Metric
Sorting
16. Must have a one-to-one relationship with all other forms.
Attribute Elements
MSTR Desktop
Attribute Forms
Very high; part of ETL process
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
New SQL
Warehouse Catalog
Tasks when defining a User Hierarchy
To "drill down" on a report
18. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Long-term (2 - 5 years)
Components of Compound Metrics
Simple Attribute Expression
Reports
19. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns
ETL process
Limitations of the Attribute Creation Wizard
ID form
3 Schema types
20. The actual column name for a fact. Every fact must have at least 1 expression.
Components of a MSTR architecture
Relationship Tables
Outline Mode
Fact Expression
21. OLAP data storage measure
Project Creation Wizard
Schema
Terabytes (TB)
2 types of Table Keys
22. AND - OR - OR NOT - AND NOT
Nested Metrics
Notes
Value Prompts
Report Filter operators
23. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Objects you are allowed to Page-by
Search Object
Derived Metrics
4 types of Prompts
24. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
4 types of Metrics
The 3 MSTR Tools
5 steps to creating a logical data model
Display views you can Print by
25. Formula - Level (Dimensionality) - Conditionality - Transformation
Gigabytes (GB)
Components of a Metric
Sample Metrics commonly performed on Facts
Report Template
26. The Attribute Form maps to different column names in multiple tables
Types of analysis you can perform with OLAP Services
2 types of Attribute Relationships
Heterogeneous Attribute
4 properties you must know in order to create attributes using the Attribute Editor
27. Subtotals reflect accumulations at selected attribute levels
Very high; part of ETL process
Aggregate a Metric
Subtotals
Objects you are allowed to Page-by
28. The default entry-points.
Components of a Derived Metric
Physical Schema
ETL process
Highest-level attributes
29. User reporting requirements - Query performance - Data volume - DB Maintenance
MSTR OLAP Services
4 factors to consider when designing a data-warehouse schema
MSTR applications
Report Template
30. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
File > Email Reports As
Simple Attribute Expression
Stored
Project
31. Columns - Tables
Desktop Architec
Simple Metrics
2 components of a Physical Schema
To save a Report Format
32. 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
33. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Facts
Level Prompts
Characteristics of Nested Metrics
Using a Search Object
34. Level of OLTP integration
Sample Metrics commonly performed on Facts
Minimal or none
Attributes
New SQL
35. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Simple Attribute Expression
Required on the report for Outline Model to work
Factors to consider when designing a logical data model
Report Objects
36. To see data at completely different levels - other than that of the original Grid or Graph
Schema Object Editor
The 3 MSTR Tools
Desktop Analyst
Drilling
37. A feature that enables users to delivers reports to the history list - cache or mobile
3 Sections of the MSTR Desktop interface
Report Subscription
Schema Object Editor
Project-level options/settings
38. Metrics that perform multiple aggregations; one calculation inside of another.
Nested Metrics
Types of drilling
3 project creation interfaces
Report Definitions
39. Compound - Homogeneous - Heterogeneous
3 types of Attributes
Sample Metrics commonly performed on Facts
MSTR applications
Cannot create project objects
40. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Report Filter
4 types of Report Filters
Heterogeneous Fact
Relationship Tables
41. It contains links to specific folders in the Folder List
Locking and Resizing
Shortcut Bar
Reference Report Objects
Report Editor
42. Enables you to rearrange the columns and rows in a report.
3 Schema types
Thresholding
Data Pivoting
Configuration Wizard
43. Homogeneous - Heterogeneous
Nested Metrics
2 types of Facts
Project
3 Schema types
44. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Attribute Expression
2 types of Table Keys
2 types of Fact Expressions
Components of a MSTR architecture
45. Specifies a condition data must meet in order to be included in a report
4 types of Report Filters
New SQL
Report Filter
By default
46. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Stored
Different methods for creating Page-by fields
2 types of Attribute Relationships
Heterogeneous Attribute
47. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Facts
Desktop Designer
Homogeneous Attribute
4 types of Prompts
48. Metrics aggregate on the lowest-level attribute __________.
4 types of Metrics
Short-term (2 - 6 months)
By default
Value Prompts
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
Different methods for creating Page-by fields
Warehouse Catalog
Methods are there to creating Attributes
Components of a Derived Metric
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)
Report Filter
ETL
OLAP
Gigabytes (GB)
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