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. Prompts to select a single value on which to qualify a date - number or text string.
Value Prompts
MSTR Desktop
Stored
Limitations of the Attribute Creation Wizard
2. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
To "drill down" on a report
Display views you can Print by
Outline Mode
Types of analysis you can perform with OLAP Services
3. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Project Creation Wizard
Process for creating the Project Metadata
Desktop Analyst
Minimal or none
4. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Report Filter operators
ETL process
Unlimited
Object Prompts
5. All report-level options overwrite ___________.
Report Definitions
Different methods for creating Page-by fields
Project-level options/settings
Components of a MSTR architecture
6. Descriptive data that provides context for Facts.
Attribute Forms
Report Filter
Logical Data Model
Display views you can Print by
7. You can e-mail reports by going to _____
Value Prompts
File > Email Reports As
3-Tier Architecture
Sorting
8. 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
Components of a MSTR architecture
Tasks when defining a User Hierarchy
Gigabytes (GB)
Attribute Creation Wizard good for
9. User reporting requirements - Query performance - Data volume - DB Maintenance
Warehouse Catalog
ETL
4 factors to consider when designing a data-warehouse schema
Factors to consider when designing a logical data model
10. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Objects you are allowed to Page-by
View Filter
Object Prompts
Compound Metric
11. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Short-term (2 - 6 months)
Report Filter operators
To edit the appearance of a Graph in a report
To create a Report Prompt
12. Must have Subtotals enabled - or you won't see any data for higher-level attributes
2-Tier Architecture
3 project creation interfaces
Required on the report for Outline Model to work
2 types of Attribute Expression
13. OLTP data storage measure
2 types of Table Keys
Highest-level attributes
Gigabytes (GB)
Facts
14. What tool do you use to create the Metadata DSN connection?
Physical Schema
Hierarchies
MSTR Connectivity Wizard
Subtotals
15. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
2 methods to creating Facts
View Filter
The 3 MSTR Tools
Page-by
16. OLAP Services does not add any ______ to the report query.
New SQL
Report Template
Report Filter
Types of drilling
17. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Search Object
3 project creation interfaces
3 Types of Objects in MSTR Desktop
Report Editor
18. View Filters are saved with the _____________.
3 types of Attributes
Report Definitions
2 ways you can configure the Project Source to connect to the Metadata database
Desktop Architec
19. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Cannot create project objects
Lookup Tables
Project Creation Wizard
4 basic Schema objects
20. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Display views you can Print by
3-Tier Architecture
Unlimited
Data Pivoting
21. Facts associated to different column names in 2 or more tables
Notes
Advantage of a completely denormalized schema
Heterogeneous Fact
Lookup Table structure of a moderately denormalized schema
22. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Column Aliases
Components of a MSTR architecture
4 types of Metrics
Filter Definition Prompts
23. All Attributes must have an _______.
OLAP
ID form
4 factors to consider when designing a data-warehouse schema
Data warehouse characteristics
24. Level of OLAP integration
Attribute Forms
Very high; part of ETL process
MSTR Desktop
Report Formatting
25. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Reports
OLAP
Compound Attribute
Simple Attribute Expression
26. Top menu/dropdowns - Toolbar - Right-click popup menus
Fact Expression
4 factors to consider when designing a data-warehouse schema
Drilling
3 Methods of MSTR Desktop navigation
27. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
2 options for Sorting
Required on the report for Outline Model to work
Attribute Forms
28. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
2 options for Sorting
Short-term (2 - 6 months)
3 column types of a Physical Schema
The System
29. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Derived Attribute Expression
Different methods for creating Page-by fields
Rollback your changes
Thresholding
30. Specifies a condition data must meet in order to be included in a report
MSTR Connectivity Wizard
Desktop Designer
Report Filter
Notes
31. 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
3 Schema types
3 project creation interfaces
Fact Tables
Very high; part of ETL process
32. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Project Source
Different methods for creating Page-by fields
3 Types of Objects in MSTR Desktop
Desktop Designer
33. The default entry-points.
Types of analysis you can perform with OLAP Services
File > Email Reports As
To save a Report Format
Highest-level attributes
34. Template - Filter - View of a Report
Tasks when defining a User Hierarchy
Objects you are allowed to Page-by
3 components of a Report
Project Source
35. It contains the ID column of all higher-level attributes
3 Schema types
View Filter
Lookup Table structure of a moderately denormalized schema
2 types of Attribute Expression
36. Enables you to select and display subsets of a report as separate pages.
Page-by
To create a Report Prompt
View Filters
Report Editor
37. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
5 steps to creating a logical data model
3 components of a Report
OLAP
New SQL
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. Compound - Homogeneous - Heterogeneous
Homogeneous Fact
Short-term (2 - 6 months)
3 types of Attributes
Attribute Forms
40. A user interface for creating and maintaining a BI environment
Different methods for creating Page-by fields
To "drill down" on a report
3 Methods of MSTR Desktop navigation
MSTR Desktop
41. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Sample Metrics commonly performed on Facts
Relationship Tables
Table Keys
Attribute Elements
42. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Schema
4 factors to consider when designing a data-warehouse schema
Physical Schema
Report Editor
43. The actual column name for a fact. Every fact must have at least 1 expression.
2 methods to creating Facts
Level Prompts
Highest-level attributes
Fact Expression
44. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Components of Compound Metrics
View Filter
Outline Mode
Level Prompts
45. It contains links to specific folders in the Folder List
Report Subscription
2 types of Facts
Shortcut Bar
Column Aliases
46. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Very high; part of ETL process
2 types of Attribute Relationships
MSTR OLAP Services
3 column types of a Physical Schema
47. Metrics you create within a report using only those objects in the report.
Components of Compound Metrics
Project Source
View Filters
Derived Metrics
48. Extraction - transformation - loading
Attributes
5 Report display views
ETL
Terabytes (TB)
49. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Aggregate a Metric
Process for creating the Project Metadata
4 basic Schema objects
Data warehouse characteristics
50. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Search-based prompts
Lookup Tables
Schema Object Editor
4 types of Report Filters
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