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. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
ETL process
Column Aliases
Unlimited
MSTR OLAP Services
2. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Aggregate a Metric
Factors to consider when designing a logical data model
To create a Report Prompt
To "drill down" on a report
3. Enables you to format report values based on a condition - such as highlights - font colors - etc.
2 ways you can configure the Project Source to connect to the Metadata database
Required on the report for Outline Model to work
Thresholding
Schema
4. Subtotals reflect accumulations at selected attribute levels
3 functions of Attribute Forms
Desktop Analyst
Filter Definition Prompts
Subtotals
5. User requirements - Existing source data - Technical and performance considerations
Project Creation Wizard
Column Aliases
4 tasks of the Attribute Creation Wizard
Factors to consider when designing a logical data model
6. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
2 components of a Physical Schema
Components of Compound Metrics
3 project creation interfaces
To save a Report Format
7. Simple - Compound - Nested - Derived
Page-by
ETL
Shortcut Bar
4 types of Metrics
8. OLTP retains data ________
Default Project folder structure
View Filters
Short-term (2 - 6 months)
Derived Metrics
9. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Data Pivoting
Reference Report Objects
3-Tier Architecture
Project Creation Wizard
10. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Report Subscription
Column Aliases
Report Filter
Highest-level attributes
11. View Filters can only ___________.
4 types of Metrics
Fact Expression
Reference Report Objects
Compound Metric
12. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
View Filters
Schema
Level Prompts
2 types of Facts
13. How users can share comments for reports to other users
To "drill down" on a report
Notes
3 Sections of the MSTR Desktop interface
Attribute Elements
14. One that uses 2 or more columns as its ID
Compound Attribute
Default Project folder structure
Page-by
Report Template
15. Primary keys
To edit the appearance of a Graph in a report
Table Keys
Heterogeneous Attribute
Thresholding
16. Must have a one-to-one relationship with all other forms.
Project Source
Attribute Forms
Level Prompts
New SQL
17. Filter definition prompts - Object prompts - Value prompts - Level prompts
Homogeneous Attribute
OLAP
Logical Data Model
4 types of Prompts
18. Less storage - Simple SQL - Complex ETL
Using a Search Object
Characteristics of a Simple Table Key
4 types of Prompts
Report Filter
19. OLTP data storage measure
Characteristics of a Compound Table Key
Using a Search Object
Gigabytes (GB)
Lookup Tables
20. Top menu/dropdowns - Toolbar - Right-click popup menus
3 Methods of MSTR Desktop navigation
2 options for Sorting
Rollback your changes
Simple Metrics
21. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
2 methods to creating Facts
Project-level options/settings
File types are allowed for exporting a Report
Compound Attribute
22. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Data Pivoting
Source system characteristics
Objects you are allowed to Page-by
File types are allowed for exporting a Report
23. The unique values of an attribute obtained from the data-warehouse
To "drill down" on a report
Architect Graphical Interface
Heterogeneous Fact
Attribute Elements
24. More storage - Complex SQL - Simple ETL
Attribute Forms
2 types of Attribute Expression
Characteristics of a Compound Table Key
4 tasks of the Attribute Creation Wizard
25. Metrics that perform multiple aggregations; one calculation inside of another.
Nested Metrics
Using a Search Object
Desktop Analyst
Short-term (2 - 6 months)
26. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Drilling
Reports
Filter Definition Prompts
Homogeneous Attribute
27. It contains the ID column of all higher-level attributes
Stored
Lookup Table structure of a moderately denormalized schema
Process for creating the Project Metadata
Shortcut in MSTR Desktop
28. It contains the ID and DESC columns of all higher-level attributes
Column Aliases
Tasks when defining a User Hierarchy
MSTR Desktop
Lookup Table structure of a completely denormalized schema
29. 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
Simple Metrics
Sorting
MSTR OLAP Services
Attribute Creation Wizard good for
30. Homogeneous - Heterogeneous
Desktop Administrative Functions
Aggregate a Metric
2-Tier Architecture
2 types of Facts
31. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop
4 types of Prompts
MSTR Desktop Architect
Stored
32. Facts - Attributes - Hierarchies
File > Email Reports As
Hierarchies
OLAP
Components of the Logical Data Model
33. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
The 3 MSTR Tools
Facts
Attribute Elements
Components of Compound Metrics
34. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Components of the Logical Data Model
Characteristics of a Simple Table Key
Components of a Metric
35. Creating multiple attributes quickly. Used during the initial project creation.
Project-level options/settings
MSTR Desktop
3 functions of Attribute Forms
Attribute Creation Wizard good for
36. Columns - Tables
Facts
OLTP
Fact Tables
2 components of a Physical Schema
37. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Lookup Tables
Using a Search Object
3 Sections of the MSTR Desktop interface
Filter Definition Prompts
38. 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
Physical Schema
Lookup Tables
3 types of Attributes
3 Schema types
39. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Attribute Relationships
Report Objects
5 Report display views
File > Email Reports As
40. View Filters are saved with the _____________.
Report Objects
To create the Project connectivity
Report Definitions
2 options for Sorting
41. Enables you to lock column headers so that they always appear when scrolling
Object Prompts
Banding
Locking and Resizing
Using a Search Object
42. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Attribute Forms
ETL
OLAP
Reference Report Objects
43. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Attribute Elements
Schema
2 ways you can configure the Project Source to connect to the Metadata database
ID form
44. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Report Editor
Desktop Analyst
To create a Report Prompt
OLAP
45. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations
MSTR applications
Highest-level attributes
Process for creating the Project Metadata
Characteristics of Nested Metrics
46. A condition data must meet in order to be included in a report. Does affect the SQL.
Types of analysis you can perform with OLAP Services
Report Filter
3 types of Attributes
Schema Objects
47. 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
Report Subscription
Report Filter operators
Subtotals
48. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Notes
Table Keys
Desktop Designer
Lookup Tables
49. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Components of Compound Metrics
Metrics
Sorting
Filter Definition Prompts
50. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Components of the Logical Data Model
Different methods for creating Page-by fields
2 methods to creating Facts
Application Objects
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