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. Extraction - transformation - loading
ETL
Report Editor
Components of the Logical Data Model
'View of a Report'
2. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Report Objects
Highest-level attributes
Derived Attribute Expression
ETL process
3. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a moderately denormalized schema
Search-based prompts
Characteristics of Nested Metrics
Lookup Table structure of a completely denormalized schema
4. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Cannot create project objects
Fact Tables
2 components of a Physical Schema
Outline Mode
5. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2 types of Attribute Expression
Homogeneous Attribute
2 options for Sorting
Desktop Administrative Functions
6. Used for - Initially populating the Metadata - Creating schema objects
Warehouse Catalog
Components of the Logical Data Model
Lookup Table structure of a completely normalized schema
MSTR Desktop Architect
7. You must select "Other directions" when drilling attributes while viewing a report
Objects you are allowed to Page-by
To drill through User Hierarchies
Heterogeneous Fact
Column Aliases
8. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
Tasks when defining a User Hierarchy
Page-by
Characteristics of a Simple Table Key
9. Enables you to select and display subsets of a report as separate pages.
The 3 MSTR Tools
Page-by
Architect Graphical Interface
Sample Metrics commonly performed on Facts
10. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
Notes
2 types of Fact Expressions
MSTR Desktop Architect
Very high; part of ETL process
11. Enables you to rearrange the columns and rows in a report.
Unlimited
Data Pivoting
Derived Attribute Expression
Lookup Table structure of a completely denormalized schema
12. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Factors to consider when designing a logical data model
Facts
Desktop Architec
Application Objects
13. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Report Filter
Types of drilling
Desktop Designer
Methods are there to creating Attributes
14. More storage - Complex SQL - Simple ETL
Characteristics of a Compound Table Key
Schema Objects
Level Prompts
4 tasks of the Attribute Creation Wizard
15. Must have Subtotals enabled - or you won't see any data for higher-level attributes
3 functions of Attribute Forms
Required on the report for Outline Model to work
4 properties you must know in order to create attributes using the Attribute Editor
Table Keys
16. Simple - Compound - Nested - Derived
4 types of Metrics
4 factors to consider when designing a data-warehouse schema
Heterogeneous Fact
2 types of Fact Expressions
17. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Display views you can Print by
Hierarchies
3 project creation interfaces
Types of analysis you can perform with OLAP Services
18. Homogeneous - Heterogeneous
Components of a Metric
Compound Attribute
2 types of Facts
Shortcut Bar
19. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Value Prompts
3 Sections of the MSTR Desktop interface
3-Tier Architecture
Project Source
20. It contains links to specific folders in the Folder List
Derived Metrics
Shortcut Bar
Cannot create project objects
Factors to consider when designing a logical data model
21. Create the Project Source - Create the Database Instance
Tasks when defining a User Hierarchy
4 tasks of the Attribute Creation Wizard
Level Prompts
To create the Project connectivity
22. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Limitations of the Attribute Creation Wizard
Simple Metrics
Components of a Derived Metric
Application Objects
23. What tool do you use to create the Metadata DSN connection?
Required on the report for Outline Model to work
Report Definitions
3-Tier Architecture
MSTR Connectivity Wizard
24. An environment in which the MSTR Desktop connects directly to the Metadata database.
Nested Metrics
Cannot create project objects
ETL
2-Tier Architecture
25. Grid View - Graph View - Grid/Graph View - SQL View
Display views you can Print by
Types of drilling
Terabytes (TB)
Attribute Forms
26. Metrics that perform multiple aggregations; one calculation inside of another.
Attribute or its relationship(s)
Nested Metrics
Configuration Wizard
Attribute Forms
27. User reporting requirements - Query performance - Data volume - DB Maintenance
4 factors to consider when designing a data-warehouse schema
Characteristics of a Compound Table Key
Report Template
To qualify a Metric in a Set Qualification
28. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Different methods for creating Page-by fields
2 types of Attribute Expression
Components of Compound Metrics
Characteristics of a Compound Table Key
29. It contains the ID column of the parent attribute
Shortcut in MSTR Desktop
Lookup Tables
Lookup Table structure of a completely normalized schema
Fact Tables
30. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Project
MSTR Connectivity Wizard
Components of a Metric
Unlimited
31. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy
Default Project folder structure
Types of drilling
Report Filter operators
Lookup Table structure of a completely denormalized schema
32. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
4 properties you must know in order to create attributes using the Attribute Editor
Search Object
Lookup Table structure of a moderately denormalized schema
2 types of Table Keys
33. Less storage - Simple SQL - Complex ETL
2 types of Attribute Expression
New SQL
Characteristics of a Simple Table Key
Lookup Table structure of a moderately denormalized schema
34. Groupings of directly related attributes. Also commonly known as "dimensions".
Hierarchies
Warehouse Catalog
Locking and Resizing
Stored
35. Must have a one-to-one relationship with all other forms.
4 properties you must know in order to create attributes using the Attribute Editor
Attribute Forms
2 types of Attribute Expression
Attribute or its relationship(s)
36. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Different methods for creating Page-by fields
Very high; part of ETL process
Unlimited
Desktop Architec
37. OLTP data storage measure
Gigabytes (GB)
Components of the Logical Data Model
Search Object
3 Sections of the MSTR Desktop interface
38. 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
39. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Relationship Tables
Different methods for creating Page-by fields
Components of a MSTR architecture
Long-term (2 - 5 years)
40. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
MSTR OLAP Services
Types of analysis you can perform with OLAP Services
Shortcut in MSTR Desktop
The 3 MSTR Tools
41. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
OLAP
Metrics
Architect Graphical Interface
Configuration Wizard
42. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Cannot create project objects
Components of a Derived Metric
Data warehouse characteristics
MSTR Desktop Architect
43. Used to "fine-tune" your Project
Report Definitions
Architect Graphical Interface
Desktop Designer
Minimal or none
44. User requirements - Existing source data - Technical and performance considerations
To drill through User Hierarchies
3 project creation interfaces
Object Prompts
Factors to consider when designing a logical data model
45. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
To save a Report Format
View Filter
Value Prompts
Desktop Administrative Functions
46. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Desktop Architec
The 3 MSTR Tools
Objects you are allowed to Page-by
Components of Compound Metrics
47. 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
Drilling
3 functions of Attribute Forms
2 ways you can configure the Project Source to connect to the Metadata database
Relationship Tables
48. Metrics aggregate on the lowest-level attribute __________.
By default
Reports
Locking and Resizing
Heterogeneous Fact
49. Reduced number of JOINS in the generated SQL
Advantage of a completely denormalized schema
3 types of Attributes
Compound Metric
Schema Object Editor
50. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Lookup Table structure of a moderately denormalized schema
File types are allowed for exporting a Report
To edit the appearance of a Graph in a report
Metrics
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