UiPath Quiz

1-  Variable can be created even if the Designer panel does not contain at least one activity.
      A- True

      B- False
Ans- B

2- Which among the following has multiple branching logical operators?
     A- Sequence
     B- Flowchart.            Wrong
     C- Flowchart and Sequence
     D- None

3- Recording captures everything and transforms into ___ _.
     A- Diagram
     B- Sequence
     C- Flowchart. Wrong

4- --------- - provides skeleton structure for process.
     A- Automatic Recording
     B- Manual Recording
     C- Both
Ans- A

5- ------------- is not a type of recording.
    A- Application
    B- Citrix
    C- Basic
    D- Desktop
Ans- A

6- $ is a wildcard selector.
    A- False
    B- True
Ans- A

7- --------- deals with numbers,  characters and boolean.
    A- Collection
    B- Scalar
    C- Tables
    D- All
Ans- B

8- which activity enables you to step through arrays,  lists,  data tables or other types of collections?
     A- ForEachRow
     B- ForEach
     C- Do while
     D- All.  -wrong
Ans- B

9-   -----  is used to secure the text sent to UI elements.
    A- Security Text
    B- Type secure text
    C- Secure text
    D- Secure type text.

10- ------- is used when reliable selectors are not available.
     A- Append Range
     B- Range Append
     C- Add range

11- Which among the following is used to save mails to a specified folder?
      A-Save Mail Message
      B- Mail save
      C- Save mail
      D- Mail save Message

12- Citrix environment is a virtual environment.
      A- True
      B- False

13- Output methods are also called as--------
      A- Output scrapping
      B- Web scrapping
      C- App scrapping
      D- Screen scrapping

14- Relative scrapping helps in extracting data from virtual networks.
      A- True
      B- False

15- Pick Branch activity cannot be used inside the Then/Else section of an If activity.
      A- False
      B- True

16- What is the file that contains the information about the automation project?
      A- project.json
      B- project.xml
      C- project.config
      D- project.xaml

17- _______ enable you to pause the execution of automation so that you can check its state at a            given point.
      A- Slow Step
      B- Breakpoints
      C- pause
      D- Break
Ans- Breakpoints

18- ___is the best approach to filter data from a data table based on a condition.
      A- Clone
      B- Select
      C- Copy
      D- Sort
Ans- Select

19- Entry,Exit and ___________ are the three sections of the state activity in a state machine.
     A- Validate
     B- End
     C- Transations
     D- Transition(s)
Ans- D
20- Which among the following is a organized project standard? 
    A- Maintanable
    B- Efficient
    C- Reliable
    D- All

Global Exception Handler in UiPath

Global Exception Handler is kind of workflow which is used to determine the project's behavior when an exception occurred.

The Global Exception Handler has two arguments-
1- errorinfo  (In direction)
2- result       (Out direction)

Values can be assign in result arguments-
a- Continue
b- Ignore
c- Retry
d- Abort
    

UiPath Workflow

Types of workflow -  

UiPath have 3 types workflows-

     1- Sequence
     2- Flowchart
     3- State Machines

1- Sequence -  Sequences are the smallest type of project. It is used for the linear process. Sequences can be reused in the process. It can be used as standalone or as a part of flowchart or state machine.

2- Flowchart -  Flowchart can be used in large jobs to small projects. It can be reused in the other projects also. Flowcharts have multiple branching logic operators, which are very helpful to create a complex business process. A flowchart can be connected activities different ways.

3- State Machines- It uses a finite number of states in its execution. It enters into a state when triggered by activity, and it exits that state by triggering the other activity.



UiPath

UiPath

UiPath is an RPA tool. It's founded in 2005 by Daniel Dines and Marius Tirca both are Romanian entrepreneurs.
It's used for Windows desktop automation.
It has three main products

1- UiPath Studio- It is an advanced tool. Here you can design process need to automate. 

2- UiPath Robot- UiPath Robot executes the process which is designed in the UiPath Studio. It can be attended or unattended. For attended Robot user need to start the process and unattended robot whole process run automatically without any supervision.

3- UiPath Orchestrator- This is a UiPath web application where you can schedule, monitor,  deploy and manage the Robots and process.

