FCA-FineBI Latest Version Exam Answers, All in One!!!! -CSDN Blogco-blogger
Part.1: Judgment
Question 1
judgment question
The "TODATE" function or the "DATE" function converts a text field or a numeric field into a time-type field. (Score: 2 out of 2)
Correct Answer: A
Your answer: A
properly
A. Correct
B. Errors
Question 2
judgment question
Row to column converts a one-dimensional table into a two-dimensional table (Score: 2 out of 2)
Correct Answer: A
Your answer: A
properly
A. Correct
B. Errors
Question 3
judgment question
Excel support batch import, can import more than one sheet or Excel at a time?(Score: 2 out of 2)
Correct Answer: A
Your answer: A
properly
A. Correct
B. Errors
Question 4
judgment question
Only three data types, text, numeric, and date, are supported in FineBI data processing modeling. (Score: 0 out of 2)
Correct Answer: A
Your answer: B
incorrect
A. Correct
B. Errors
Question 5
judgment question
When editing data, we can use the "Split Rows and Columns" function to quickly split the string to our needs. (Score: 2 out of 2)
Correct Answer: A
Your answer: A
properly
A. Correct
B. Errors
Question 6
judgment question
Is the statement about dashboard style (in effect) priority correct? -- Individual component styles have a higher priority than global styles (Score: 2 out of 2)
Correct Answer: A
Your answer: A
properly
A. Correct
B. Errors
Question 7
judgment question
Indicators in FineBI that you want to do dimension interval/custom grouping can't be dragged and dropped directly into the component area, they need to be converted to dimensions first before you can group the indicators. (Score: 2 out of 2)
Correct Answer: A
Your answer: A
properly
A. Correct
B. Errors
Question 8
judgment question
When making the most basic pie chart, you only need to put a dimension field in the color column of the graph properties and an indicator field in the angle column. (Score: 2 out of 2)
Correct Answer: A
Your answer: A
properly
A. Correct
B. Errors
Question 9
judgment question
There are four different types of computational operators: arithmetic, comparison, logical, and string splicing. (Score: 2 out of 2)
Correct Answer: A
Your answer: A
properly
A. Correct
B. Errors
Question 10
judgment question
Fast calculation of year-on-year ringgit without filtering of time controls preventing the calculation of year-on-year ringgit for data that is not in the interval (Score: 2 out of 2)
Correct Answer: B
Your answer: B
properly
A. Correct
B. Errors
Question 11
judgment question
Ordinary user A makes a template, and the template he makes wants to be shared out as a public link, then the data permissions of the template shared out are only those of ordinary user A (Score: 2 out of 2)
Correct Answer: A
Your answer: A
properly
A. Correct
B. Errors
Question 12
judgment question
If there is administrative access to the publish directory node and the path is selected for the publish, approval can be waived. (Score: 2 out of 2)
Correct Answer: A
Your answer: A
properly
A. Correct
B. Errors
Part.2: Single-choice questions
Question 13
multiple-choice question
In which FineBI module can a user search for help documentation? (Score: 2 out of 2)
Correct Answer: A
Your answer: A
properly
A. User Center - Growth Center
B. User Center - Operations Center
C. User centers -- service centers
D. User Center - My Home Page
Question 14
multiple-choice question
In order to reduce the production of intermediate tables, FineBI6.0 has added a new function that can realize the effect similar to lookup and sumif functions in Excel. For example, if table A and table B have a merge basis field, you can add a new column in table A. What is this function? (Score: 2 out of 2)
Correct Answer: A
Your answer: A
properly
A. Addition of columns to other tables
B. Left-right consolidation
C. Consolidation
D. New columns
Question 15
multiple-choice question
Which of the following data types is not included in the FineBI product definition? (Score: 2 out of 2)
Correct Answer: A
Your answer: A
properly
A. Characterization
B. Time type
C. Numerical types
D. Text type
Question 16
multiple-choice question
Based on the analysis of the Equipment Production Table, what is the order quantity for production equipment QE-01? (Score: 3 out of 3)
Correct Answer: B
Your answer: B
properly
A. 7858
B. 7107
C. 4820
D. 4590
Question 17
multiple-choice question
Based on the analysis of the Hospitalization Schedule.xlsx, what percentage of the hospitalized population had laboratory tests? (Score: 3 out of 3)
Correct Answer: A
Your answer: A
properly
A. 48.14%
B. 36.32%
C. 51.86%
D. 63.68%
Question 18
multiple-choice question
According to the analysis of the Education_Admissions_Information_Sheet, which year had the highest reporting ratio? (Enrollment ratio = number of admissions/number of applicants) (Score: 3 out of 3)
Correct Answer: C
Your answer: C
properly
A. 2015
B. 2016
C. 2013
D. 2014
Question 19
multiple-choice question
Based on the analysis of the Stores Sales Schedule, which store has the lowest sales? (Score: 3 out of 3)
Correct Answer: B
Your answer: B
properly
A. Anshan Store
B. Lanzhou Department Store
C. Beijing I (department stores)
D. Kunming Store
Question 20
multiple-choice question
Based on the data: (Data Download), analyze: If sales in 2013 are expected to increase by 50% in the following year, what is the expected total sales for the "Consumer" segment in 2014? (Score: 3 out of 3)
Correct Answer: C
Your answer: C
properly
A. $2,752,022
B. $4,278,540
C. $816,999
D. $802,365
Question 21
multiple-choice question
Based on the analysis of the Stores Sales Schedule, what were the expenses of the Changsha store in May 2017? (Expenses = Sales - Gross Profit) (Score: 3 out of 3)
Correct Answer: A
Your answer: A
properly
A. 101235
B. 85489
C. 183191
D. 426106
Question 22
multiple-choice question
Based on the data: (data download), analyze: identify the customer with the lowest total profit. What is the profit ratio for this customer? (Score: 3 out of 3)
Correct Answer: B
Your answer: B
properly
A. 17.54%
B. -771.39%
C. 23.97%
D. 2.36%
Question 23
multiple-choice question
Based on the analysis of the Hospitalization Schedule.xlsx, which age group had the highest number of hospitalizations? (Score: 3 out of 3)
Correct Answer: B
Your answer: B
properly
A. Youth
B. Old age
C. Middle age
D. Early childhood
Question 24
multiple-choice question
Based on the Company's Merchandise Sales Schedule, analyze which city had the highest sales in 2019 (Score: 3 out of 3)
Correct Answer: C
Your answer: C
properly
A. Shanghai
B. Beijing
C. Hangzhou
D. Shenzhen
Question 25
multiple-choice question
Based on the data: (Data Download), analyze: Which product subcategory has a shipping cost to sales ratio higher than 3%? (Score: 0 out of 3)
Correct Answer: C
A. Tables
B. Binders and Binder Accessories
C. Paper
D. Chairs & Chairmats
Question 26
multiple-choice question
If you want the first column of a FineBI table to display as a serial number, how should you set it up? (Score: 0 out of 2)
Correct Answer: B
A. Component Styles > Display Serial Numbers
B. Component Style>Format>Display Serial Numbers
C. Component Format>Display Serial Number
D. Component format>serial number
Question 27
multiple-choice question
What is a correct statement about the area of the indicator to be analyzed? (Score: 0 out of 2)
Correct Answer: C
A. Geographic roles into which the indicator can be translated are the geographic roles longitude, dimension and altitude.
B. Raw indicators cannot be dimensionally transformed
C. Raw dimensions can be converted into indicators
D. Indicator names are generated in the dimension area of the table to be analyzed.
Question 28
multiple-choice question
What is the default chart type after creating a new component? (Score: 0 out of 2)
Correct Answer: A
A. Breakout tables
B. Cross-tabulations
C. Schedules
D. Customized charts
Question 29
multiple-choice question
The following statements about finebi 6.0 features are incorrect? (Score: 0 out of 2)
Correct Answer: D
A. Data interpretation: click on component outliers for automatic analysis
B. Sankey diagram: finebi enables multi-node traffic analysis
C. Box plots: Box plots can be used to analyze data when there is a need to understand the characteristics of the data distribution or when there is a need to see outliers in the data
D. Dashboard TAB clicks can be set to hide all in-theme components, including hiding unused components of the dashboard
Question 30
multiple-choice question
Function Usage: =DATE(2021,01,02) and the result is ? (Score: 0 out of 2)
Correct Answer: A
A. 2021/1/2
B. 2021/2/1
C. 2021/1/1
D. 2021/2/2
Question 31
multiple-choice question
What is a correct description of fast calculations? (Score: 0 out of 2)
Correct Answer: B
A. All values/all values in a group are calculated by summing, averaging, variance, and standard deviation.
B. The four calculation methods of the same period, ring period, year-on-year and ring comparison require that the dimension area must have time-related data.
C. Current Dimension Percentage is the percentage of the current fine-grained data to the difference of all fine-grained data in that dimension.
D. The current indicator percentage is the current granular data as a percentage of the difference in granular data for all dimensions within the indicator.
Question 32
multiple-choice question
The following statement is correct about linkage? (Score: 0 out of 2)
Correct Answer: C
A. For data to be linked between charts, the data must come from the same table.
B. It is not possible to split the linkage between two components that have linked data.
C. If you want to cancel the linkage relationship between all components, you can uncheck the checkbox during linkage setup
D. For two components to be linked, their corresponding two data tables must be related.
Part.3: Multiple Choice Questions
Question 33
multiple-choice question
What are the entrances to the new analysis topic? (Score: 3 out of 3)
Correct Answer: A,B,C
Your answer: A,B,C
properly
A. Select the data you want to analyze in [Public Data], and click the "Create Analysis Topic" button on the top right to rename the name of the analysis topic and select the location where the analysis topic will be placed.
B. Click [+> Analysis Topics] in one of the folders in [My Analysis] to create an analysis topic under that file.
C. Click the large blue [New Analysis Topic] button in [My Analysis].
D. Click the [New Analysis Topic] button directly in [Public Data].
Question 34
multiple-choice question
What is a correct description of the scenario in which the control is used? (Score: 3 out of 3)
Correct Answer: B,C,D
Your answer: B,C,D
properly
A. The image component supports JPG, PNG, DWG and GIF formats.
B. The text component is suitable for prompting the user viewing the dashboard
C. Text components are suitable for annotating dashboards, components, etc.
D. WEB components are suitable for adding links to dashboards
Question 35
multiple-choice question
What data visualization and analysis scenario is each of FineBI's graphical shapes, point, area, rectangular block, and funnel charts, correct? (Score: 0 out of 3)
Correct Answer: B,C,D
Your answer: A
incorrect
A. A point plot is a chart used to show changes in data over a period of time, emphasizing changes in data over time or other conditions.
B. Area charts can be used to present continuous data and are good for showing trends, accumulation, decreases and changes. It is better at showing relationships between parts and the whole.
C. Rectangular Block Charts show the distribution of different data points in the form of rectangular blocks. The rectangular block diagram can be colored or the size of the rectangular blocks to show the size of the corresponding indicator values.
D. Funnel charts are the type of charts that show the percentage of each stage and provide analysis of conversion and reach rates.
Question 36
multiple-choice question
What are the return values of MONTHDELTA("2021-04-08",4) and MONTHDELTA("2021-04-08",-4)? (Score: 3 out of 3)
Correct Answer: B,C
Your answer: B,C
properly
A. 2021/8/1
B. 2021/8/8
C. 2020/12/8
D. 2020/12/1
Question 37
multiple-choice question
FineBI provides a number of quick calculations that can be implemented to analyze scenarios with a simple click of the mouse without having to write complex functions. Which of the following can be directly realized by the quick calculations in FineBI? (Score: 2 out of 2)
Correct Answer: A,B,C,D
Your answer: A,B,C,D
properly
A. Year-on-year comparison
B. Percentage
C. Ranking within groups
D. Cumulative values
Question 38
multiple-choice question
Numeric fields support grouping in the following ways (Score: 3 out of 3)
Correct Answer: A,C
Your answer: A,C
properly
A. Identical values as a group
B. Customized groupings
C. Interregional groupings
Question 39
multiple-choice question
In a grouping summary, the types of additions supported by the grouping field are (Score: 3 out of 3)
Correct Answer: A,B,C
Your answer: A,C,B
properly
A. Text fields
B. Numeric fields
C. Time fields
D. Character fields
Question 40
multiple-choice question
Which of the following chart attributes does a bar chart have? (Score: 3 out of 3)
Correct Answer: A,B,D,E,F
Your answer: A,B,D,E,F
properly
A. Colors
B. Size
C. Connecting the dots
D. Labeling
E. Reminder
F. Fine-grained
Question 41
multiple-choice question
The types of hover elements currently supported in dashboard design are? (Score: 3 out of 3)
Correct Answer: A,B,C,D,E,F
Your answer: A,B,C,D,E,F
properly
A. Text components
B. Picture components
C. Graphic components
D. Filter controls
E. Query button
F. Web components