以下是testdome平台的OA记录，让我们看看和codesignal、hackrank等平台相比有什么不同吧。

Which of the following is NOT a type of trigger that can be used to start an Azure Data Factory pipeline?

• When an HTTP request is received
• On a schedule
• When a file is added to an Azure Blob Storage container
• When a new row is added to an Azure SQL table

Select all of the statements about Amazon S3 that are correct.

(Select all acceptable answers.)

• The visibility and accessibility of the objects can be managed at either the bucket or object level.
• Amazon S3 is cheaper and faster than Amazon Glacier.
• It is cheaper to retrieve an object on the Standard storage class than on the Infrequent Access storage class.
• S3 allows recovering deleted files if configured properly.
• You can have multiple buckets with the same name.

A startup is in doubt where to host their video-sharing platform. What are sure advantages of using a cloud solution over in-house servers?

(Select all acceptable answers.)

• No possibility of data breach.
• Smaller initial costs.
• Smaller lifetime costs.
• Better control of the whole physical infrastructure.
• It usually requires less time to add additional resources.

Two financial stock indexes, FSIA and FSIB, each contain a different, unique set of companies. Each index is stored in a separate table with different schema definitions:

• The fsia table provides only the market capitalization of the companies.
• The fsib table provides the share price and shares outstanding. Market capitalization can be calculated as follows: Share Price * Shares Outstanding.

The table schema:

TABLE fsia companyName VARCHAR(30) NOT NULL PRIMARY KEY marketCapitalization FLOAT NOT NULL TABLE fsib companyName VARCHAR(30) NOT NULL PRIMARY KEY sharePrice FLOAT NOT NULL sharesOutstanding INTEGER NOT NULL

Write a query that returns the name and market capitalization of each company, ordered by market capitalization, largest to smallest.

See the example case for more details.

--- Suggested testing environment:
--- For MS SQL:
--- https://sqltestonline.com/ with language set as MS SQL
--- For PostgreSQL:
--- https://sqltestonline.com/ with language set as PostgreSQL
--- For MySQL:
--- https://www.db-fiddle.com/ with MySQL version set to 8
--- For SQLite:
--- http://sqlite.online/

--- Example case create statement:
CREATE TABLE fsia (
companyName VARCHAR(30) NOT NULL PRIMARY KEY,
marketCapitalization FLOAT NOT NULL
);

CREATE TABLE fsib (
companyName VARCHAR(30) NOT NULL PRIMARY KEY,
sharePrice FLOAT NOT NULL,
sharesOutstanding INTEGER NOT NULL
);

INSERT INTO fsia(companyName, marketCapitalization) VALUES('Baggage Enterprise.', 12500);
INSERT INTO fsia(companyName, marketCapitalization) VALUES('Fun Book Corporation', 10000);

INSERT INTO fsib(companyName, sharePrice, sharesOutstanding) VALUES('Macaroni Inc.', 8, 1000);
INSERT INTO fsib(companyName, sharePrice, sharesOutstanding) VALUES('Solitude Ltd.', 12.5, 600);
INSERT INTO fsib(companyName, sharePrice, sharesOutstanding) VALUES('Universal Exports LLC', 1.2, 2300);

--- Expected output:
--- companyName marketCapitalization

---

--- Baggage Enterprise 12500
--- Fun Book Corporation 10000
--- Macaroni Inc. 8000
--- Solitude Ltd. 7500
--- Universal Exports LLC 2760

--- Explanation:
--- In this example.
--- Baggage Enterprise is the largest company, it therefore appears first in the results.
--- The companies descend in order by marketCapitalization until Universal Exports LLC which is the smallest.

Design a data structure that can, efficiently with respect to time used, store and check if the total of any three successively added elements is equal to a given total.

For example, MovingTotal() creates an empty container with no existing totals. append([1, 2, 3, 4]) appends elements [1, 2, 3, 4], which means that there are two existing totals (1 + 2 + 3 = 6 and 2 + 3 + 4 = 9). append([5]) appends element 5 and creates an additional total from [3, 4, 5]. There would now be three totals (1 + 2 + 3 = 6, 2 + 3 + 4 = 9, and 3 + 4 + 5 = 12). At this point contains(6), contains(9), and contains(12) should return True, while contains(7) should return False.

class MovingTotal:

def append(self, numbers):
    """
    :param numbers: (list) The list of numbers.
    """
    pass

def contains(self, total):
    """
    :param total: (int) The total to check for.
    :returns: (bool) If MovingTotal contains the total.
    """
    return None

if name == "main":
movingtotal = MovingTotal()

movingtotal.append([1, 2, 3, 4])
print(movingtotal.contains(6))
print(movingtotal.contains(9))
print(movingtotal.contains(12))
print(movingtotal.contains(7))

movingtotal.append([5])
print(movingtotal.contains(6))
print(movingtotal.contains(9))
print(movingtotal.contains(12))
print(movingtotal.contains(7))

可以看到testdome平台中算法题较少，而多选题和数据处理的code题比较多，如果你觉得这篇文章有用，欢迎收藏本站。

术高莫用~，估计丢一点分免得拿满分太张扬。OA代做，VO辅助，代面试，欢迎联系我。

If you're afraid that you can't solve the OA on your own, please scan the code to contact me or telegram