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. Grid View - Graph View - Grid/Graph View - SQL View
View Filters
Display views you can Print by
ID form
Report Filter
2. Specifies what info to retrieve from a data-warehouse - and how to display it
Subtotals
Process for creating the Project Metadata
Tasks when defining a User Hierarchy
Report Template
3. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Configuration Wizard
Components of a Metric
The 3 MSTR Tools
New SQL
4. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Heterogeneous Attribute
Required on the report for Outline Model to work
View Filters
Heterogeneous Fact
5. A user interface for creating and maintaining a BI environment
Project-level options/settings
Hierarchies
MSTR Desktop
Components of a Derived Metric
6. Create the Project Source - Create the Database Instance
2 options for Sorting
2 methods to creating Facts
File > Email Reports As
To create the Project connectivity
7. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
Thresholding
User Hierarchies
Data Pivoting
8. 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
Characteristics of a Simple Table Key
Terabytes (TB)
Logical Data Model
To "drill down" on a report
9. Enables you to lock column headers so that they always appear when scrolling
Aggregate a Metric
Attribute Relationships
View Filters
Locking and Resizing
10. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Page-by
Simple Attribute Expression
Project
To save a Report Format
11. 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
Tasks when defining a User Hierarchy
Schema Object Editor
Report Template
Data warehouse characteristics
12. Level of OLTP integration
Minimal or none
Advantage of a completely denormalized schema
2 methods to creating Facts
New SQL
13. An environment in which the MSTR Desktop connects directly to the Metadata database.
Report Editor
Characteristics of a Compound Table Key
Report Definitions
2-Tier Architecture
14. Less storage - Simple SQL - Complex ETL
ETL process
Characteristics of a Simple Table Key
Architect Graphical Interface
OLAP
15. Homogeneous - Heterogeneous
2 types of Facts
Lookup Tables
Heterogeneous Attribute
Fact Expression
16. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Stored
Short-term (2 - 6 months)
3 components of a Report
17. All Attributes must have an _______.
To qualify a Metric in a Set Qualification
ID form
Facts
2 components of a Physical Schema
18. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
4 types of Metrics
Gigabytes (GB)
2 types of Fact Expressions
Methods are there to creating Attributes
19. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
4 tasks of the Attribute Creation Wizard
To create a Report Prompt
Physical Schema
2-Tier Architecture
20. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Sample Metrics commonly performed on Facts
Shortcut in MSTR Desktop
To "drill down" on a report
Stored
21. 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
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
Components of a Derived Metric
Unlimited
Default Project folder structure
View Filter
23. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
OLTP
Hierarchies
Architect Graphical Interface
Lookup Tables
24. OLAP Services does not add any ______ to the report query.
New SQL
MSTR Desktop Architect
Types of analysis you can perform with OLAP Services
Reference Report Objects
25. The default entry-points.
Gigabytes (GB)
Project Source
New SQL
Highest-level attributes
26. A shortcut to an existing Object in a Project
Architect Graphical Interface
Shortcut in MSTR Desktop
Types of analysis you can perform with OLAP Services
Different methods for creating Page-by fields
27. 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
The System
Simple Metrics
Attributes
To create a Report Prompt
28. Schema Objects - Application Objects - Configuration Objects
MSTR Desktop Architect
Facts
Attribute Creation Wizard good for
3 Types of Objects in MSTR Desktop
29. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Facts
Project Source
Compound Metric
Desktop Architec
30. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Report Definitions
Reports
Notes
Unlimited
31. Subtotals reflect accumulations at selected attribute levels
Lookup Table structure of a completely denormalized schema
Compound Metric
Subtotals
3 project creation interfaces
32. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
MSTR Desktop
Notes
By default
Schema Objects
33. Level of OLAP integration
Characteristics of Nested Metrics
View Filter
Very high; part of ETL process
Fact Tables
34. View Filters can only ___________.
3 column types of a Physical Schema
Attribute Forms
Reference Report Objects
Fact Expression
35. Tables - Facts - Attributes - Hierarchies
4 basic Schema objects
Lookup Tables
5 Report display views
To save a Report Format
36. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Metrics
2 methods to creating Facts
Lookup Table structure of a completely normalized schema
File types are allowed for exporting a Report
37. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Fact Tables
Banding
View Filter
Application Objects
38. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Sample Metrics commonly performed on Facts
3 Methods of MSTR Desktop navigation
Advantage of a completely denormalized schema
2 options for Sorting
39. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Facts
4 properties you must know in order to create attributes using the Attribute Editor
File types are allowed for exporting a Report
4 types of Report Filters
40. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Relationship Tables
Aggregate a Metric
Different methods for creating Page-by fields
Data warehouse characteristics
41. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
MSTR OLAP Services
Simple Metrics
2 types of Table Keys
4 factors to consider when designing a data-warehouse schema
42. Metrics aggregate on the lowest-level attribute __________.
By default
OLAP
To create the Project connectivity
MSTR OLAP Services
43. ID columns - Description columns - Fact columns
Locking and Resizing
The System
Report Prompts
3 column types of a Physical Schema
44. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Desktop Designer
Desktop Administrative Functions
Data warehouse characteristics
Long-term (2 - 5 years)
45. Folder List - Object Viewer - Shortcut Bar
Source system characteristics
Filter Definition Prompts
4 parts of the Project Design Process
3 Sections of the MSTR Desktop interface
46. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Tasks when defining a User Hierarchy
Using a Search Object
Outline Mode
Report Formatting
47. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of a MSTR architecture
2 methods to creating Facts
Column Aliases
2 types of Attribute Relationships
48. Columns - Tables
Metrics
New SQL
2 components of a Physical Schema
Source system characteristics
49. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Cannot create project objects
Schema
4 properties you must know in order to create attributes using the Attribute Editor
Limitations of the Attribute Creation Wizard
50. Creating multiple attributes quickly. Used during the initial project creation.
4 factors to consider when designing a data-warehouse schema
Required on the report for Outline Model to work
Attribute Creation Wizard good for
3 Methods of MSTR Desktop navigation
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