hello guys if you are looking for, Data Analytics Tech Leap MCQ | Data Analytics Tech Leap Multiple Choice Questions| Data Analytics Tech Leap Question Answers| Data Analytics Tech Leap|Data Analytics Tech Leap Accenture Dumps
Q1.Which is not a valid attributes of DataFrame ?
A. df.columns
B. df.values
C.df length
D. df.axes
Ans: b
Q2. Which statement is true about Python Set?
A. Set is immutable
B. Set stores key and value pair
C. Set element is unique
D. Set is ordered collection
Ans: a
Q3.What is the output of below code data =” 343.45″ print(data.isdigit())
A. 0
B.False
C. True
D. -1
Ans: b
Q4. Find the output of below code data =(101:”Sam” ,102: “Max” data[101] =” JD” print(data)
A. syntax error
B. (101:”Sam”,102:”Max”)
C. (101: ‘JD’, 102: ‘Max’}
D. {102:”Max”}
Ans: c
Q5. Which is the correct syntax to add a column to dataframe
A.dff Contact’]=pd.Series([986000,88888,33333], dtype=int’)
b. df.Contact=pd.Series ([986000,88888,33333])
C.df pd.Series([986000,88888,33333], dtype =”int” )
D.All of the above
Ans: b
Q6. Which statement is not true for Python function?
A. The “def’ keyword is a statement for defining a function in Python
B. You start a function with the def keyword, specify a name followed by a colon (:) sign
C.Python function can return multiple values
D.return is not a key word
Ans: a
Q7. What is the output of below code
x={ “Max” “Paul”, “Peter”}
y= [“Anil”, “Sunil”, “James”)
z=(^ Pankaj “Peter”, “Max”}
result = x.union(y, z)
print(result)
A. (James’, ‘Peter’, ‘Anil’, ‘Pankaj’, ‘Sunil’}
B. (Paul’, ‘James’, ‘Peter’, ‘Max’, ‘Anil’, ‘Pankaj’, ‘Sunil’}
C. Paul’, ‘James’, ‘Peter’, ‘Anil’, ‘Sunil’}
D.syntax error
Ans: b
Q8. What will be the output of the following Python code snippet?
a = [101, 101, 103, 104]
i = 105
for i not in a: print(i) I+=1
A. 106 107 108
B.error
C. 105
D. 109
Ans: b
Q9. What is the output of below code? Employee = [emp1′: (‘name’: ‘Lisa’, ‘age”: “29”, }} Employee[‘name’]=’Kate’ Employee[emp1][name]=”Paul” print(Employee)
A. Syntax Error
B. {emp1′: (‘name’: ‘Paul’, ‘age’: ’29’, ‘name’: ‘Kate’}}
C.{’emp1′: [‘name’: ‘Paul’, ‘age’: ’29’), ‘name’: ‘Kate}
D. (emp1′: (‘name’: ‘Paul’, ‘age’: ’29’)
Ans: c
Q10. Which is the correct syntax for calling function def add(val): print(val)
A.add(4,5,5)
B.All of above
C. add([3,4,5,],5)
D.add(“Hello”)
Ans: b
Q11. What are workflow group files?
A. Files that contain metadata and descriptions about workflows
B. A collection of workflows that are saved together and can be opened as one file
c. A series of identically configured tools used in serval workflows and stores in one place
Ans: b
Q12. Which tool takes the provided input and creates the provided output?
A. Running Total
B. Summariza
C.Select
D.Unique
Ans: b
Q13. This option helps to disable a part of the main workflow from running:
A.Container Tool
B.Standard Macros
C.Batch Macros
D.Disable Workflow
Ans: d
Q14. Is it possible to save multiple workflows as a workflow group, which can then be opened as one workflow group file?
Ans – true
Q15.Which operations may be performed with the Formula tool? Select all that apply
A. Perform multi-row calculations
B. Find minimum and maximum values
C. Apply conditional statements
D. Format dates
Ans:b c d
Q16. Which expression in the Formula tool will produce the column “Formal Title” in the dataset below?
A. Replace([Name],”,Dr.)
B. ReplaceChar([Name],”*”, “Dr.”)
C.Replace([Name],”*”,”Dr.”)
D. ReplaceChar([Name],1,Dr.)
Ans:d
Q17. In the results window, a red triangle appears in the top right corner of a cell if the data contains anomalies. Which of the following are anomalies that will cause a red triangle to appear? Select all that apply
A.Number rounded to six decimal places for viewing
B.Spelling mistakes
C.Strings with leading or trailing spaces
D.Strings with embedded new lines
Ans: b c d
Q18. Which among the tools under the join category allow the data type and size of the fields to get changed? Select all that apply
A. Append
B. Find Replace
C. Union
D. Join
Ans: c d
Q19.Which of the following statements is true about the error message tool? Select all that apply
A. It cannot be updated with an Action tool
B.It can be configures in the Interface Designer
C.It only receives incoming connections
Ans: ab
Q20. How many rows would be in the output of Append Tool if the Append is set to allow all appends?
A.885
B.885 *18
C.885 + 18
D.18
Ans: d
Q21. Which statements about the Append tool are correct? Select all that apply
A.The tool can be configured to remove specific columns
B.The tool joins every row of one table to every row of another table
C.Each input dataset must have at least 2 columns
D.Fields can be renamed
Ans: d
Q22.A user has six months of identically configured sales documents in separate files. The user has pulled in each document separately and now wants to gather all of the data into one table for analysis. Which tool will allow the user to join the data so that all corresponding fields align vertically?
A.Join
B.Join Multiple
C.Union Tool
D.Append
Ans: c
Q23. Assuming Field Category has the value south, east, and west. Which output file(s) will be generated using this configuration of the Output Data tool
A.EastWestSouth.csv
B.southAREA.csv eastAREA.csv westAREA.csv
C.AREA.csv
D. southeastwestAREA.csv
Ans: d
Q24. Which of the following functions can be used to fetch first few records of a dataset?
A.head()
B.tail ()
C. first ()
D.face ()
Ans: a
Q25. In console if you have a = c(3, 5, 7) and in next line you write a + 2 What will be result of this statement?
A.6 10 14
B.5 7 9
C.3 5 7
D. 1 2 3
Ans: b
Q26. a = 1 b = 2 x <- a==b what will be the type of x?
A.double
B.complex
C.boolean
D. integer
Ans: d
Q27.What is the result of rep (4,4)?
Ans – 1 2 3 4
Q28.What is the result of below code? a = 5 b = 4 if(a>b){Print(‘a isgreater))else(Print(‘b is greater’)};
A.5
B.4
C.a is greater
D.b is greater
Ans: c
Q29. is.na() function can be used for which of the below options?
A.recognize and display missing values in a vector
B. replaceing missing values with some other values
C.removing missing values from a vector
D.inserting missing values ina vector
Ans: c
Q30. a = c(10, 20, 30) b = c(2, 5, 6) what will be the result of a/b?
A.Error
B.256
C.545
D.567
Ans: a