Advantage and Limitations of RPA

RPA is software which works on the user's computer. RPA is used to automate the repetitive, template driven and rule-based process.

Advantage of RPA -

1- RPA works on the front end UI of existing IT infrastructure so there is no need to change in the existing system and database.
2- RPA can work on 24/7with more efficiency and accuracy. There is no break and sick leave.
3- It can work on multiple platforms Windows, Web, Java, and Mainframe applications
4- One ROBOT can work more than one process at the different schedule. It can work 8 hrs for one process and for the next 8 hrs another process.

Limitations of RPA -

1- Speed of a BOT is depended on the speed of application and network.

2- Creative task cannot be automated with RPA. If any task requires judgments it also cannot be automated.

3- If there are some changes in the applications, then ROBOT need to be reconfigured or redesign.

What is RPA?
RPA Quiz

RPA Tools

Main Leading RPA tools in the market:-

1- Automation Anywhere
2- UiPath
3- BluePrism
4- Workfusion
5- Pegasystems
6- Nice

What is RPA?

What is RPA?

RPA is Robotic Process Automation. RPA is a software which is installed on a user's computer called as 'ROBOT' or 'BOT'. It is not a physical robot.

It is used to automate complex, high volume, rule-based and repetitive tasks. A BOT is designed to perform the sequence of steps as the human user will work which is done on the front end of UI.

RPA access the application through the presentation layer(front end). It does not disturb business logic or system as it is not required to integrate with the existing system.

RPA enables macro level task automation.RPA is a new modern term for all the software automation systems. RPA tools do not store any data.

RPA tools available in markets-

1- Automation Anywhere
2- Blue Prism
3- UiPath
4- Nice
5- WorkFusion and much more.


RPA Quiz
RPA Quiz 2
RPA Quiz 3

RPA Quiz 3

1-Which among those, not a RPA tools?
    a- Blue prism
    b- UiPath
    c- Automation Anywhere
    d- Blackline
    e- Openspan
    f- Edge verve
Ans- d

2- BPM interacts through the.......  Layer.
    a- Presentation
    b- Data access
    c- Both
    d- None
Ans- a

3-  RPA will be able to handle operations such as........
     a- Claim proceeding
     b- Writing emails
     c- Documents classifications
     d- Document classification and claim processing

4- Prioritized work queue is available in the market.
     a- AutomationAnywhere
     b- UiPath
     c- BluePrism
     d- All

5- What is the leading RPA tool available in the market?
     a- AA
     b- BluePrism
     c- UiPath
     d- Pegasystems
     e- Nice
     d- Workfusion
Ans- AA

6- BluePrism has the largest trained ecosystem?
     a- True
     b- False
Ans- b

7- RPA with thinking and decision-making capabilities are known as...  RPA.
    a- AI-Assisted
    b- Cognitive
    c- Unassisted
    d- Autonomous
    e- Intelligence
Ans-  b

8- RPA can be used to automate ....
    a- Statement reconciliation
    b- Customer relation management
    c- Both
    d- None

9- UiPath offers rule-based automation
    a- True
    b- False
Ans- a

10- CRM systems can be streamlined using...  tools.
       a- RPA
       b- BPM
       c- None
       d- Both

11-  Autonomous RPA is kind of...
       a- Assisted
       b- Unassisted

12- For RPA to work efficiently, the programming logic of the underlying system must be modified accordingly.
     a- True
     b- False

13- Which has the largest trained ecosystem?
     a- AutomationAnywhere
     b- BluePrism
     c- UiPath
     d- Pegasystems
Ans- a

What is RPA?
RPA Quiz

RPA Quiz 2

1- Robots are trained by...
     a- IT specialist
     b- End User
Ans- b

2- Sequence of step by step instructions is known as  -
    a- Process
    b- Jobs
    c- Both
    d- None
Ans- b

3- Software robots are capable of interacting with a wide range of the system.

    a- False
    b- Ture
Ans- b

4- RPA enables monitoring of network devices.

    a- True
    b- False
Ans- a

5- Locating object relative to the edge of the screen is known as...
    a- Pixel-based object location
    b- Image matching
    c- Both
    d- None
