Test your basic knowledge |

Certified Project Designer Cpd

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. Columns - Tables
2 types of Attribute Relationships
Gigabytes (GB)
2 components of a Physical Schema
New SQL

2. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Desktop Administrative Functions
MSTR Connectivity Wizard
To create the Project connectivity
Attribute or its relationship(s)

3. Level of OLTP integration
4 factors to consider when designing a data-warehouse schema
3-Tier Architecture
Attribute Relationships
Minimal or none

4. To see data at completely different levels - other than that of the original Grid or Graph
Characteristics of a Simple Table Key
Drilling
Physical Schema
Data Pivoting

5. 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
Sorting
By default
3 Methods of MSTR Desktop navigation
Logical Data Model

6. Tables - Facts - Attributes - Hierarchies
Report Filter
OLTP
3 column types of a Physical Schema
4 basic Schema objects

7. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Rollback your changes
Simple Metrics
3 Schema types
Project Creation Wizard

8. User reporting requirements - Query performance - Data volume - DB Maintenance
Data Pivoting
4 factors to consider when designing a data-warehouse schema
2 types of Table Keys
The 3 MSTR Tools

9. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Physical Schema
4 basic Schema objects
MSTR Desktop Architect
Schema

10. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
3 functions of Attribute Forms
2 components of a Physical Schema
By default
Lookup Tables

11. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
File types are allowed for exporting a Report
Characteristics of a Compound Table Key
Heterogeneous Fact
Project Source

12. Compound - Homogeneous - Heterogeneous
Object Prompts
Architect Graphical Interface
3 types of Attributes
Report Filter

13. Enables you to select and display subsets of a report as separate pages.
Report Subscription
To "drill down" on a report
Page-by
2 ways you can configure the Project Source to connect to the Metadata database

14. Enables you to select which tables from the data-warehouse to store in the Metadata database
4 types of Metrics
MSTR OLAP Services
Warehouse Catalog
Attribute Creation Wizard good for

15. Metrics aggregate on the lowest-level attribute __________.
To "drill down" on a report
View Filter
By default
Thresholding

16. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
3 components of a Report
2 types of Table Keys
Different methods for creating Page-by fields
Lookup Tables

17. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Reports
2 types of Attribute Relationships
Homogeneous Attribute
Facts

18. Folder List - Object Viewer - Shortcut Bar
3 Sections of the MSTR Desktop interface
2 types of Table Keys
Value Prompts
File types are allowed for exporting a Report

19. Facts associated to different column names in 2 or more tables
Using a Search Object
Heterogeneous Fact
3 components of a Report
Desktop Administrative Functions

20. Prompts to select a single value on which to qualify a date - number or text string.
Value Prompts
ID form
Warehouse Catalog
User Hierarchies

21. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Compound Metric
Hierarchies
To save a Report Format
2 options for Sorting

22. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Desktop Designer
Project-level options/settings
Types of drilling
OLAP

23. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Sorting
Report Objects
Reports
Highest-level attributes

24. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
Project
Fact Tables
File types are allowed for exporting a Report

25. The unique values of an attribute obtained from the data-warehouse
2 components of a Physical Schema
Value Prompts
Components of a Derived Metric
Attribute Elements

26. Descriptive data that provides context for Facts.
Report Filter operators
Attribute Forms
4 parts of the Project Design Process
Reports

27. It contains links to specific folders in the Folder List
Nested Metrics
Report Objects
Shortcut Bar
Simple Metrics

28. To define the level of aggregation for a specific metric - Used for qualifications
Derived Attribute Expression
Desktop Architec
Object Prompts
Attributes

29. OLAP Services does not add any ______ to the report query.
Data Pivoting
New SQL
File types are allowed for exporting a Report
To "drill down" on a report

30. OLTP data storage measure
Minimal or none
Gigabytes (GB)
2 components of a Physical Schema
3 Schema types

31. Specifies a condition data must meet in order to be included in a report
4 tasks of the Attribute Creation Wizard
Desktop Designer
Factors to consider when designing a logical data model
Report Filter

32. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Drilling
Architect Graphical Interface
Cannot create project objects
Object Prompts

33. 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

34. A new tool for project design tasks - used for fine-tuning a project after initial creation
Architect Graphical Interface
Filter Definition Prompts
Characteristics of a Simple Table Key
Attribute Forms

35. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
Shortcut in MSTR Desktop
To create the Project connectivity
Lookup Tables

36. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Lookup Table structure of a completely normalized schema
Fact Tables
2 types of Table Keys
Hierarchies

37. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Report Filter
3-Tier Architecture
Stored
Thresholding

38. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
Schema
Banding
The System
Default Project folder structure

39. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Display views you can Print by
Column Aliases
2 ways you can configure the Project Source to connect to the Metadata database
Report Subscription

40. All Attributes must have an _______.
ID form
By default
Limitations of the Attribute Creation Wizard
Display views you can Print by

41. Facts - Attributes - Hierarchies
Cannot create project objects
3 Types of Objects in MSTR Desktop
Fact Tables
Components of the Logical Data Model

42. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
4 properties you must know in order to create attributes using the Attribute Editor
Attribute Relationships
File > Email Reports As
Characteristics of Nested Metrics

43. 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.
Desktop Architec
User Hierarchies
File types are allowed for exporting a Report
Attributes

44. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Short-term (2 - 6 months)
Components of a MSTR architecture
3 project creation interfaces
Project

45. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Relationship Tables
Objects you are allowed to Page-by
Limitations of the Attribute Creation Wizard
Types of analysis you can perform with OLAP Services

46. Attribute Creation Wizard - Attribute Editor
Report Editor
Methods are there to creating Attributes
Homogeneous Fact
Attributes

47. Facts associated to the same column name in 1 or more tables
2-Tier Architecture
Components of a Derived Metric
To create the Project connectivity
Homogeneous Fact

48. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
2 types of Attribute Relationships
4 properties you must know in order to create attributes using the Attribute Editor
Aggregate a Metric
Sample Metrics commonly performed on Facts

49. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Schema
Search Object
ID form
Reports

50. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Attribute Forms
Configuration Wizard
File types are allowed for exporting a Report
Compound Attribute