Question 1

As a Cloud Developer you need to work with relational databases like SQLite. You need to create a table named employees with columns as follows:-> id: INTEGER, NOT NULL-> name: TEXT, NOT NULL-> age: INTEGER, NOT NULLAnd the primary key constraint set to the id column.Which of the following statements will correctly create the employees table? (select 2)

Options :

A : CREATE TABLE employees ( id INTEGER NOT NULL PRIMARY KEY, name TEXT NOT NULL, age INTEGER NOT NULL);

B : CREATE TABLE employees ( id INTEGER NOT NULL, name TEXT NOT NULL, age INTEGER NOT NULL, FOREIGN KEY (id));

C : CREATE TABLE employees ( id INTEGER NOT NULL, name TEXT NOT NULL, age INTEGER NOT NULL);

D : CREATE TABLE employees ( id INTEGER NOT NULL, name TEXT NOT NULL, age INTEGER NOT NULL, PRIMARY KEY (id));

Answer: A,D

Question 2

You are building a Python application that needs to send an HTTP POST request with JSON data to a remote server. Which code snippet correctly demonstrates the usage of the requests module to accomplish this task?

Options :

A : import requests url = "https://api.example.com/data"data = {"key": "value"} response = requests.get(url, json=data)

B : import requests url = "https://api.example.com/data"data = {"key": "value"} response = requests.patch(url, json=data)

C : import requests url = "https://api.example.com/data"data = {"key": "value"} response = requests.put(url, json=data)

D : import requests url = "https://api.example.com/data"data = {"key": "value"} response = requests.post(url, json=data)

Answer: D

Question 3

Which of the following expressions is the correct interpolation syntax used in INI files?

Options :

A : %(localhost)

B : %(localhost)s

C : %(localhost)%

D : $localhost

Answer: B

Question 4

Assume that the following piece of code has been successfully executed:

class Vehicle:

fleet = 0

def __init__(self, category=None):

self.category = category if category else 'vehicle'

Vehicle.fleet += 1

def __str__(self):

return self.category

class LandVehicle(Vehicle):

def __str__(self):

return super().__str__() + ': land'

class AirVehicle(Vehicle):

def __str__(self):

return super().__str__() + ': air'

What is the expected output of the following piece of code?

veh1 = Vehicle()

veh2 = LandVehicle()

veh3 = AirVehicle()

print(veh1)

print(veh2)

print(veh3)

Options :

A :

vehicle

B :

vehicle

: land

: air

C :

vehicle

vehicle: land

vehicle: air

D : This code will raise the SyntaxError exception.

Answer: C

Question 5

The Zen of Python says "Readability counts."With that in mind, which code best fits that sentence?

Options :

A :

B :

C :

D :

Answer: D

Free PCPP-32-101 Mock Exam – Practice Online Confidently

Buying Options: