RPA Quiz

   1- RPA interacts with multiple applications at the.....  Layer.
         a- Presentation
         b- Object
         c- Data
         d- None
Ans- a

   2-   .... Is the master repository of jobs
      a- Developer tool
      b- Software Robot
      c- Process Recorder
      d- Robot Controller
Ans- d

   3- ........Deploy(s) jobs to the software robots.
      a- Developer tools
      b- Process recorder
      c- Robot Controller
Ans- a

   4- Greater resilience is achieved in RPA through..........
       a- Layered Configuration
       b- Functional approach
       c- Object-oriented approach
Ans- c

   5- All the RPA tools provide both front and back office automation.
     a- True
     b- False
Ans- False

    6-The sequence of user action is captured to speed up the process definition using..... .......
        a- Process Recorder
        b- Robot Controller
        c- Action Recorder
Ans- a

   7- RPA stores data and enables automation.
       a- False
       b- True
Ans- a

    8- RPA enables-
       a- Reduces delivery risk
       b- Cost based reduction
       c- Easy Integration
       d- All
       c- None
Ans- d

   9- Unclear inputs, social Context, Task distribution and Transformation are some of the key attributes with favor RPA.
        a- Intelligence
        b- Autonomous
        c- Assisted
        d- Unassisted
        e- Cognitive
Ans- c

    10- RPA enables reduction of data entry errors.
          a- True
          b- False
Ans- a

    11- Re-engineering the entire underlying process is part of....
           a- BPM
           b-RPA
           c- Both

    12- A robot can accumulate knowledge of procedures over the time.
          a- True
          b- False
Ans- b

    13-  ... Publishes the data to the master repository.
          a- Process Developer
          b- Process recorder
          c- Robot controller
Ans- a

    14- Macros are linear and fixed but RPA is dynamic.
         a- True
         b- False
Ans- a

    15-  The lowermost layer in the layered design of RPA is.....
         a- Sub Process
         b- Atoms
         c- Process
         d- Object
         e- None
Ans- e

    16- RPA interacts with multiple applications at the.....  Layer.
          a- Presentation
          b- Object
          c- Data
          d- None
Ans- a

    17-  .... Is the master repository of jobs
           a- Developer tool
           b- Software Robot
           c- Process Recorder
           d- Robot Controller
Ans -d
    18- .....deploy(s) jobs to the software robots.
           a- Developer tools
           b- Process recorder
           c- Robot Controller
Ans -  a

    19- Greater resilience is achieved in RPA through..........
            a- Layered Configuration
            b- Functional approach
            c- Object-oriented approach
Ans -c

    20- The sequence of user action is captured to speed up the process definition using..... .......
            a- Process Recorder
            b- Robot Controller
            c- Action Recorder
Ans-a

    21- RPA stores data and enables automation.
            a- False
            b- True
Ans- a

    22- Which of these business processes can be automated with RPA?
          a- Massmail Generation
          b- Claim Process
          c- Web Data extraction
          d- All
Ans- d

    23- What are the business benefits of RPA includes?
          a- Flexibility and Scalability
          b- Improved Accuracy
          c- Improved Employee Morale
          d- All
Ans- d

What is RPA?

Tableau Quiz 3

1- How do you change the visual summary type to a pie chart type?
   a- Data Menu> Type > Select pie chart
   b- Toolbar> ShowMe button > select pie chart
   c- worksheet menu > type > select pie chart
   d- right-click the visual summary > select pie chart
Ans- b

2- Which of the following data sources does Tableau allow you to connect to?
   a- Excel
   b- Text Files
   c- Open data server
   d- All of these
Ans- d

3- How do you view the data that underlies the visualization you've created in Tableau?
    a- Data menu > Data Source name > View Data
    b- File menu >  Data Source name > View Data
    c- Data menu > Data Source name > Extract Data
    d- Data menu > Data Source name > Edit Data Source
Ans-a

4- Which of the following built-in functions will round a number up to the next integer?
   a- CEILING
   b- ABS
   c- ROUND
   d- FLOOR
ANS-A

5- How do you create a set within your visualization sheet?
   a- select the data in multiple rows > right-click one of them > choose Format
   b- select the data in multiple rows > right-click one of them > choose Create Set
   c- select the data in multiple rows > right-click one of them > choose Group
   d- select the data in multiple rows > Data menu > choose Create Set
Ans- b

6-if you want to add colors to each of the vertical bars in a visualization, you need to drag the field that will be used as the base for those colors to the Marks card and, specifically, onto the Color box.
  a- True
  b- False
Ans- True

7-  A limitation of the Tableau is that if it does not recognize a location in a visualization it won't be able to map it, so you need to make sure that your data can be mapped.
   a- True
   b- False
Ans- True

8- Calculations Rank() is used for?
   a.  Ranking of views
   b. Ranking for each value in a partition
   c. Both
   d. None

Tableau Quiz2

1- ZN(expression) is

   a.  Return (expression) if it is not null, otherwise return zero
   b.  Return (expression) only if zero
   c.  Return (expression) if null
   d.  None

Ans - a

2- Javascript API is used in Tableau
    a.  To integrate tableau visualizations into your web applications
    b.  To schedule the data extract
    c.  To automate the data integration
   d.  None
Ans- a

3- Single axis show multiple measures and all the marks are shown in a single pane. This concept is known as....  ?
   a.  Dual Axis
   b.  Blended Axis
   c.  Multiple axis
   d.  None
Ans- b

4- Parameters can be used as-
   a.  Filters
   b.  Calculated field
   c.  Actions
   d.  Measure swap
   e.  Auto update
   f.   Dimensions
Ans-  a,b,d,f


5- In tableau sorting can be done via below methods.
   a.  Alphabetic
   b.  Data source order
   c.  Manual
   d.  Field
   e.  Index
Ans- a,d,e

6- URL action is
    a.  A hyperlink that points to another sheet
    b.  A link that points to another dashboard
    c.  A hyperlink that points to a web page, file,  or another web-based resource outside of Tableau.
Ans- c

Tableau Quiz

1-   Tableau allows -
      a. both live connection and data extraction
      b. only live connection
      c. only data extraction
      d. None
Ans- a

2-  Tableau allows direct connection to the database for fetching data
     a. True
     b. False
Ans- a

3-  The data elements of a data source are divided into the following within Tableau Desktop-
     a. Dimensions
     b. Measures
     c. A and B
     d. None
Ans- c

4- Data from excel files can be directly accessed via Tableau?
     a. True
     b. False
Ans- a

5- For a 64 -bit Tableau Server what is required
   a. 2 core, 4GB RAM
   b. 4 core, 8GB RAM
   c. 8 core, 16GB RAM
   d. 16 core, 64GB RAM
Ans- d

6- How many Max tables can we join in tableau?

   a. 256
   b. 64
   c. 32
   d. 16

Ans- c

7- How many types of annotations used in tableau?
   a. 5
   b. 7
   c. 3
   d. 2
Ans- c

8- Multiple values can be selected in filters?
  a. True
  b. False
Ans- True

Tableau Quiz2

Data Blending

Data blending is used when we use data from more than one data source in a single workbook. Data blending is based on the common dimension used to join both databases. Two data sources used in data blending are referred to as a primary data source and secondary data source. A small chain image appears next to the common dimension between both data sources. Data blending is used to combine data from one data source with column data from another data source in a single table.

Why data blending is useful over join-

1- Data is at different granularity.
2- Data is not supported by cross-database join