An analyst selects only sales data for the region "West Java" and the product "Beverages". This is an example of...

What is the primary definition of a Data Warehouse?

Transaction data from various branches is uploaded to the data warehouse every night. This process is part of the stage…

When a customer changes address, the system keeps the old version and the new version in two separate rows. There are “Start Date” and “End Date” columns to track the active period. This is an example of…

In a school’s analytics system, the fact table “Student Grades” is connected to the dimensions “Student”, “Subject”, and “Teacher”. The “Subject” dimension has subdimensions “Subject Group” and “Field of Study” in separate tables. This reflects the schema…

If a dimension table has sub-dimensions or hierarchical relationships, the schema used is...

A company stores the current version information in the main row and keeps all historical data in a separate history table. This is the method...

A manufacturing company builds a data warehouse schema that displays hierarchical relationships in the location dimension, where City is linked to Province and Country as sub-dimensions in separate table structures. Such a schema indicates characteristics of...

A university manages two fact tables: "Student Enrollment" and "Tuition Payment". Both tables are linked to the same dimension tables, such as Student, Study Program, and Semester. Which schema model is most suitable for this situation?

During the ETL process, the same transaction data appears twice due to input errors. The required transformation technique is...

In an OLAP report, a user chooses to view only data from the year 2024. This operation is called...

An analyst wants to filter data only for January 2025 across all regions and all products. The operation performed is...

In a Star Schema, dimension tables are typically...

A financial system only records the latest account status without keeping previous versions. This is classified as…

A retail company builds several data marts separately for the sales, finance, and logistics divisions. Each is developed by different teams without coordination and they are not connected to each other. What architecture are they using?

Which of the following schemas usually requires more JOIN operations due to complex dimension structures?

A fact table "Daily Sales" at a retail company is directly connected to the dimensions "Product," "Time," and "Store." All dimensions consist of a single table without subdimensions. This approach describes…

The main characteristics of a Data Warehouse are, except

What happens when data from various operational systems enters the Data Warehouse and becomes integrated

Non-volatile in the context of Data Warehouse means...

An analyst selects only sales data for the region "West Java" and the product "Beverages". This is an example of...

What is the primary definition of a Data Warehouse?

Transaction data from various branches is uploaded to the data warehouse every night. This process is part of the stage...

When a customer changes address, the system stores the old and new versions in two separate rows. There are “Start Date” and “End Date” columns to track the active period. This is an example of...

In a school analytics system, the fact table “Student Grades” is connected to the dimensions “Student,” “Subject,” and “Teacher.” The “Subject” dimension has subdimensions “Subject Group” and “Field of Study” in separate tables. This reflects the schema...

If a dimension table has sub-dimensions or hierarchical relationships, the appropriate schema is

A company stores the current version of information in the main row and keeps all historical data in a separate history table. This method is

A manufacturing company designs a data warehouse schema showing hierarchical relationships in the location dimension, where City connects to Province and Country as subdimensions in separate tables. This schema is characteristic of

A university manages two fact tables: Student Enrollment and Tuition Payment. Both fact tables link to the same dimension tables, such as Student, Program, and Semester. The most suitable schema model for this situation is

During ETL, the same transaction data appears twice due to an input error. The required transformation technique is...

In an OLAP report, a user chooses to view only data from the year 2024. This operation is called...

An analyst wants to filter data only for January 2025 across all regions and products. The operation performed is...

In a Star Schema, dimension tables are typically...

A finance system only records the latest account status without storing previous versions. This is classified as...

A retail company builds several data marts separately for sales, finance, and logistics. Each is developed by different teams without coordination and they are not interconnected. Which architecture are they using?

Which of the following schemas typically requires more JOIN operations due to complex dimension structures?

A "Daily Sales" fact table in a retail company connects directly to the dimensions "Product", "Time", and "Store". Each dimension consists of a single table without subdimensions. This approach describes...

Which of the following is NOT a primary characteristic of a Data Warehouse?

When data from various operational systems enters the Data Warehouse and becomes integrated, what happens to the data?

Regression is a widely used statistical analysis technique. One of the benefits of regression is