Ans- a

6- .... Is hosted on the server.
     a- Developer Tools
     b- Robot Controller
     c- Both
     d- None
Ans - b

7- Layered approach in RPA design assists in separating different levels of abstraction.
     a- True
     b- False
Ans- a

8- The top most layer in the layered design of RPA is....
     a- Sub Process
     b- Components
     c- Process
     d-Object
     e- None
Ans- c

9- RPA is similar to old technologies such as screen scraping or macros.
    a- True
    b- False
Ans-  a

10- Process administration technique, which focuses on Global process tracking is...
      a- Resources Allocation
      b- Error Handling
      c- Process Analytics
      d- All
Ans- d

11- Human should convert the unstructured text to the standard format which system can utilize in the process.
     a- True
     b- False
Ans-  a


RPA Quiz
What is RPA?

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 have to use data from more than one data source in a single workbook.
Data blending based on the common dimension used to join both the databases.
Two data source used in data blending referred as a primary data source and secondary data source.
A small chain image appears next to the dimension which is common between both data sources.
Data blending is used for combining data from one Data source with column data from other 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

Tableau Data Extract

Tableau data extract (.dte) -
Stores tableau data as a filtered and aggregated extract.
TDE files are data extracted from the external source such as MS Access or Excel. It is used for external data.  This data can be text,  numerical or statistical data.
TDE extracts are Tableau's method of caching data logically so as to reduce database hits for frequent access reports.
TDE extract can be refreshed manually through Tableau desktop or to be scheduled for periodic refresh through the enterprise edition.

Tableau Packaged Workbook

Tableau packaged workbook contains the Tableau package and extracted local data. The packaged workbook also includes background picture and customized settings in a workbook.
The main purpose of a packaged workbook is to share it with other Tableau Desktop users, who do not have data access. These users can modify the workbook also.
Tableau Reader user can also use packaged workbook but they can't modify it.

The workbook is not connected to original data source and images. It is saved with a .twbx file extension.

Tableau Workbook

Tableau workbook files have the .twb file extension. It is default file type for Tableau users. It does not contain any data in the file.
Tableau Workbook is in XML format. ( it can be edited in a text editor). A workbook contains one or more worksheets. It can also contain dashboards or stories.
It contains information about all formatting, styles, and aggregations applied to any sheet or dashboards in the workbook.
It also contains information about the data source connection and metadata created due to all connections.
Tableau workbook files can be shared with colleagues and clients but they should have access to the data sources.

Tableau Extension File

Tableau uses different file formats which depends on the purpose of there use.

The different formats have unique file types which are identified by there extensions.

These Tableau files can be open in XML format and it can be edited and modified as per requirement.

1. [.TWB]      Tableau Workbook
2. [.TWBX]    Tableau Packaged Workbook
3. [.TDS]       Tableau Data Source
4. [.TDSX]     Tableau Packaged Data Source
5.  [.TDE]      Tableau Data Extract
6. [.TDM]       Tableau Bookmark
7. [.TMS]       Tableau Map Source
8. [.TPS]        Tableau Preference

Tableau Dashboard Tool

Tableau is data visualization and business analytics tool. It is used To build interactive dashboards which allow the user to analyze and explore data
It is developed in Stanford University, Computer Science department between 1999 and 2002.
In Tableau, you can connect any data source. Eg Excel,  SAP etc
You can drag various data fields to the desired part of the sheet.
It is used for interactive dashboards
Tableau automatically makes the inner join.
We can add the different data source in a single table.

Tableau has different products -

1- Tableau Desktop

2- Tableau Public

3- Tableau server

4- Tableau Online

5- Tableau Reader

Fact Table

Fact Table

Type of Fact-

1-Additive- Additive facts are facts that can be summed through all of the dimensions in the fact table.
2-Semi-Additive- Semi-aditive facts are that can be summed through some of the dimensions and cannot be summed through some dimensions.
3-Non-Additive- Non-additive facts are that can not be summed up for any dimensions in fact table

Factless Fact table-

A factless table is fact table which does not contains any measure. It is just an intersection of dimenstions.