Free Microsoft DP-900 Practice Exam with Questions & Answers | Set: 3

Which storage solution supports role-based access control (RBAC) at the file and folder level?

Which storage solution supports access control lists (ACLs) at the file and folder level?

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to create a database object that would allow other users to rerun the same SQL query.

What should you create?

Select the answer that correctly completes the sentence.

Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract load, and transform (ELT) process.

Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct. Each location may be used once, or not at all, You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

For each of the following statements, select yes if he statement is true, Otherwise select No.

NOTE: Each correct selection is worth one point.

Which statement is an example of Data Definition Language (DDL)?