A diagram that maps hierarchical data using nested shapes (typically rectangles), displaying the hierarchy as a set of layered rectangles, is called

Main purpose of data visualization is

The type of chart suitable for visualizing words that are frequently discussed in a social media conversation topic is

In a medical dataset of laboratory examination results, numeric values must be recorded to an appropriate number of decimal places for accurate interpretation of test outcomes. The data readiness characteristic in which data values are defined at a detailed level for the intended use is called

Consider variables such as age, number of children, total household income (in Rupiah), travel speed (in Km/hour), and temperature (in degrees Celsius). The taxonomy of these data is called

The mathematical method used to estimate or describe the degree of variation in a variable is called. Select one.

Measurement variables commonly found in physics and engineering—such as mass, length, time, plane angle, energy, and electric charge—are examples of the data taxonomy called. Select one.

Select one. Measurement of dispersion is a mathematical method used to estimate or describe the level of variation in a particular variable of interest and represents the numerical spread of a given dataset. The following is not a measure of dispersion:

Select one. The representation of data that is changed into groups without considering the order among the groups, for example "marital status," in data taxonomy is called:

Reducing the range of data in each numeric variable to a standard range using normalization or scaling is the process. Select one.

Hypothesis testing is an example of implementation of. Select one.

Scaling values to the range 0–1 in data transformation is known as. Select one.

Select one: Business reports can be produced in the following formats, except

Select one: A Metric Management Report that presents an integrated view of organizational success covering financial, customer, business process, and learning-and-growth perspectives is called

Select one: Sales data in a supermarket are presented as an example above. Data like that are called

Select one: Celsius temperature is an example of …

Select one: Which is an example of ordinal data?

Select one: Raw Data Source → (1) Data Transformation → (2) Data Cleaning → (3) Data Reduction → (4) Data Consolidation → Well Formed Data. The correct order of Data Preprocessing steps is …

Select one: PT XYZ wants to monitor the relationship between total product sales and the costs incurred for product advertising. Based on this case, the most appropriate type of chart to use is

Select one: In linear regression, the dispersion of errors from predicted values must be consistent; this assumption is known as

Select one: A person’s marital status is an example of

Statistical methods in business reports can be categorized into. Select one.

Stunting diagnosis in children can be performed through physical examinations, such as measuring body weight, height, and head circumference. The taxonomy of data obtained in that diagnosis is called … Select one.

In linear regression assumptions, the assumption stating that the errors of the response variable are not correlated with each other is the assumption of. Select one.

The head of the community health center wants to compare the number of toddlers with stunting across 5 Posyandu to identify which has the fewest to the most cases. The most appropriate chart for this visualization is

The term used to analyze, characterize, and summarize structured data stored in an organization’s database using cubes is

Which of the following is not a key to successful reporting?

If imbalanced data are found, which data reduction process should be performed?

One characteristic of data readiness for an analytic study is that every element of the data is available in the dataset; this is called

Select one. Simple, unorganized and unprocessed facts are characteristics of

Select one. The processes included in data preprocessing are

Select one. Reducing the range of existing data to a standard range (0–1) in data preprocessing is called

Select one: Yes/No and True/False belong to which type of data?

Select one: A district head claims that the poverty rate in his region is very low. To verify this, a survey of household income and expenditure is conducted, which theoretically can yield the poverty rate. Considering time and cost, a sample of 10,000 households is chosen from a total population of 100,000 households. The suitable statistical modeling for this case is

Select one: The appropriate diagram to illustrate comparison of continuous values across two categories using color, so users can quickly see where category intersections are strongest and weakest based on numeric measurements, is —

Select one: Which activities are part of the data cleaning process?

Select one. Data based on context refers to data suitable within a specific domain, and subject refers to data arranged according to the relevant subject. This data readiness characteristic is called

Select one. Which of the following are statistical measures that describe the dispersion of data?

A measurement scale used to determine the ranking of a particular group. In this ranking, only the order of objects is considered from the largest to the smallest or from the highest to the lowest. For example, students’ knowledge about Covid-19 (1 = poor, 2 = adequate, 3 = good). The data taxonomy for such an example is called

In the Kimball approach, the commonly used data structure is