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. Simple - Derived
2 types of Fact Expressions
2 types of Attribute Expression
Limitations of the Attribute Creation Wizard
Project-level options/settings
2. 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
3 Methods of MSTR Desktop navigation
To save a Report Format
Schema
3. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Desktop Architec
To qualify a Metric in a Set Qualification
Report Prompts
Lookup Tables
4. A user interface for creating and maintaining a BI environment
Characteristics of Nested Metrics
MSTR Desktop
4 parts of the Project Design Process
Characteristics of a Compound Table Key
5. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Project Source
Banding
3 column types of a Physical Schema
Report Objects
6. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
File types are allowed for exporting a Report
Sample Metrics commonly performed on Facts
Lookup Tables
Very high; part of ETL process
7. Used for - Initially populating the Metadata - Creating schema objects
Report Prompts
MSTR Desktop Architect
Facts
Short-term (2 - 6 months)
8. OLAP retains data ________
Long-term (2 - 5 years)
Fact Expression
Notes
Highest-level attributes
9. The Attribute Form maps to different column names in multiple tables
Report Definitions
Heterogeneous Attribute
To save a Report Format
Types of drilling
10. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Derived Attribute Expression
Attributes
Data warehouse characteristics
4 tasks of the Attribute Creation Wizard
11. Grid View - Graph View - Grid/Graph View - SQL View
Data Pivoting
Display views you can Print by
2 types of Fact Expressions
Components of Compound Metrics
12. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
3 project creation interfaces
Factors to consider when designing a logical data model
Unlimited
Objects you are allowed to Page-by
13. The Attribute Form maps to the same column name in multiple tables
By default
4 types of Prompts
Components of a Metric
Homogeneous Attribute
14. It contains the ID and DESC columns of all higher-level attributes
To create a Report Prompt
Lookup Table structure of a completely denormalized schema
Simple Metrics
3 Schema types
15. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h
Default Project folder structure
The System
4 types of Metrics
Report Subscription
16. Used to limit a possibly overwhelming set of potential prompt answers
Search-based prompts
Drilling
Locking and Resizing
Report Prompts
17. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Desktop Administrative Functions
Report Editor
3 components of a Report
MSTR Connectivity Wizard
18. 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
19. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Level Prompts
Long-term (2 - 5 years)
Physical Schema
Cannot create project objects
20. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Components of a Derived Metric
Cannot create project objects
The System
Attribute Creation Wizard good for
21. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
2 ways you can configure the Project Source to connect to the Metadata database
2 types of Attribute Relationships
Thresholding
Project
22. Enables you to lock column headers so that they always appear when scrolling
Objects you are allowed to Page-by
Components of the Logical Data Model
Locking and Resizing
MSTR applications
23. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Types of drilling
Facts
Heterogeneous Fact
Schema Object Editor
24. Allow you to interact with the BI system - logically organize data to analyze complex relationships
MSTR applications
Physical Schema
2 types of Attribute Expression
Application Objects
25. User reporting requirements - Query performance - Data volume - DB Maintenance
Report Filter
5 steps to creating a logical data model
OLAP
4 factors to consider when designing a data-warehouse schema
26. Facts associated to different column names in 2 or more tables
Stored
Heterogeneous Fact
Homogeneous Fact
View Filters
27. What tool do you use to create the Metadata shell?
Sample Metrics commonly performed on Facts
Methods are there to creating Attributes
Configuration Wizard
5 Report display views
28. 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.
4 tasks of the Attribute Creation Wizard
Report Prompts
Attribute Relationships
Nested Metrics
29. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Using a Search Object
To save a Report Format
User Hierarchies
Facts
30. A development environment to create BI applications - allowing users to edit the Metadata database
Characteristics of a Simple Table Key
'View of a Report'
3 Schema types
Desktop Architec
31. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
To create the Project connectivity
Nested Metrics
Objects you are allowed to Page-by
32. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
The 3 MSTR Tools
Filter Definition Prompts
Facts
User Hierarchies
33. Simple - Compound - Nested - Derived
Locking and Resizing
Schema Objects
Drilling
4 types of Metrics
34. Primary keys
Table Keys
Characteristics of a Simple Table Key
OLTP
Compound Metric
35. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
5 steps to creating a logical data model
Gigabytes (GB)
4 tasks of the Attribute Creation Wizard
2-Tier Architecture
36. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Sample Metrics commonly performed on Facts
Heterogeneous Fact
Report Objects
To save a Report Format
37. You can _____________ in the Architect Graphical Interface.
Aggregate a Metric
Report Subscription
Rollback your changes
Logical Data Model
38. Extraction - transformation - loading
3 components of a Report
Methods are there to creating Attributes
4 factors to consider when designing a data-warehouse schema
ETL
39. To define the level of aggregation for a specific metric - Used for qualifications
Banding
Minimal or none
Unlimited
Attributes
40. The default entry-points.
Outline Mode
4 factors to consider when designing a data-warehouse schema
Sample Metrics commonly performed on Facts
Highest-level attributes
41. Homogeneous - Heterogeneous
Desktop Designer
2 types of Facts
Components of a MSTR architecture
Lookup Tables
42. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
3-Tier Architecture
Data Pivoting
Rollback your changes
Simple Metrics
43. A condition data must meet in order to be included in a report. Does affect the SQL.
2-Tier Architecture
Report Filter
Architect Graphical Interface
Physical Schema
44. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
New SQL
ID form
Outline Mode
Process for creating the Project Metadata
45. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Components of the Logical Data Model
3 Methods of MSTR Desktop navigation
To "drill down" on a report
MSTR OLAP Services
46. To see data at completely different levels - other than that of the original Grid or Graph
Drilling
Report Prompts
To edit the appearance of a Graph in a report
Lookup Table structure of a moderately denormalized schema
47. Tables - Facts - Attributes - Hierarchies
4 basic Schema objects
Project Creation Wizard
Characteristics of Nested Metrics
2 methods to creating Facts
48. User requirements - Existing source data - Technical and performance considerations
Factors to consider when designing a logical data model
Process for creating the Project Metadata
To create the Project connectivity
Cannot create project objects
49. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
2 types of Facts
'View of a Report'
Aggregate a Metric
Attribute Elements
50. 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
Derived Attribute Expression
4 types of Prompts
Project Creation Wizard
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