- All Exams Instant Download
Which three requirements must be met to query the table from the internet?
You need to query a table named Products in an Azure SQL database. Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. (Choose three.)A . You must be assigned the...
Which statement is an example of Data Manipulation Language (DML)?
Which statement is an example of Data Manipulation Language (DML)?A . INSERTB . DISABLEC . ALTERD . DROPView AnswerAnswer: A Explanation: Data Manipulation Language (DML) statements: DELETE INSERT UPDATE Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point
HOTSPOT For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability
To complete the sentence, select the appropriate option in the answer area
HOTSPOT To complete the sentence, select the appropriate option in the answer area. View AnswerAnswer: Explanation: Paginated Reports https://powerbi.microsoft.com/en-us/blog/announcing-paginated-reports-in-power-bi-general-availability/
Which storage solution supports role-based access control (RBAC) at the file and folder level?
Which storage solution supports role-based access control (RBAC) at the file and folder level?A . Azure Disk StorageB . Azure Data Lake StorageC . Azure Blob storageD . Azure Queue storageView AnswerAnswer: B Explanation: Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control
Which type of data store should you use?
Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network. Which type of data store should you use?A . Key/valueB . GraphC . DocumentD . columnarView AnswerAnswer: B Explanation: Data as it appears in the real...
You are reviewing the data model shown in the following exhibit
HOTSPOT You are reviewing the data model shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point View AnswerAnswer: Explanation: Reference: https://en.wikipedia.org/wiki/Snowflake_schema https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/
Which type of authentication should you use?
You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database. Which type of authentication should you use?A . service principal authenticationB . Azure Active Directory (Azure AD) authenticationC . SQL authenticationD . certificate authenticationView AnswerAnswer: B Explanation: Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview
When you create an Azure SQL database, which account can always connect to the database?
When you create an Azure SQL database, which account can always connect to the database?A . the Azure Active director/ (Azure AO) account that created the databaseB . the Azure Active Directly Azure AD) administrator accountC . the sa accountD . the server admin login account of the logical serverView...
Match the Azure services to appropriate requirements
DRAG DROP Match the Azure services to appropriate requirements. To answer, drag the appropriate services from the column on the left to its requirement on the right. Each service may be used once. more than once, or not at all. NOTE: Each correct match is worth one point. View AnswerAnswer:...
