Exam 350-401 topic 1 question 688 discussion

WTF is this a Cisco or SQL exam

WTF are they serious?

nice one slacker_at_work !

I this sql exam or cisco one , I dont see get it just like I wasn't able to roam my globe sim before knowing https://theglobesimregistration.ph

Connect to the SQLite database (user.sqlite) Execute the SQL query (find the username for a given IP address: the IP address stored in the list item with index 'i') Fetch the entire result set and parse it into a Python list (list 'e') Modify the result list - in our example, curly brackets were replaced with double quotes

I wonder what is being asked in devops then, if these are encor questions?

Definitely 'B'. After getting the username from e[0] it removes the ( and ) chars from string. (nothing written back to DB)

B is correct The keyword is: c = "select user from monitor branch where loopbackip='" + str(ip[i]) + "'"

i'm going with B, no idea why :D

I'm 50/50 with it being B or C. The two lines for .... usr = usr.replace() ...functions, are for writing. - I honestly just hope I don't see this question :-/

Here's a breakdown of what each part does: -1 Importing sqlite3: This line imports the SQLite3 module in Python, allowing the script to interact with SQLite databases. -2 Connecting to the database: The script connects to a SQLite3 database located at /home/sdwan-lab/user.sqlite3. This is done using the connect() method of the sqlite3 module, which returns a connection object (a in this case). -3 Creating a cursor object: Cursors are used to execute SQL queries on the connected database. The cursor() method creates a cursor object (b in this case) associated with the connection

- 4 SQL Query: The variable c contains an SQL query. It appears to be selecting the user column from a table named monitor_branch where the loopbackip matches a specific pattern. However, there seems to be a syntax error in the query. The string concatenation is not done properly. - 5 Executing the query: The execute() method of the cursor b executes the SQL query stored in the variable c. - 6 Fetching the results: The fetchall() method retrieves all the rows returned by the query execution and stores them in the variable e. - 7 Processing the result: The script then appears to be manipulating the fetched result. It converts the first element of the result (e[0]) to a string, removes any occurrences of ( and ,) from the string, and assigns the modified string back to the variable usr.

doesn the usr.replace string write the username back to the DB once it selects it from the table monitor_Branch?

B: good link here for similar queries from sqlite3 DB. https://pyneng.readthedocs.io/en/latest/book/25_db/sqlite3_fetch.html

B seems to be correct, because data only needs to be read from the DB, and not altered. https://www.google.com/amp/s/www.geeksforgeeks.org/how-to-list-tables-using-sqlite3-in-python/amp/

no clue ... didn't see this coming , not in OCG