DATA FOUNDATION AZURE

Hello friends if you are looking for DATA FOUNDATION AZURE TECH LEAP | DATA FOUNDATION AZURE MCQ with Answers | DATA FOUNDATION AZURE Objective type questions | DATA FOUNDATION AZURE Questions with Answers | DATA FOUNDATION AZURE Accenture

1.What are not not the components of Azure SQL?
-Azure COSMOS DB

2.Which of the following do you need to consider when you make a table in SQL?
-ALL THE ABOVE

3.Which sql statement is used to extract data from database?
-SELECT

4.What is the difference between a PRIMARY KEY and a UNIQUE KEY?
-unique can store null,primary can’t

5.Which data manipulation command is used to combine the records from one or more table?
-JOIN

6.In the existing table, ALTER TABLE statement is used to
-ALL OF THE ABOVE

7.Which of the following are TCL commands?
-LOOKUP

8.Which of the following is not Constraint in SQL?
-UNION

9.Data flow scripts are associated with
-Data flow scripts are associated with ADF and AZURE SYNAPSE ANALYTICShttps://t.me/accenturematerials09

10.Which of the following aggregate SQL function returns number of rows from a table
-count

11.sql supports single line comment,which of the following is single line comment
-minus sign

12.Blob storage is ideal for storing which data
-all of the above

13.what is not part of azure storage
-azure storage sql db

14.which statement in sql allows us to change the definition of a table is?
-ALTER COMMAND

15.Which type of join is used to returns rows that do not have matching values?
-outer join

16.which statement is used to get all data from the student table whose name starts with p
-Select * from stud where name LIKE’P%’

17.To sort the results of a query use
-order by

18.a subquery in an sql select statement is enclosed in
-parenthesis

19.which sql keyword is used to retrieve a maximum value
-max

20.which of the following is an example of unstructured data?
-audio and vidoe files

21.the command to remove rows from a table ‘CUSTOMER’ is
-delete from customer where

22.which of these features of azure sql managed instance is not provided by azure sql database?
-native support for cross database

23.when three or more AND and OR conditions are combined,it is easier to use the sql
-Both IN and not in

24.which of the following statement is true?
-both delete and truncate will free the space from table

25.which of the following choices isn’t a benefit of using cloud services
-geagraphic isolationhttps://t.me/accenturematerials09

26.which of these is a column family database
-azure cosmos DB mongo db

26.examine the description of the students table
-MIN(),COUNT()

27.which of the following statement….’whether’table?
-select*from weather where humidity between 60 and 75

28.how many primary keys can a sql table have?
-only one

29.sql query to find all the cities whose humidity is 95.
-select city from weather where humidity =95

30.azure data factory is composed of four core components…”it is created…kicked off”
-pipeline

31.we are working on a project…what will the result of the pipeline be?
-Reports success

32.identify the missing words in the following …Azure data factory is the cloud based…analytics.
-ETLhttps://t.me/accenturematerials09

33.Which of the following feature does not apply to resource groups?
-resource group can be nested

34.which azure storage option is better for storing data for backup and restore disaster recovery and archiving?
-azure blob storage

35.identify missing words…that together perform a task?
-pipeline

36.in modern datadase architecture which services are used the most to ingest the data
-azure data factory

37.___command makes the update performed by the transaction permanent in the database
-commit

38.examine the description of the stident table STD_ID NUMBER(4)…which two aggregate functions
are valid on the START_DATE column
-count,min

39.you can restrict access to azure sql database(allow only a specific range..
-server level firewall

40.which of the following statement are correct regarding the difference between TRUNCATE DELETE and DROP command
-1 and 3

41.you can perform __ operations on sql views?
-all of the above

42.The count function in sql returns the number of__
-values

43.which of the following do you need to consider when you make a table in sql?
-all of the above

44.what is cloud computing?
-both a & b

45.azure data factory pipeline can be used to do which of these activities?
-all of the abovehttps://t.me/accenturematerials09

46.data factory consists of several components.pick the wrong ones?
-notebooks

47.activities with azure data factory define the actions that will be performed on the data.
which are valid activity categories?
-data transformation activities

48.company which has a data lake storage…amazon s3 to azure data lake
-azure data factory

49.what connects an azure data factoryactivity to a dataset?
-linked services

50.which of the following is not ddl command
-update

51.the database language that allows us to access data in a database is called
-dql

52.how is data in a relational table organized
-rows and columns

53.you have started at a new job at a company which has a data lake storage gen2 account
-THE AZURE PORTAL

54.which one is not control flow in ADF?
-Exit/switch

55.with sql how can you return all the records from a table namedpersons
-order by firstname desc

56….the result of an sql select statement is called
-view

57….to ingest the data
-ADF

58…. Changes the structure of tables
-ddl

59.which of the following are the five built in functions
-count,avg,min,max,sum

60.data flow scripts are associated with
-ADF

61.How long is monitoring data stored in data factory?
-45 days

62.you have requirement to keep your files….your costs low?
-cold tier

63.you team is working on a project using the azure data factory…
which of the below is the correct location?
-data explorer

64.you are developing a computer vision application…
what should you use to orchestrate the workflow?
-azure data factory

67.installing a sql server database manually in windows virtual machine is classified as
-software as a service

Leave a comment